Debian Codegraph @

mysql-test/suite/galera_3nodes/r/MDEV-36360.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_3;
6 connection node_1;
7 CREATE TABLE parent (
8 id INT PRIMARY KEY
9 ) ENGINE=InnoDB;
10 CREATE TABLE child (
11 id INT PRIMARY KEY,
12 parent_id INT,
13 KEY (parent_id),
14 CONSTRAINT FOREIGN KEY (parent_id) REFERENCES parent(id)
15 ) ENGINE=InnoDB;
16 INSERT INTO parent VALUES (1), (2);
17 connection node_3;
18 SET SESSION wsrep_on = OFF;
19 DELETE FROM parent WHERE id = 1;
20 SET SESSION wsrep_on = ON;
21 Restarting server 3 with one applier thread having FK and UK checks disabled
22 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_after_write_row';
23 connection node_1;
24 INSERT INTO child VALUES (1, 2);
25 connection node_3;
26 SET DEBUG_SYNC = 'now WAIT_FOR sync.wsrep_after_write_row_reached';
27 SET GLOBAL DEBUG_DBUG = '';
28 SET wsrep_sync_wait = 0;
29 SET DEBUG_SYNC = 'ib_after_row_insert SIGNAL signal.wsrep_after_write_row';
30 INSERT INTO child VALUES (2, 2);
31 SET DEBUG_SYNC = 'RESET';
32 Server 3
33 SELECT COUNT(*) AS EXPECT_1 FROM parent;
34 EXPECT_1
35 1
36 SELECT COUNT(*) AS EXPECT_2 FROM child;
37 EXPECT_2
38 2
39 connection node_1;
40 Server 1
41 SET wsrep_sync_wait = 15;
42 SELECT COUNT(*) AS EXPECT_2 FROM parent;
43 EXPECT_2
44 2
45 SELECT COUNT(*) AS EXPECT_2 FROM child;
46 EXPECT_2
47 2
48 connection node_2;
49 Server 2
50 SET wsrep_sync_wait = 15;
51 SELECT COUNT(*) AS EXPECT_2 FROM parent;
52 EXPECT_2
53 2
54 SELECT COUNT(*) AS EXPECT_2 FROM child;
55 EXPECT_2
56 2
57 DROP TABLE child;
58 DROP TABLE parent;
59 disconnect node_2;
60 disconnect node_1;