Debian Codegraph @

mysql-test/suite/innodb/t/innodb-index-online-delete.test

raw
1 --source include/have_innodb.inc
2 --source include/have_debug_sync.inc
3
4 # Save the initial number of concurrent sessions.
5 --source include/count_sessions.inc
6
7 connect (con1,localhost,root,,);
8
9 connection default;
10
11 CREATE TABLE t (a INT PRIMARY KEY, b INT NOT NULL) ENGINE=InnoDB;
12 INSERT INTO t VALUES(1,2),(2,3);
13
14 SET DEBUG_SYNC='alter_table_inplace_after_lock_downgrade SIGNAL do WAIT_FOR m';
15 SET DEBUG_SYNC='innodb_after_inplace_alter_table SIGNAL scanned WAIT_FOR done';
16 --send
17 CREATE INDEX tb ON t(b);
18
19 connection con1;
20 SET DEBUG_SYNC='now WAIT_FOR do';
21 SET DEBUG_SYNC='row_update_for_mysql_error SIGNAL m WAIT_FOR scanned';
22 --error ER_DUP_ENTRY
23 UPDATE t SET a=2 WHERE a=1;
24 call mtr.add_suppression('InnoDB: record in index .*tb was not found on rollback, trying to insert');
25 SET DEBUG_SYNC='now SIGNAL done';
26
27 disconnect con1;
28
29 connection default;
30 reap;
31 SET DEBUG_SYNC='RESET';
32 DROP TABLE t;
33
34 # Check that all connections opened by test cases in this file are really
35 # gone so execution of other tests won't be affected by their presence.
36 --source include/wait_until_count_sessions.inc