Debian Codegraph @

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

raw
1 #
2 # SR: Node hang with one thread waiting in InnoDB
3 #
4 --source include/have_debug_sync.inc
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7 --source include/galera_have_debug_sync.inc
8
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(255)) ENGINE=InnoDB;
10 INSERT INTO t1 (f2) VALUES ('a');
11 INSERT INTO t1 (f2) VALUES ('b');
12 INSERT INTO t1 (f2) VALUES ('c');
13
14 --connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
15 --connection node_2a
16 SET SESSION wsrep_sync_wait = 0;
17 --let $galera_sync_point = after_certify_apply_monitor_enter
18 --source include/galera_set_sync_point.inc
19
20 --connection node_2
21 SET SESSION wsrep_retry_autocommit = 0;
22 SET SESSION wsrep_trx_fragment_size = 64;
23 --send DELETE FROM t1 ORDER BY f1 DESC LIMIT 2;
24
25 --connection node_2a
26 --source include/galera_wait_sync_point.inc
27
28 --connection node_1
29 INSERT INTO t1 (f2) VALUES ('d'),('e');
30
31 --connection node_2a
32 --source include/galera_signal_sync_point.inc
33 --source include/galera_clear_sync_point.inc
34
35 --connection node_2
36 --error ER_LOCK_DEADLOCK
37 --reap
38
39 DROP TABLE t1;