Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 BLOB) ENGINE=InnoDB;
4 CREATE UNIQUE INDEX i1 ON t1 (f1(512));
5 SET AUTOCOMMIT=OFF;
6 START TRANSACTION;
7 SET SESSION wsrep_trx_fragment_size = 1024;
8 INSERT INTO t1 VALUES (REPEAT('a', 512));
9 INSERT INTO t1 VALUES (REPEAT('b', 512));
10 INSERT INTO t1 VALUES (REPEAT('c', 512));
11 INSERT INTO t1 VALUES (REPEAT('d', 512));
12 INSERT INTO t1 VALUES (REPEAT('e', 512));
13 INSERT INTO t1 VALUES (REPEAT('f', 512));
14 connection node_2;
15 connection node_1;
16 INSERT INTO t1 VALUES (REPEAT('g', 1024)),(REPEAT('c', 512));
17 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
18 connection node_1;
19 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
20 COUNT(*) = 0
21 1
22 connection node_2;
23 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
24 COUNT(*) = 0
25 1
26 connection node_1;
27 SET innodb_snapshot_isolation=OFF;
28 INSERT INTO t1 VALUES (REPEAT('d', 512));
29 INSERT INTO t1 VALUES (REPEAT('e', 512));
30 INSERT INTO t1 VALUES (REPEAT('f', 512));
31 COMMIT;
32 connection node_2;
33 SET AUTOCOMMIT=OFF;
34 START TRANSACTION;
35 INSERT INTO t1 VALUES (REPEAT('a', 512));
36 INSERT INTO t1 VALUES (REPEAT('b', 512));
37 INSERT INTO t1 VALUES (REPEAT('c', 512));
38 COMMIT;
39 connection node_1;
40 SELECT COUNT(*) = 6 FROM t1;
41 COUNT(*) = 6
42 1
43 connection node_2;
44 SELECT COUNT(*) = 6 FROM t1;
45 COUNT(*) = 6
46 1
47 DROP TABLE t1;