Debian Codegraph @

mysql-test/suite/innodb/r/innodb_deadlock_with_autoinc.result

raw
1 #
2 # Bug #21983865 UNEXPECTED DEADLOCK WITH INNODB_AUTOINC_LOCK_MODE=0
3 #
4 create table t1(f1 int not null auto_increment primary key) engine=innodb;
5 # Hold autoinc_lock on table t1 from connection con1
6 set debug_sync='ib_after_row_insert SIGNAL others WAIT_FOR continue_others';
7 insert into t1 values(NULL);
8 # Create 40 connections and make it to wait for autoinc_lock on table t1.
9 # Release the auto_inc lock on table t1 for connection con1
10 set debug_sync='now SIGNAL continue_others';
11 # Now all 40 connections can finish the insert operation on t1.
12 drop table t1;