Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-1008.inc

raw
1 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(255)) ENGINE=InnoDB;
2
3 --connection node_2
4 SET SESSION wsrep_trx_fragment_size = 1;
5 START TRANSACTION;
6 INSERT INTO t1 VALUES (1, 'x');
7
8 --connection node_2a
9 --source include/galera_set_sync_point.inc
10
11 --connection node_2
12 --send COMMIT
13
14 --connection node_2b
15 --sleep 1
16 SET SESSION wsrep_sync_wait = 0;
17 SELECT COUNT(*) AS EXPECT_0 FROM t1;
18
19 --connection node_1
20 SET SESSION wsrep_sync_wait = 0;
21 SET SESSION wsrep_trx_fragment_size = 1;
22 SELECT COUNT(*) AS EXPECT_1 FROM t1;
23 REPLACE INTO t1 VALUES (1,'y');
24
25 --connection node_2b
26 SELECT COUNT(*) AS EXPECT_0 FROM t1;
27
28 --connection node_2a
29 --source include/galera_signal_sync_point.inc
30 --source include/galera_clear_sync_point.inc
31
32 --connection node_2
33 --reap
34 --let $wait_condition = SELECT COUNT(*) = 1 FROM t1;
35 --source include/wait_condition.inc
36 SELECT COUNT(*) AS EXPECT_1 FROM t1;
37
38 DROP TABLE t1;