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
Execution time exceeded run time cap
Moderator: NorbertKrupa
Re: Execution time exceeded run time cap
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.
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
Vertica Consultant, Zazz Technologies LLC
Re: Execution time exceeded run time cap
Thanks Sharon. Unfortunately the destination database is not Vertica.
Jim
Jim