Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_bf_abort_idle.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 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER);
6 INSERT INTO t1 VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1);
7 SET SESSION wsrep_trx_fragment_size=10;
8 SET SESSION wsrep_trx_fragment_unit='rows';
9 START TRANSACTION;
10 UPDATE t1 SET f2 = f2 + 10;
11 connection node_2;
12 INSERT INTO t1 VALUES (10,2);
13 connection node_1a;
14 connection node_1;
15 INSERT INTO t1 VALUES (9,1);
16 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
17 ROLLBACK;
18 DROP TABLE t1;
19 connection node_1;
20 CREATE TABLE t1(f1 INTEGER PRIMARY KEY, f2 INTEGER);
21 INSERT INTO t1 VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1);
22 SET SESSION wsrep_trx_fragment_size=5;
23 SET SESSION wsrep_trx_fragment_unit='rows';
24 START TRANSACTION;
25 UPDATE t1 SET f2 = f2 + 10;
26 connection node_2;
27 INSERT INTO t1 VALUES (10,2);
28 connection node_1a;
29 connection node_1;
30 INSERT INTO t1 VALUES (9,1);
31 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
32 ROLLBACK;
33 DROP TABLE t1;