| 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; |