Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/galera_sr_threeway_split.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connection node_1;
5 connection node_2;
6 connection node_3;
7 connection node_1;
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9 SET SESSION wsrep_trx_fragment_size = 1;
10 SET AUTOCOMMIT=OFF;
11 START TRANSACTION;
12 INSERT INTO t1 VALUES (10);
13 INSERT INTO t1 VALUES (11);
14 INSERT INTO t1 VALUES (12);
15 INSERT INTO t1 VALUES (13);
16 INSERT INTO t1 VALUES (14);
17 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
18 COUNT(*) > 0
19 1
20 connection node_2;
21 SET SESSION wsrep_trx_fragment_size = 1;
22 SET AUTOCOMMIT=OFF;
23 START TRANSACTION;
24 INSERT INTO t1 VALUES (200);
25 INSERT INTO t1 VALUES (201);
26 INSERT INTO t1 VALUES (202);
27 INSERT INTO t1 VALUES (203);
28 INSERT INTO t1 VALUES (204);
29 connection node_3;
30 SET SESSION wsrep_trx_fragment_size = 1;
31 SET AUTOCOMMIT=OFF;
32 START TRANSACTION;
33 INSERT INTO t1 VALUES (300);
34 INSERT INTO t1 VALUES (301);
35 INSERT INTO t1 VALUES (302);
36 INSERT INTO t1 VALUES (303);
37 INSERT INTO t1 VALUES (304);
38 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
39 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
40 connect node_3a, 127.0.0.1, root, , test, $NODE_MYPORT_3;
41 connection node_1a;
42 connection node_2a;
43 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
44 connection node_3a;
45 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
46 connection node_1a;
47 INSERT INTO t1 VALUES (20);
48 INSERT INTO t1 VALUES (21);
49 INSERT INTO t1 VALUES (22);
50 INSERT INTO t1 VALUES (23);
51 INSERT INTO t1 VALUES (24);
52 connection node_2a;
53 SET SESSION wsrep_on = ON;
54 SET SESSION wsrep_sync_wait = 15;
55 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
56 connection node_3a;
57 SET SESSION wsrep_on = ON;
58 SET SESSION wsrep_sync_wait = 15;
59 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
60 connection node_1a;
61 connection node_2a;
62 connection node_3a;
63 connection node_2;
64 COMMIT;
65 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
66 SELECT COUNT(DISTINCT node_uuid) = 1 FROM mysql.wsrep_streaming_log;
67 COUNT(DISTINCT node_uuid) = 1
68 1
69 wsrep_gcomm_uuid_match
70 1
71 connection node_3;
72 COMMIT;
73 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
74 SELECT COUNT(DISTINCT node_uuid) = 1 FROM mysql.wsrep_streaming_log;
75 COUNT(DISTINCT node_uuid) = 1
76 1
77 wsrep_gcomm_uuid_match
78 1
79 connection node_1;
80 SET innodb_snapshot_isolation=OFF;
81 INSERT INTO t1 VALUES (30);
82 INSERT INTO t1 VALUES (31);
83 INSERT INTO t1 VALUES (32);
84 INSERT INTO t1 VALUES (33);
85 INSERT INTO t1 VALUES (34);
86 COMMIT;
87 SELECT COUNT(*) = 15, MIN(f1) = 10, MAX(f1) = 34 FROM t1;
88 COUNT(*) = 15 MIN(f1) = 10 MAX(f1) = 34
89 1 1 1
90 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
91 COUNT(*) = 0
92 1
93 SET AUTOCOMMIT=ON;
94 connection node_2;
95 COMMIT;
96 SELECT COUNT(*) = 15, MIN(f1) = 10, MAX(f1) = 34 FROM t1;
97 COUNT(*) = 15 MIN(f1) = 10 MAX(f1) = 34
98 1 1 1
99 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
100 COUNT(*) = 0
101 1
102 SET AUTOCOMMIT=ON;
103 connection node_3;
104 COMMIT;
105 SELECT COUNT(*) = 15, MIN(f1) = 10, MAX(f1) = 34 FROM t1;
106 COUNT(*) = 15 MIN(f1) = 10 MAX(f1) = 34
107 1 1 1
108 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
109 COUNT(*) = 0
110 1
111 SET AUTOCOMMIT=ON;
112 DROP TABLE t1;
113 connection node_1;
114 CALL mtr.add_suppression("WSREP: failed to send SR rollback for ");
115 connection node_2;
116 CALL mtr.add_suppression("WSREP: failed to send SR rollback for ");
117 connection node_3;
118 CALL mtr.add_suppression("WSREP: failed to send SR rollback for ");