Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-597.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --connection node_1
5 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
6
7 SET wsrep_trx_fragment_size = 1;
8
9 SET AUTOCOMMIT=OFF;
10 START TRANSACTION;
11
12 --connection node_2
13 SET AUTOCOMMIT=OFF;
14 START TRANSACTION;
15
16 INSERT INTO t1 VALUES (1);
17
18 --connection node_1
19 INSERT INTO t1 VALUES (1);
20 INSERT INTO t1 VALUES (2);
21 INSERT INTO t1 VALUES (3);
22 INSERT INTO t1 VALUES (4);
23 INSERT INTO t1 VALUES (5);
24
25 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
26 --connection node_1a
27 --let $wait_condition = SELECT COUNT(*) = 5 FROM mysql.wsrep_streaming_log
28 --source include/wait_condition.inc
29
30 --connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
31 --connection node_2a
32 --let $wait_condition = SELECT COUNT(*) = 5 FROM mysql.wsrep_streaming_log
33 --source include/wait_condition.inc
34
35 --connection node_2
36 --error ER_LOCK_DEADLOCK
37 ROLLBACK;
38
39 DROP TABLE t1;
40
41 --disconnect node_1a
42 --disconnect node_2a