Debian Codegraph @

mysql-test/suite/galera/r/mysql-wsrep#332.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 connection node_1;
5 CREATE TABLE p (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
6 CREATE TABLE c (f1 INTEGER PRIMARY KEY, p_id INTEGER) ENGINE=INNODB;
7 INSERT INTO p VALUES (1, 0);
8 INSERT INTO p VALUES (2, 0);
9 INSERT INTO c VALUES (1, 1);
10 INSERT INTO c VALUES (2, 2);
11 connection node_1;
12 SET AUTOCOMMIT=ON;
13 START TRANSACTION;
14 UPDATE p SET f1 = f1 + 100;
15 connection node_1a;
16 SET SESSION wsrep_sync_wait = 0;
17 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
18 connection node_2;
19 ALTER TABLE c ADD FOREIGN KEY (p_id) REFERENCES p(f1);
20 connection node_1a;
21 SET SESSION wsrep_on = 0;
22 SET SESSION wsrep_on = 1;
23 SET GLOBAL wsrep_provider_options = 'dbug=';
24 connection node_1;
25 COMMIT;
26 connection node_1a;
27 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
28 SET GLOBAL wsrep_provider_options = 'dbug=';
29 connection node_1;
30 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
31 connection node_2;
32 SELECT * FROM p;
33 f1 f2
34 1 0
35 2 0
36 SELECT * FROM c;
37 f1 p_id
38 1 1
39 2 2
40 DROP TABLE c;
41 DROP TABLE p;
42 connection node_1;
43 CREATE TABLE p1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
44 CREATE TABLE p2 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
45 CREATE TABLE c (f1 INTEGER PRIMARY KEY, p_id1 INTEGER, p_id2 INTEGER) ENGINE=INNODB;
46 INSERT INTO p1 VALUES (1, 0), (2, 0);
47 INSERT INTO p2 VALUES (1, 0), (2, 0);
48 INSERT INTO c VALUES (1, 1, 1);
49 INSERT INTO c VALUES (2, 2, 2);
50 connection node_1;
51 SET AUTOCOMMIT=ON;
52 START TRANSACTION;
53 UPDATE p1 SET f1 = f1 + 100;
54 connection node_1a;
55 SET SESSION wsrep_sync_wait = 0;
56 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
57 connection node_2;
58 ALTER TABLE c ADD FOREIGN KEY (p_id1) REFERENCES p1(f1), ADD FOREIGN KEY (p_id2) REFERENCES p2(f1);
59 connection node_1a;
60 SET SESSION wsrep_on = 0;
61 SET SESSION wsrep_on = 1;
62 SET GLOBAL wsrep_provider_options = 'dbug=';
63 connection node_1;
64 COMMIT;
65 connection node_1a;
66 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
67 SET GLOBAL wsrep_provider_options = 'dbug=';
68 connection node_1;
69 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
70 connection node_2;
71 SELECT * FROM p1;
72 f1 f2
73 1 0
74 2 0
75 SELECT * FROM p2;
76 f1 f2
77 1 0
78 2 0
79 SELECT * FROM c;
80 f1 p_id1 p_id2
81 1 1 1
82 2 2 2
83 DROP TABLE c;
84 DROP TABLE p1;
85 DROP TABLE p2;
86 connection node_1;
87 CREATE TABLE p1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
88 CREATE TABLE p2 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=INNODB;
89 CREATE TABLE c (f1 INTEGER PRIMARY KEY, p_id1 INTEGER, p_id2 INTEGER) ENGINE=INNODB;
90 INSERT INTO p1 VALUES (1, 0), (2, 0);
91 INSERT INTO p2 VALUES (1, 0), (2, 0);
92 INSERT INTO c VALUES (1, 1, 1);
93 INSERT INTO c VALUES (2, 2, 2);
94 connection node_1;
95 SET AUTOCOMMIT=ON;
96 START TRANSACTION;
97 UPDATE p2 SET f1 = f1 + 100;
98 connection node_1a;
99 SET SESSION wsrep_sync_wait = 0;
100 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
101 connection node_2;
102 ALTER TABLE c ADD FOREIGN KEY (p_id1) REFERENCES p1(f1), ADD FOREIGN KEY (p_id2) REFERENCES p2(f1);
103 connection node_1a;
104 SET SESSION wsrep_on = 0;
105 SET SESSION wsrep_on = 1;
106 SET GLOBAL wsrep_provider_options = 'dbug=';
107 connection node_1;
108 COMMIT;
109 connection node_1a;
110 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
111 SET GLOBAL wsrep_provider_options = 'dbug=';
112 connection node_1;
113 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
114 connection node_2;
115 SELECT * FROM p1;
116 f1 f2
117 1 0
118 2 0
119 SELECT * FROM p2;
120 f1 f2
121 1 0
122 2 0
123 SELECT * FROM c;
124 f1 p_id1 p_id2
125 1 1 1
126 2 2 2
127 DROP TABLE c;
128 DROP TABLE p1;
129 DROP TABLE p2;