Debian Codegraph @

mysql-test/suite/galera/t/mysql-wsrep#90.test

raw
1 # Crash in galera_to_execute_end when wsrep_OSU_method is changed from RSU to TOI during a DDL
2
3 --source include/galera_cluster.inc
4 --source include/have_innodb.inc
5 --source include/have_debug_sync.inc
6
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
8
9 --connection node_1
10 SET GLOBAL wsrep_OSU_method = "RSU";
11 SET DEBUG_SYNC = 'alter_table_before_open_tables WAIT_FOR continue';
12 --send ALTER TABLE t1 ADD COLUMN f2 INTEGER;
13
14
15 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
16 --connection node_1a
17 SET SESSION wsrep_sync_wait = 0;
18 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = 'debug sync point: alter_table_before_open_tables'
19 --source include/wait_condition.inc
20
21 SET GLOBAL wsrep_OSU_method = "TOI";
22 SET DEBUG_SYNC= 'now SIGNAL continue';
23
24 --connection node_1
25 --reap
26
27 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
28
29 --connection node_2
30 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
31
32 --connection node_1
33 DROP TABLE t1;
34 SET DEBUG_SYNC = 'RESET';
35
36
37 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
38
39 --connection node_1
40 SET GLOBAL wsrep_OSU_method = "TOI";
41 SET DEBUG_SYNC = 'alter_table_before_open_tables WAIT_FOR continue';
42 --send ALTER TABLE t1 ADD COLUMN f2 INTEGER;
43
44 --connection node_1a
45 SET SESSION wsrep_sync_wait = 0;
46
47 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = 'debug sync point: alter_table_before_open_tables'
48 --source include/wait_condition.inc
49
50 SET GLOBAL wsrep_OSU_method = "RSU";
51 SET DEBUG_SYNC= 'now SIGNAL continue';
52
53 --connection node_1
54 --reap
55
56 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
57 INSERT INTO t1 VALUES (1,2);
58
59 --connection node_2
60 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
61 INSERT INTO t1 VALUES (3,4);
62
63 --connection node_1
64 DROP TABLE t1;
65
66 SET GLOBAL WSREP_OSU_METHOD = TOI;
67 SET DEBUG_SYNC = 'RESET';