Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (
4 f1 VARCHAR(255) PRIMARY KEY
5 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
6 INSERT INTO t1 VALUES ('abc');
7 connection node_2;
8 SELECT f1 = 'abc' FROM t1;
9 f1 = 'abc'
10 1
11 connection node_1;
12 SET AUTOCOMMIT=OFF;
13 START TRANSACTION;
14 UPDATE t1 SET f1 = 'klm';
15 connection node_2;
16 SET AUTOCOMMIT=OFF;
17 START TRANSACTION;
18 UPDATE t1 SET f1 = 'xyz';
19 connection node_1;
20 COMMIT;
21 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
22 connection node_2a;
23 connection node_2;
24 COMMIT;
25 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
26 include/assert_grep.inc [cluster conflict due to high priority abort for threads]
27 DROP TABLE t1;