Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
4 connection node_2a;
5 SELECT GET_LOCK("foo", 1000);
6 GET_LOCK("foo", 1000)
7 1
8 connection node_2;
9 SET AUTOCOMMIT=OFF;
10 INSERT INTO t1 VALUES (1);
11 SELECT GET_LOCK("foo", 1000);;
12 connection node_1;
13 INSERT INTO t1 VALUES (1);
14 connection node_2;
15 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
16 wsrep_local_aborts_increment
17 1
18 DROP TABLE t1;