Debian Codegraph @

mysql-test/suite/galera_sr/r/GCF-1008.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
4 connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2;
5 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(255)) ENGINE=InnoDB;
6 connection node_2;
7 SET SESSION wsrep_trx_fragment_size = 1;
8 START TRANSACTION;
9 INSERT INTO t1 VALUES (1, 'x');
10 connection node_2a;
11 SET GLOBAL wsrep_provider_options = 'dbug=d,before_local_commit_monitor_enter';
12 connection node_2;
13 COMMIT;
14 connection node_2b;
15 SET SESSION wsrep_sync_wait = 0;
16 SELECT COUNT(*) AS EXPECT_0 FROM t1;
17 EXPECT_0
18 0
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 EXPECT_1
24 1
25 REPLACE INTO t1 VALUES (1,'y');
26 connection node_2b;
27 SELECT COUNT(*) AS EXPECT_0 FROM t1;
28 EXPECT_0
29 0
30 connection node_2a;
31 SET GLOBAL wsrep_provider_options = 'signal=before_local_commit_monitor_enter';
32 SET GLOBAL wsrep_provider_options = 'dbug=';
33 connection node_2;
34 SELECT COUNT(*) AS EXPECT_1 FROM t1;
35 EXPECT_1
36 1
37 DROP TABLE t1;
38 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(255)) ENGINE=InnoDB;
39 connection node_2;
40 SET SESSION wsrep_trx_fragment_size = 1;
41 START TRANSACTION;
42 INSERT INTO t1 VALUES (1, 'x');
43 connection node_2a;
44 SET GLOBAL wsrep_provider_options = 'dbug=d,before_certify_apply_monitor_enter';
45 connection node_2;
46 COMMIT;
47 connection node_2b;
48 SET SESSION wsrep_sync_wait = 0;
49 SELECT COUNT(*) AS EXPECT_0 FROM t1;
50 EXPECT_0
51 0
52 connection node_1;
53 SET SESSION wsrep_sync_wait = 0;
54 SET SESSION wsrep_trx_fragment_size = 1;
55 SELECT COUNT(*) AS EXPECT_1 FROM t1;
56 EXPECT_1
57 1
58 REPLACE INTO t1 VALUES (1,'y');
59 connection node_2b;
60 SELECT COUNT(*) AS EXPECT_0 FROM t1;
61 EXPECT_0
62 0
63 connection node_2a;
64 SET GLOBAL wsrep_provider_options = 'signal=before_certify_apply_monitor_enter';
65 SET GLOBAL wsrep_provider_options = 'dbug=';
66 connection node_2;
67 SELECT COUNT(*) AS EXPECT_1 FROM t1;
68 EXPECT_1
69 1
70 DROP TABLE t1;