Debian Codegraph @

mysql-test/suite/galera/t/galera_var_reject_queries.test

raw
1 #
2 # Test wsrep_reject_queries
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INTEGER NOT NULL PRIMARY KEY) engine=innodb;
9
10 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
11
12 --connection node_1
13 --error ER_GLOBAL_VARIABLE
14 SET SESSION wsrep_reject_queries = ALL;
15
16 SET GLOBAL wsrep_reject_queries = ALL;
17
18 --error ER_UNKNOWN_COM_ERROR,1047
19 SELECT * FROM t1;
20
21 #
22 # Original behavior was lost connection,
23 # but since 10.1, we allow controlling connection to remain alive
24 #
25 --error 0,2013,2026
26 SET GLOBAL wsrep_reject_queries = ALL_KILL;
27
28 --connection node_1a
29 --error ER_CONNECTION_KILLED,2013,2006,2026
30 SELECT * FROM t1;
31
32 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
33 --error ER_UNKNOWN_COM_ERROR,1047
34 SELECT * FROM t1;
35
36 # Confirm that replication continues
37
38 --connection node_2
39 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
40 INSERT INTO t1 VALUES (1);
41
42 --connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1
43 SET GLOBAL wsrep_reject_queries = NONE;
44
45 SELECT COUNT(*) AS EXPECT_1 FROM t1;
46
47 DROP TABLE t1;