Debian Codegraph @

mysql-test/suite/innodb/t/autoinc_debug.test

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4 --source include/not_embedded.inc
5
6 --disable_query_log
7 call mtr.add_suppression("InnoDB: Transaction was aborted due to ");
8 --enable_query_log
9
10 # Two parallel connection with autoinc column after restart.
11
12 CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY)ENGINE=INNODB;
13
14 --echo # SETTING auto_increment_increment IN CONNECTION DEFAULT
15 SET AUTO_INCREMENT_INCREMENT = 1;
16
17 --echo # MDEV-24348 InnoDB shutdown hang with innodb_flush_sync=0
18 SET GLOBAL innodb_flush_sync=OFF;
19 --echo # For the server to hang, we must have pages for temporary tables
20 --echo # (and the bug depended on MDEV-12227 not being fixed).
21 CREATE TEMPORARY TABLE t (id SERIAL) ENGINE=InnoDB;
22 SET debug_dbug= '+d,ib_log_flush_ahead';
23
24 INSERT INTO t1 VALUES(NULL);
25 SELECT * FROM t1;
26 SHOW CREATE TABLE t1;
27
28 --source include/restart_mysqld.inc
29
30 --echo # SETTING auto_increment_increment IN CONNECTION1
31 SET AUTO_INCREMENT_INCREMENT = 2;
32
33 SET DEBUG_SYNC= 'ib_after_row_insert SIGNAL opened WAIT_FOR flushed1';
34
35 SEND INSERT INTO t1 VALUES(NULL);
36
37 connect(con1, localhost, root,,);
38 SET AUTO_INCREMENT_INCREMENT = 2;
39 SET DEBUG_SYNC= 'now WAIT_FOR opened';
40 SET DEBUG_SYNC= 'ib_after_row_insert_step SIGNAL flushed1 WAIT_FOR opened1';
41 send insert into t1 values(NULL);
42
43 connection default;
44 reap;
45 SELECT * FROM t1;
46 SHOW CREATE TABLE t1;
47 SET DEBUG_SYNC= 'now SIGNAL opened1';
48
49 connection con1;
50 reap;
51 SELECT * FROM t1;
52 SHOW CREATE TABLE t1;
53 connection default;
54 disconnect con1;
55
56 DROP TABLE t1;
57
58 # Two parallel connection with autoinc column without restart.
59
60 CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY)ENGINE=INNODB;
61
62 --echo # SETTING auto_increment_increment IN CONNECTION DEFAULT
63 SET AUTO_INCREMENT_INCREMENT = 1;
64 INSERT INTO t1 VALUES(NULL);
65 SELECT * FROM t1;
66 SHOW CREATE TABLE t1;
67 SET DEBUG_SYNC = 'now SIGNAL flushed';
68
69 connect(con1, localhost, root,,);
70
71 --echo # SETTING auto_increment_increment in connection1
72 SET AUTO_INCREMENT_INCREMENT = 2;
73
74 SET DEBUG_SYNC= 'now WAIT_FOR flushed';
75 SET DEBUG_SYNC= 'ib_after_row_insert SIGNAL opened WAIT_FOR flushed1';
76
77 send INSERT INTO t1 values(NULL);
78
79 connection default;
80
81 SET DEBUG_SYNC= 'now WAIT_FOR opened';
82 SET DEBUG_SYNC= 'ib_after_row_insert_step SIGNAL flushed1 WAIT_FOR opened1';
83
84 send INSERT INTO t1 VALUES(NULL);
85
86 connection con1;
87 reap;
88 SELECT * FROM t1;
89 SHOW CREATE TABLE t1;
90 SET DEBUG_SYNC= 'now SIGNAL opened1';
91 disconnect con1;
92
93 connection default;
94 reap;
95 SELECT * FROM t1;
96 SHOW CREATE TABLE t1;
97 DROP TABLE t1;
98 SET DEBUG_SYNC='RESET';
99
100 --echo #
101 --echo # MDEV-33593: Auto increment deadlock error causes ASSERT in subsequent save point
102 --echo #
103
104 CREATE TABLE t1(col1 INT PRIMARY KEY AUTO_INCREMENT, col2 INT) ENGINE=InnoDB;
105 CREATE TABLE t2(col1 INT PRIMARY KEY) ENGINE=InnoDB;
106 INSERT INTO t1(col2) values(100);
107
108 --connect(con1, localhost, root,,)
109 START TRANSACTION;
110 --echo # T1: Acquiring Row X lock on table t2
111 INSERT INTO t2 values(100);
112
113 --connect(con2, localhost, root,,)
114 START TRANSACTION;
115 --echo # T2: Wait for (T1) row lock on t2 after acquiring GAP Lock on t1
116 UPDATE t1 SET col2 = 20 where col1 = 10;
117 SET DEBUG_SYNC='lock_wait_before_suspend SIGNAL t2_waiting';
118 --send INSERT INTO t2 values(100)
119
120 --connection default
121 SET DEBUG_SYNC='now WAIT_FOR t2_waiting';
122 --echo # T3: Wait for (T2) II row Lock on t1 after acquiring Auto Increment Lock on t1
123 SET DEBUG_SYNC='lock_wait_before_suspend SIGNAL t3_waiting';
124 --send INSERT INTO t1(col2) SELECT col2 from t1
125
126 --connection con1
127 SAVEPOINT s1;
128 SET DEBUG_SYNC='now WAIT_FOR t3_waiting';
129 --echo # T1: Wait for (T3) auto increment lock on t1 causing T1 -> T3 -> T2 -> T1 deadlock
130 SET debug_dbug = '+d,innodb_deadlock_victim_self';
131 --error ER_AUTOINC_READ_FAILED
132 INSERT INTO t1(col2) VALUES(200);
133
134 --echo # The transaction should have been rolled back
135 SELECT * FROM t1;
136 SELECT * FROM t2;
137
138 --echo # Release the previous savepoint using the same name
139 SAVEPOINT s1;
140 COMMIT;
141
142 --connection con2
143 --reap
144 COMMIT;
145
146 --connection default
147 --reap
148 COMMIT;
149
150 --disconnect con1
151 --disconnect con2
152
153 --echo # Cleanup
154 SELECT * FROM t1;
155 DROP TABLE t1;
156
157 SELECT * FROM t2;
158 DROP TABLE t2;
159
160 SET DEBUG_SYNC='RESET';
161
162 --echo #
163 --echo # End of 10.5 tests
164 --echo #