Question : This question already has answers here: Get transactions that failed or were never committed (3 answers) Closed 5 […]
Tag: rollback
after executing a back up cmd (via query) how to kill it
Question : I have a big database (150 GB) that needs a back up and I don’t have space in […]
Rollback parent procedure on failure in MySQL
Question : I have the following two procedures on my server: CREATE DEFINER=`someone`@`localhost` PROCEDURE `NewMagnet`( IN `nick` VARCHAR(32), IN `tth` […]
How to recover auto committed transaction in Oracle with normal privilage
Question : I have updated the table & need to rollback that changes. I have tried Rollback work command but […]
Dependent Transaction in separate Database-Connections
Question : I am quite new to database and I am in the following situation. I have two tables defining […]
How to configure read transactions to never cause other write serialization transactions to fail
Question : I am protecting critical transactions with application mutexes and SERIALIZABLE. I presume that this makes these operations as […]
Delete statement not responding to Kill session command
Question : Four days ago a user ran the command below on a table with 400,000,000 rows. It’s still running […]
Rollback of ALTER TABLE ALTER COLUMN command taking forever
Question : I have a very large table that needed a schema change to one column – I needed to […]
Truncating and inserting in a safe transaction on MySQL
Question : I am trying to TRUNCATE and INSERT data into a MySQL InnoDB table. I wanted to make sure […]
Transactional DDL workflow for MySQL
Question : I was a little surprised to discover that DDL statements (alter table, create index etc) implicitly commit the […]