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?

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'

Answers

  • 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'.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.