Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/GCF-606.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 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
8 connection node_1;
9 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
10 connection node_2;
11 SET SESSION wsrep_trx_fragment_size = 1;
12 SET AUTOCOMMIT=OFF;
13 START TRANSACTION;
14 INSERT INTO t1 VALUES (20);
15 INSERT INTO t1 VALUES (21);
16 INSERT INTO t1 VALUES (22);
17 INSERT INTO t1 VALUES (23);
18 INSERT INTO t1 VALUES (24);
19 connection node_1;
20 connection node_2a;
21 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
22 SET WSREP_ON=ON;
23 connection node_1;
24 connection node_2a;
25 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
26 connection node_1;
27 connection node_1;
28 SELECT COUNT(DISTINCT node_uuid) = 1 FROM mysql.wsrep_streaming_log;
29 COUNT(DISTINCT node_uuid) = 1
30 0
31 connection node_2;
32 COMMIT;
33 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
34 SELECT * FROM t1;
35 f1
36 COMMIT;
37 connection node_1;
38 SELECT * FROM t1;
39 f1
40 DROP TABLE t1;
41 connection node_2;
42 CALL mtr.add_suppression("WSREP: failed to send SR rollback for ");