Question : I was a little surprised to discover that DDL statements (alter table, create index etc) implicitly commit the […]
Tag: rollback
connection pooling, transactions, nested transaction and rollback
Question : I’ve got strange behavior on production. First user request thru application failed, I’ve got SQLServerException with “Lock request […]
Implementing a Record Keeper/Rollback System for a MySQL Database
Question : What’s the best way to create a record keeping table for all actions in my database? I have […]
how to prevent dropping sysadmin user by another user in sql server
Question : I have a legacy application installed on my server which has configured to work only with one user […]
Mysql: How does a rollback operation be performed inside InnoDB
Question : I would like to hear in simple words Please answer me in simple words to the question on […]
How to find which transaction is being rolled back
Question : My MariaDB server crashed earlier today and is still recovering. The error log shows InnoDB: To roll back: […]
Stop rollback of anonymous DO code block?
Question : I’m executing some code through this anonymous DO code feature. I am observing that whenever it fails, all […]
If i issue a rollback when recovery mode is bulk logged, will my bulk operations be rolled back?
Question : If my recovery model is BULK LOGGED, I’m in a transaction, and I’ve issued some statements that are […]
How costly are InnoDB rollbacks?
Question : I recently heard a fellow co-worker mention that InnoDB rollbacks are costly and negatively impact performance. How true […]
How to stop ROLLBACK in progress?
Question : How do I stop a rollback in progress. I killed a very long running INSERT INTO table1 SELECT […]