Page 1 of 1

Execution time exceeded run time cap

Posted: Fri Sep 21, 2012 3:00 pm
by heatlamp
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

Re: Execution time exceeded run time cap

Posted: Fri Sep 21, 2012 4:49 pm
by scutter
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.

Re: Execution time exceeded run time cap

Posted: Fri Sep 21, 2012 10:22 pm
by heatlamp
Thanks Sharon. Unfortunately the destination database is not Vertica.

Jim