Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE ten (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
5 INSERT INTO ten VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6 CREATE TABLE t1 (f1 INTEGER, PRIMARY KEY (f1)) Engine=InnoDB;
7 CREATE TABLE t2 (f1 INTEGER, PRIMARY KEY (f1)) Engine=InnoDB;
8 SET GLOBAL wsrep_desync = 1;
9 show status like 'wsrep_desync_count';
10 Variable_name Value
11 wsrep_desync_count 1
12 SET DEBUG_SYNC='before_execute_sql_command SIGNAL alter1 WAIT_FOR alter2';
13 INSERT INTO t1 (f1) SELECT 0000 + (100 * a1.f1) + (10 * a2.f1) + a3.f1 FROM ten AS a1, ten AS a2, ten AS a3;
14 connection node_1a;
15 FLUSH STATUS;
16 SET GLOBAL wsrep_desync = 1;
17 Warnings:
18 Warning 1231 'wsrep_desync' is already ON.
19 show status like 'wsrep_desync_count';
20 Variable_name Value
21 wsrep_desync_count 1
22 SET DEBUG_SYNC='now WAIT_FOR alter1';
23 SET DEBUG_SYNC='before_execute_sql_command SIGNAL alter2';
24 INSERT INTO t2 (f1) SELECT 0000 + (100 * a1.f1) + (10 * a2.f1) + a3.f1 FROM ten AS a1, ten AS a2, ten AS a3;
25 connection node_1;
26 connection node_1a;
27 connection node_1;
28 SET DEBUG_SYNC='RESET';
29 SET GLOBAL wsrep_desync = 0;
30 show status like 'wsrep_desync_count';
31 Variable_name Value
32 wsrep_desync_count 0
33 SET GLOBAL wsrep_desync = 0;
34 Warnings:
35 Warning 1231 'wsrep_desync' is already OFF.
36 show status like 'wsrep_desync_count';
37 Variable_name Value
38 wsrep_desync_count 0
39 call mtr.add_suppression("Trying to make wsrep_desync = OFF on the node that is already synchronized\\.");
40 show status like 'wsrep_desync_count';
41 Variable_name Value
42 wsrep_desync_count 0
43 SET GLOBAL wsrep_desync = 0;
44 Warnings:
45 Warning 1231 'wsrep_desync' is already OFF.
46 SELECT COUNT(*) FROM t1;
47 COUNT(*)
48 1000
49 SELECT COUNT(*) FROM t2;
50 COUNT(*)
51 1000
52 DROP TABLE t1;
53 DROP TABLE t2;
54 DROP TABLE ten;