Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_cc_no_primary.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
5 connection node_1;
6 connection node_2;
7 connection node_1;
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
9 SET SESSION wsrep_trx_fragment_size=1;
10 BEGIN;
11 INSERT INTO t1 VALUES (10);
12 INSERT INTO t1 VALUES (11);
13 INSERT INTO t1 VALUES (12);
14 connection node_2;
15 SET SESSION wsrep_trx_fragment_size=1;
16 BEGIN;
17 INSERT INTO t1 VALUES (20);
18 INSERT INTO t1 VALUES (21);
19 INSERT INTO t1 VALUES (22);
20 SELECT COUNT(*) `expect 6` FROM mysql.wsrep_streaming_log;
21 expect 6
22 6
23 connection node_2a;
24 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 1';
25 SET SESSION wsrep_sync_wait = 0;
26 SHOW STATUS LIKE 'wsrep_cluster_size';
27 Variable_name Value
28 wsrep_cluster_size 1
29 SHOW STATUS LIKE 'wsrep_cluster_status';
30 Variable_name Value
31 wsrep_cluster_status non-Primary
32 SET SESSION wsrep_sync_wait = DEFAULT;
33 connection node_1a;
34 SET SESSION wsrep_sync_wait = 0;
35 SHOW STATUS LIKE 'wsrep_cluster_size';
36 Variable_name Value
37 wsrep_cluster_size 1
38 SHOW STATUS LIKE 'wsrep_cluster_status';
39 Variable_name Value
40 wsrep_cluster_status non-Primary
41 SET SESSION wsrep_sync_wait = DEFAULT;
42 connection node_2a;
43 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 0';
44 SHOW STATUS LIKE 'wsrep_cluster_size';
45 Variable_name Value
46 wsrep_cluster_size 2
47 connection node_1a;
48 SHOW STATUS LIKE 'wsrep_cluster_size';
49 Variable_name Value
50 wsrep_cluster_size 2
51 SELECT COUNT(*) `expect 0` FROM mysql.wsrep_streaming_log;
52 expect 0
53 0
54 connection node_2a;
55 SELECT COUNT(*) `expect 0` FROM mysql.wsrep_streaming_log;
56 expect 0
57 0
58 INSERT INTO t1 VALUES(10);
59 INSERT INTO t1 VALUES(20);
60 SELECT * FROM t1;
61 f1
62 10
63 20
64 connection node_1;
65 INSERT INTO t1 VALUES(13);
66 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
67 connection node_2;
68 INSERT INTO t1 VALUES(23);
69 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
70 DROP TABLE t1;