Debian Codegraph @

mysql-test/suite/galera/t/galera-features#117.test

raw
1 #
2 # This test tests voting for DDLs (TOI events)
3 #
4 --source include/galera_cluster.inc
5 --source include/have_innodb.inc
6
7 # Save original auto_increment_offset values.
8 --let $node_1=node_1
9 --let $node_2=node_2
10 --source ../galera/include/auto_increment_offset_save.inc
11
12 --connection node_2
13 SET SESSION wsrep_on=OFF;
14 CREATE TABLE test.t1 (f2 INTEGER);
15 SET SESSION wsrep_on=ON;
16
17 --error ER_TABLE_EXISTS_ERROR
18 CREATE TABLE test.t1 (f1 INTEGER);
19
20 --connection node_1
21 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
22 --source include/wait_condition.inc
23 SHOW CREATE TABLE test.t1;
24 SHOW STATUS LIKE 'wsrep_cluster_status';
25 DROP TABLE test.t1;
26
27 --connection node_2
28 SET SESSION wsrep_sync_wait=0;
29 --let $wait_condition = SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
30 --source include/wait_condition.inc
31 SHOW CREATE TABLE test.t1;
32 SHOW STATUS LIKE 'wsrep_cluster_status';
33 --error ER_UNKNOWN_COM_ERROR
34 CREATE TABLE test.t2 (f1 INTEGER);
35 SHOW TABLES IN test;
36
37 --source include/kill_galera.inc
38 --source include/wait_until_disconnected.inc
39 --source include/start_mysqld.inc
40
41 CALL mtr.add_suppression("WSREP: Inconsistency detected: Inconsistent by consensus on ");
42 CALL mtr.add_suppression("WSREP: Failed to execute TOI action");
43 CALL mtr.add_suppression("WSREP: TO isolation end failed");
44
45 --connection node_1
46 # Restore original auto_increment_offset values.
47 --source ../galera/include/auto_increment_offset_restore.inc