Debian Codegraph @

mysql-test/suite/galera/t/MW-259.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_debug_sync.inc
4
5 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
6 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER) Engine=InnoDB;
10
11 SET GLOBAL wsrep_desync=0;
12 SET wsrep_OSU_method=RSU;
13
14 SET DEBUG_SYNC = 'alter_table_before_open_tables WAIT_FOR continue';
15 --send ALTER TABLE t1 ADD COLUMN f2 INTEGER;
16
17 --connection node_1a
18
19 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = 'debug sync point: alter_table_before_open_tables'
20 --source include/wait_condition.inc
21
22 # wsrep_desync=1 will block
23 --send SET GLOBAL wsrep_desync=1;
24
25 --connection node_1b
26 --sleep 2
27 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO = 'SET GLOBAL wsrep_desync=1'
28 --source include/wait_condition.inc
29
30 SET DEBUG_SYNC= 'now SIGNAL continue';
31 DROP TABLE t1;
32 SET GLOBAL wsrep_desync=0;
33
34 --connection node_1
35 --reap
36
37 --connection node_1a
38 --reap
39
40 # Cleanup
41 SET DEBUG_SYNC= 'RESET';