Debian Codegraph @

mysql-test/suite/galera/r/galera_bf_abort_for_update.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INT) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1, 10);
5 connection node_1;
6 BEGIN;
7 SELECT * FROM t1 FOR UPDATE;
8 f1 f2
9 1 10
10 connection node_2;
11 UPDATE t1 SET f1 = 2;
12 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
13 connection node_1;
14 COMMIT;
15 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
16 wsrep_local_bf_aborts_diff
17 1
18 connection node_1;
19 BEGIN;
20 SELECT * FROM t1 FOR UPDATE;
21 f1 f2
22 2 10
23 connection node_2;
24 UPDATE t1 SET f2 = 20;
25 connection node_1a;
26 connection node_1;
27 COMMIT;
28 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
29 wsrep_local_bf_aborts_diff
30 1
31 DROP TABLE t1;