id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 22291 transactions.atomic (with savepoints) doesn't work correctly with deadlocks in mysql err nobody "In mysql on deadlock occurance all savepoints will be deleted. so trying to rollback to previous savepoint will cause error: SAVEPOINT ... does not exist; here is example: {{{ 1 Query create table user2(id int primary key) engine=innodb; 1 Query set autocommit=0;INSERT INTO `user2` (`id`) VALUES (222); 2 Query set autocommit=0;SAVEPOINT `xxx`;INSERT INTO `user2` (`id`) VALUES (222); 1 Query UPDATE `user2` SET `id` = 111 WHERE NOT (`user2`.`id` = 222 );commit; -- after commit there will be deadlock in transaction 2 2 Query ROLLBACK TO SAVEPOINT `xxx`; }}} " Uncategorized closed Database layer (models, ORM) 1.6 Normal fixed Unreviewed 0 0 0 0 0 0