Execution time exceeded run time cap

Moderator: NorbertKrupa

Post Reply
heatlamp
Newbie
Newbie
Posts: 9
Joined: Mon Aug 20, 2012 11:59 pm

Execution time exceeded run time cap

Post by heatlamp » Fri Sep 21, 2012 3:00 pm

Hi,

I'm moving very large tables to a backup database using JDBC, and have run into this error

java.sql.SQLException: [Vertica][VJDBC](3326) ERROR: Execution time exceeded run time cap of 04:00
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.dataengine.VResultSet.fetchChunk(Unknown Source)
at com.vertica.dataengine.VResultSet.moveToNextRow(Unknown Source)

Anyone know how to get around this?

Thanks, Jim

scutter
Master
Master
Posts: 301
Joined: Tue Aug 07, 2012 2:15 am

Re: Execution time exceeded run time cap

Post by scutter » Fri Sep 21, 2012 4:49 pm

Assuming you haven't set RUNTIMECAP at the session level, it's picking up RUNTIMECAP from the resource pool or from the USER record. You could use a resource pool without a RUNTIMECAP or a user without a RUNTIMECAP.

You may also want to use COPY FROM VERTICA / EXPORT TO VERTICA instead, which is a more efficient way to transfer data between clusters.
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

heatlamp
Newbie
Newbie
Posts: 9
Joined: Mon Aug 20, 2012 11:59 pm

Re: Execution time exceeded run time cap

Post by heatlamp » Fri Sep 21, 2012 10:22 pm

Thanks Sharon. Unfortunately the destination database is not Vertica.

Jim

Post Reply

Return to “JDBC”