Debian Codegraph @

mysql-test/suite/galera/r/galera_toi_ddl_locking.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
4 CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
5 SET SESSION wsrep_sync_wait = 0;
6 connection node_1;
7 SET DEBUG_SYNC= 'RESET';
8 SET DEBUG_SYNC = 'alter_table_before_open_tables SIGNAL before_open_tables WAIT_FOR continue';
9 ALTER TABLE t1 ADD COLUMN f2 INTEGER;;
10 connection node_1a;
11 SET DEBUG_SYNC= 'now WAIT_FOR before_open_tables';
12 SET wsrep_retry_autocommit=0;
13 SELECT COUNT(*) = 0 FROM t1;
14 COUNT(*) = 0
15 1
16 SELECT COUNT(*) = 0 FROM t2;
17 COUNT(*) = 0
18 1
19 INSERT INTO t1 VALUES (1);;
20 connection node_1c;
21 SET SESSION wsrep_sync_wait = 0;
22 SET AUTOCOMMIT=OFF;
23 START TRANSACTION;
24 SELECT COUNT(*) = 0 FROM t1;
25 COUNT(*) = 0
26 1
27 SELECT COUNT(*) = 0 FROM t2;
28 COUNT(*) = 0
29 1
30 INSERT INTO t2 VALUES (1);
31 COMMIT;;
32 connection node_1b;
33 SET SESSION wsrep_sync_wait = 0;
34 SELECT COUNT(*) = 0 FROM t2;
35 COUNT(*) = 0
36 1
37 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO = 'Commit';
38 COUNT(*) = 1
39 1
40 SET DEBUG_SYNC= 'now SIGNAL continue';
41 connection node_1a;
42 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
43 connection node_1c;
44 connection node_1;
45 SELECT COUNT(*) = 0 FROM t1;
46 COUNT(*) = 0
47 1
48 SELECT COUNT(*) = 1 FROM t2;
49 COUNT(*) = 1
50 1
51 SET debug_sync='RESET';
52 connection node_2;
53 SELECT COUNT(*) = 0 FROM t1;
54 COUNT(*) = 0
55 1
56 SELECT COUNT(*) = 1 FROM t2;
57 COUNT(*) = 1
58 1
59 DROP TABLE t1;
60 DROP TABLE t2;