Debian Codegraph @

mysql-test/suite/galera/r/MDEV-33064.result

raw
1 connection node_2;
2 connection node_1;
3 connect con1,127.0.0.1,root,,test,$NODE_MYPORT_1;
4 CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=InnoDB;
5 CREATE TABLE t1_fk(c1 INT PRIMARY KEY, c2 INT, INDEX (c2), FOREIGN KEY (c2) REFERENCES t1(c1)) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES (1);
7 connection con1;
8 SET SESSION wsrep_retry_autocommit = 0;
9 SET DEBUG_SYNC = 'ib_after_row_insert SIGNAL may_alter WAIT_FOR bf_abort';
10 INSERT INTO t1_fk VALUES (1, 1);
11 connection node_1;
12 SET DEBUG_SYNC = 'now WAIT_FOR may_alter';
13 SET DEBUG_SYNC = 'lock_wait_end WAIT_FOR alter_continue';
14 ALTER TABLE t1 ADD COLUMN c2 INT, ALGORITHM=INPLACE;
15 connection con1;
16 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
17 SET DEBUG_SYNC = 'now SIGNAL alter_continue';
18 connection node_1;
19 connection node_2;
20 INSERT INTO t1 (c1, c2) VALUES (2, 2);
21 connection node_1;
22 SET DEBUG_SYNC = 'RESET';
23 DROP TABLE t1_fk, t1;
24 disconnect con1;
25 disconnect node_2;
26 disconnect node_1;