We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


"No transaction in progress" message occured in error_messages table frequently.. — Vertica Forum

"No transaction in progress" message occured in error_messages table frequently..

HyeontaeJuHyeontaeJu Vertica Customer

"No transaction in progress" message occured in error_messages table frequently..
why is the message occured??

Answers

  • moshegmosheg Vertica Employee Administrator

    As mentioned in the other thread, a COMMIT statement suppose to end a transaction and to make all changes that occurred during the transaction permanent and visible to other users.
    When DML statement fails, or when no transaction start before the COMMIT, the lonely COMMIT statement 'Cannot commit' because 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