Debian Codegraph @

mysql-test/suite/galera/t/galera_mdev_10812.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --echo #
5 --echo # MDEV-10812: On COM_STMT_CLOSE/COM_QUIT, when wsrep_conflict_state
6 --echo # is ABORTED, it causes wrong response to be sent to the client
7 --echo #
8
9 # First create a deadlock
10 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
11 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
12 CREATE TABLE t1(a INT PRIMARY KEY);
13 INSERT INTO t1 VALUES(1),(2),(3);
14 START TRANSACTION ;
15 UPDATE t1 SET a=a+100;
16
17 --sleep 2
18 --connection node_2
19 UPDATE t1 SET a=a+100;
20
21 --sleep 2
22 --connection node_1a
23 # here we get deadlock error
24 --disconnect node_1a
25
26 --connection node_2
27 DROP TABLE t1;