Debian Codegraph @

mysql-test/suite/galera/r/galera_var_reject_queries.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER NOT NULL PRIMARY KEY) engine=innodb;
4 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
5 connection node_1;
6 SET SESSION wsrep_reject_queries = ALL;
7 ERROR HY000: Variable 'wsrep_reject_queries' is a GLOBAL variable and should be set with SET GLOBAL
8 SET GLOBAL wsrep_reject_queries = ALL;
9 SELECT * FROM t1;
10 Got one of the listed errors
11 SET GLOBAL wsrep_reject_queries = ALL_KILL;
12 connection node_1a;
13 SELECT * FROM t1;
14 Got one of the listed errors
15 connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
16 SELECT * FROM t1;
17 Got one of the listed errors
18 connection node_2;
19 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
20 VARIABLE_VALUE = 2
21 1
22 INSERT INTO t1 VALUES (1);
23 connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1;
24 SET GLOBAL wsrep_reject_queries = NONE;
25 SELECT COUNT(*) AS EXPECT_1 FROM t1;
26 EXPECT_1
27 1
28 DROP TABLE t1;