The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Why is the error occured?
HyeontaeJu Vertica Customer ✭
edited December 2020 in General Discussion
I Use spring batch and i run the application
by the way, sometime the error is occured when the application is doing merge into task.
Cause: java.sql.SQLNonTransientException: [Vertica]VJDBC ERROR: DDL statement interfered with this statement
and error_messages table sometimes occured this message 'Cannot commit; no transaction in progress'
1) Which DDL statements were running at the error time? Can you check your Vertica logs and see what, if any, other statements were running at the same time as the statement that errored out?
If it is a failed INSERT statement, see: https://forum.vertica.com/discussion/221321/vertica-vjdbc-3007-error-ddl-statement-interfered-with-this-statement
2) COMMIT suppose to end the transaction and to make all changes that occurred during the transaction permanent and visible to other users.
However, when the previous DML statement fail and no transaction starts, the following COMMIT statement may complain that it 'Cannot commit' since there is 'no transaction in progress'.