Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_2;
4 SET GLOBAL wsrep_slave_threads=2;
5 CREATE TABLE t1 (
6 id INTEGER PRIMARY KEY,
7 f2 INTEGER);
8 CREATE TABLE t2 (
9 f1 INT PRIMARY KEY,
10 t1_id INT NOT NULL,
11 f2 INTEGER NOT NULL,
12 KEY key_t1_id(t1_id),
13 CONSTRAINT key_t1_id FOREIGN KEY (t1_id) REFERENCES t1 (id) ON UPDATE CASCADE ON DELETE CASCADE);
14 INSERT INTO t1 VALUES (1,0);
15 INSERT INTO t1 VALUES (2,0);
16 INSERT INTO t2 VALUES (1,1,1234);
17 INSERT INTO t2 VALUES (2,2,1234);
18 connection node_2;
19 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_toi";
20 connection node_1;
21 DROP TABLE t2;
22 connection node_2;
23 SET DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_toi_reached";
24 SET SESSION wsrep_sync_wait = 0;
25 1
26 connection node_1;
27 UPDATE t1 SET f2 = 1 WHERE id=2;
28 connection node_2;
29 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_toi";
30 SET SESSION wsrep_sync_wait = DEFAULT;
31 SELECT * FROM t1;
32 id f2
33 1 0
34 2 1
35 SET DEBUG_SYNC = 'RESET';
36 SET GLOBAL DEBUG_DBUG = '';
37 SET GLOBAL wsrep_slave_threads = DEFAULT;
38 DROP TABLE t1;