Automatic Rollback if COMMIT TRANSACTION is not reached

by

No, transactions are not rolled back as soon as an error occurs. But you may be using a client-application which applies this policy.

For example, if you are using the mysql command-line client, then it normally stops executing when an error occurs and will quit. Quitting while a transaction is in progress does cause it to be rolled back.

When you are writing your own application, you can control the policy on rollback, but there are some exceptions:

  • Quitting (i.e. disconnecting from the database) always rolls back a transaction in progress
  • A deadlock or lock-wait timeout implicitly causes a rollback

Other than these conditions, if you invoke a command which generates an error, the error is returned as normal, and you are free to do whatever you like, including committing the transaction anyway.

More Related Contents:

  1. mysql transaction – roll back on any exception
  2. How to debug Lock wait timeout exceeded on MySQL?
  3. MySQL AUTO_INCREMENT does not ROLLBACK
  4. Are nested transactions allowed in MySQL?
  5. MySQL : transaction within a stored procedure
  6. When to use SELECT … FOR UPDATE?
  7. How to enable INNODB in mysql
  8. How to display open transactions in MySQL
  9. How can I use transactions in my MySQL stored procedure?
  10. Fixing “Lock wait timeout exceeded; try restarting transaction” for a ‘stuck” Mysql table?
  11. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  12. How can I undo a mysql statement that I just executed?
  13. MySQL ‘select for update’ behaviour
  14. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  15. Why does MYSQL higher LIMIT offset slow the query down?
  16. Normalization in MYSQL
  17. Is there a REAL performance difference between INT and VARCHAR primary keys?
  18. JOIN queries vs multiple queries
  19. Getting around MySQL “Can’t reopen table” error
  20. Can’t Create Entity Data Model – using MySql and EF6
  21. In MySQL, can I copy one row to insert into the same table?
  22. MySQL: Cloning a MySQL database on the same MySql instance
  23. MySQL sharding approaches?
  24. Can MySQL convert a stored UTC time to local timezone?
  25. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  26. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  27. Does Order of Fields of Multi-Column Index in MySQL Matter
  28. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  29. How to select non “unique” rows
  30. Auto-increment is not resetting in MySQL

Leave a Comment