Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/GCF-817.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) ENGINE=InnoDB;
9 SET SESSION wsrep_trx_fragment_size = 1;
10 SET AUTOCOMMIT=OFF;
11 START TRANSACTION;
12 INSERT INTO t1 VALUES (1);
13 INSERT INTO t1 VALUES (2);
14 INSERT INTO t1 VALUES (3);
15 INSERT INTO t1 VALUES (4);
16 INSERT INTO t1 VALUES (5);
17 INSERT INTO t1 VALUES (6);
18 INSERT INTO t1 VALUES (7);
19 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
20 SET SESSION wsrep_sync_wait = 0;
21 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
22 COUNT(*) > 0
23 1
24 connection node_2;
25 connection node_1a;
26 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=1';
27 SET SESSION wsrep_on = OFF;
28 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
29 COUNT(*) > 0
30 1
31 connection node_2;
32 connection node_3;
33 connection node_1a;
34 connection node_1a;
35 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=0';
36 connection node_3;
37 connection node_1a;
38 connection node_2;
39 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
40 COUNT(*) = 0
41 1
42 connection node_1;
43 COMMIT;
44 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
45 connection node_1a;
46 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
47 COUNT(*) = 0
48 1
49 connection node_2;
50 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
51 COUNT(*) = 0
52 1
53 connection node_2;
54 DROP TABLE t1;