JDBC error 11800
Posted: Fri May 27, 2016 10:50 am
Hi all.
We are loading data into our Vertica db through a
COPY %s FROM STDIN
SQL statement, feeded by a PipedInputStream.
Sporadically we get the following error:
2016-05-27 01:39:36.014 TE>> WARNING: pool-2-thread-8: error copying data [com.ti.serviceGuard.dataModel.values.dao.vertica.EntityStorageVertica$AsynchEntityManager$Writer$1 run()]
2016-05-27 01:39:36.014 TE>> java.sql.SQLException: [Vertica][JDBC](11800) Transaction callbacks are not allowed during explicit JDBC API transaction calls.
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.common.SConnection.notifyBeginTransaction(Unknown Source)
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.common.STransactionStateListener.notifyBeginTransaction(Unknown Source)
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.VerticaCopyStream.start(Unknown Source)
2016-05-27 01:39:36.014 TE>> at com.ti.serviceGuard.dataModel.values.dao.vertica.EntityStorageVertica$AsynchEntityManager$Writer$1.run(EntityStorageVertica.java:484)
Does anybody know what that means? How comes it is not deterministic? How can I fix it?
Thank you.
We are loading data into our Vertica db through a
COPY %s FROM STDIN
SQL statement, feeded by a PipedInputStream.
Sporadically we get the following error:
2016-05-27 01:39:36.014 TE>> WARNING: pool-2-thread-8: error copying data [com.ti.serviceGuard.dataModel.values.dao.vertica.EntityStorageVertica$AsynchEntityManager$Writer$1 run()]
2016-05-27 01:39:36.014 TE>> java.sql.SQLException: [Vertica][JDBC](11800) Transaction callbacks are not allowed during explicit JDBC API transaction calls.
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.common.SConnection.notifyBeginTransaction(Unknown Source)
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.common.STransactionStateListener.notifyBeginTransaction(Unknown Source)
2016-05-27 01:39:36.014 TE>> at com.vertica.jdbc.VerticaCopyStream.start(Unknown Source)
2016-05-27 01:39:36.014 TE>> at com.ti.serviceGuard.dataModel.values.dao.vertica.EntityStorageVertica$AsynchEntityManager$Writer$1.run(EntityStorageVertica.java:484)
Does anybody know what that means? How comes it is not deterministic? How can I fix it?
Thank you.