Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 connection node_1;
5 SET SESSION wsrep_trx_fragment_size = 1;
6 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
7 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY);
8 INSERT INTO t2 VALUES (1),(2),(3);
9 ALTER TABLE t2 DROP PRIMARY KEY;
10 INSERT INTO t2 VALUES (1);
11 SET SESSION wsrep_trx_fragment_size = 1;
12 START TRANSACTION;
13 INSERT INTO t1 SELECT * FROM t2;
14 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
15 SELECT * FROM t1;
16 f1
17 connection node_2;
18 SELECT * FROM t1;
19 f1
20 connection node_1;
21 DROP TABLE t1;
22 DROP TABLE t2;
23 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(10)) ENGINE=InnoDB;
24 connection node_1;
25 SET innodb_snapshot_isolation = OFF;
26 SET SESSION wsrep_trx_fragment_size = 1;
27 START TRANSACTION;
28 INSERT INTO t1 VALUES (1, 'node1');
29 connection node_1a;
30 INSERT INTO t1 VALUES (5, 'node2');
31 connection node_1;
32 INSERT INTO t1 VALUES (5, 'node1');
33 ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
34 SELECT * FROM t1;
35 f1 f2
36 1 node1
37 5 node2
38 SET SESSION wsrep_trx_fragment_size = 10000;
39 START TRANSACTION;
40 INSERT INTO t1 VALUE (10, 'node1');
41 connection node_1a;
42 INSERT INTO t1 VALUES(15, 'node2');
43 connection node_1;
44 SELECT * FROM t1;
45 f1 f2
46 1 node1
47 5 node2
48 10 node1
49 15 node2
50 INSERT INTO t1 VALUES(15, 'node1');
51 ERROR 23000: Duplicate entry '15' for key 'PRIMARY'
52 COMMIT;
53 SELECT * FROM t1;
54 f1 f2
55 1 node1
56 5 node2
57 10 node1
58 15 node2
59 DROP TABLE t1;