deadlock with innodb_autoinc_lock_mode=0

innodb.innodb_deadlock_with_autoinc 'innodb' [ fail ]

        Test ended at 2017-11-10 14:00:05

CURRENT_TEST: innodb.innodb_deadlock_with_autoinc

mysqltest: At line 44: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction

The result from queries just before the failure was:

< snip >

# Bug #21983865  UNEXPECTED DEADLOCK WITH INNODB_AUTOINC_LOCK_MODE=0

#

create table t1(f1 int not null auto_increment primary key) engine=innodb;

# Hold autoinc_lock on table t1 from connection con1

connect  con1, localhost, root;

set debug_sync='ib_after_row_insert SIGNAL others WAIT_FOR continue_others';

insert into t1 values(NULL);

connection default;

# Create 40 connections and make it to wait for autoinc_lock on table t1.

# Release the auto_inc lock on table t1 for connection con1

set debug_sync='now SIGNAL continue_others';

# Now all 40 connections can finish the insert operation on t1.

connection default;

disconnect con40;

connection con1;

connection default;

disconnect con1;

connection con2;