Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-1018B.test

raw
1 #
2 # SR: Node hang with one thread waiting in InnoDB
3 #
4 --source include/galera_cluster.inc
5 --source include/big_test.inc
6
7 --connection node_1
8 SET SESSION wsrep_sync_wait = 0;
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(255)) ENGINE=InnoDB;
10 SET SESSION wsrep_trx_fragment_size = 64;
11 SET SESSION innodb_lock_wait_timeout = 1000;
12
13 --connection node_2
14 SET SESSION wsrep_sync_wait = 0;
15 SET SESSION wsrep_trx_fragment_size = 64;
16 SET SESSION innodb_lock_wait_timeout = 1000;
17
18 --let $count = 500
19 --disable_query_log
20 while ($count)
21 {
22 --connection node_1
23 --send INSERT INTO t1 (f2) VALUES ('abc'),('abc');
24
25 --connection node_2
26 --send DELETE FROM t1 ORDER BY f1 DESC LIMIT 2;
27
28 --connection node_1
29 --error 0,ER_LOCK_DEADLOCK,ER_DUP_ENTRY,ER_LOCK_WAIT_TIMEOUT,ER_QUERY_INTERRUPTED
30 --reap
31
32 --connection node_2
33 --error 0,ER_LOCK_DEADLOCK,ER_DUP_ENTRY,ER_LOCK_WAIT_TIMEOUT,ER_QUERY_INTERRUPTED
34 --reap
35
36 --dec $count
37 }
38 --enable_query_log
39
40 DROP TABLE t1;