Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV-10161: wsrep_sync_wait not enabled when set to 1 in config file
5 #
6 SELECT @@global.wsrep_sync_wait;
7 @@global.wsrep_sync_wait
8 15
9 connection node_1;
10 CREATE TABLE t1 (f1 INT PRIMARY KEY) Engine=InnoDB;
11 connection node_2;
12 SET GLOBAL wsrep_sync_wait = 1;
13 SELECT COUNT(*) = 0 FROM t1;
14 COUNT(*) = 0
15 1
16 connection node_1;
17 CREATE TABLE t2 (f1 INT PRIMARY KEY) Engine=InnoDB;
18 connection node_2;
19 SET GLOBAL wsrep_sync_wait = 4;
20 INSERT INTO t2 VALUES (1);
21 connection node_1;
22 CREATE TABLE t3 (f1 INT PRIMARY KEY) Engine=InnoDB;
23 INSERT INTO t3 VALUES (1);
24 connection node_2;
25 SET GLOBAL wsrep_sync_wait = 2;
26 UPDATE t3 SET f1 = 2;
27 affected rows: 1
28 info: Rows matched: 1 Changed: 1 Warnings: 0
29 connection node_2;
30 SET GLOBAL wsrep_sync_wait = 15;
31 DROP TABLE t1;
32 DROP TABLE t2;
33 DROP TABLE t3;