Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 SET SESSION wsrep_on = FALSE;
6 INSERT INTO t1 VALUES (2);
7 connection node_2;
8 SELECT COUNT(*) = 1 FROM t1;
9 COUNT(*) = 1
10 1
11 connection node_1;
12 SET GLOBAL wsrep_on = TRUE;
13 INSERT INTO t1 VALUES (3);
14 connection node_2;
15 SELECT COUNT(*) = 2 FROM t1;
16 COUNT(*) = 2
17 1
18 SELECT COUNT(*) = 0 FROM t1 WHERE f1 = 2;
19 COUNT(*) = 0
20 1
21 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 3;
22 COUNT(*) = 1
23 1
24 DROP TABLE t1;
25 connection node_1;
26 connection node_1;
27 START TRANSACTION;
28 SET SESSION wsrep_on=OFF;
29 ERROR 25000: You are not allowed to execute this command in a transaction
30 SET GLOBAL wsrep_on=OFF;
31 ERROR 25000: You are not allowed to execute this command in a transaction
32 COMMIT;
33 connection node_1;
34 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
35 START TRANSACTION;
36 INSERT INTO t1 VALUES (1);
37 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;;
38 connection node_1a;
39 SET GLOBAL wsrep_on = OFF;
40 connection node_1;
41 SHOW SESSION VARIABLES LIKE 'wsrep_on';
42 Variable_name Value
43 wsrep_on ON
44 SHOW GLOBAL VARIABLES LIKE 'wsrep_on';
45 Variable_name Value
46 wsrep_on OFF
47 INSERT INTO t1 VALUES (2);
48 COMMIT;
49 connection node_2;
50 SET SESSION wsrep_sync_wait = 15;
51 SELECT * FROM t1;
52 f1
53 1
54 2
55 connection node_1a;
56 SET GLOBAL wsrep_on = ON;
57 DROP TABLE t1;
58 connection node_2;
59 connection node_1;
60 SET GLOBAL wsrep_on = OFF;
61 connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;;
62 connection node_1b;
63 SHOW SESSION VARIABLES LIKE 'wsrep_on';
64 Variable_name Value
65 wsrep_on OFF
66 SHOW GLOBAL VARIABLES LIKE 'wsrep_on';
67 Variable_name Value
68 wsrep_on OFF
69 CREATE TABLE t2 (f1 INTEGER);
70 DROP TABLE t2;
71 SET GLOBAL wsrep_on = ON;
72 SHOW SESSION VARIABLES LIKE 'wsrep_on';
73 Variable_name Value
74 wsrep_on ON
75 disconnect node_1b;
76 connection node_2;
77 connection node_1;
78 SET GLOBAL wsrep_on = OFF;
79 SET SESSION wsrep_on = ON;
80 ERROR HY000: Can't enable @@session.wsrep_on, while @@global.wsrep_on is disabled
81 SET GLOBAL wsrep_on = ON;
82 SET SESSION wsrep_on = ON;
83 connection node_1;
84 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
85 SET GLOBAL wsrep_on = OFF;
86 connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;;
87 connection node_1b;
88 SHOW SESSION VARIABLES LIKE 'wsrep_on';
89 Variable_name Value
90 wsrep_on OFF
91 SHOW GLOBAL VARIABLES LIKE 'wsrep_on';
92 Variable_name Value
93 wsrep_on OFF
94 SET GLOBAL wsrep_on = ON;
95 START TRANSACTION;
96 INSERT INTO t1 VALUES(1);
97 COMMIT;
98 SELECT * FROM t1;
99 f1
100 1
101 connection node_2;
102 SELECT * FROM t1;
103 f1
104 1
105 DROP TABLE t1;
106 connection node_1;
107 connection node_1;
108 SET SESSION wsrep_on = OFF;
109 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
110 INSERT INTO t1 VALUES (1);
111 START TRANSACTION;
112 INSERT INTO t1 VALUES (2);
113 COMMIT;
114 DROP TABLE t1;
115 connection node_2;
116 SHOW TABLES;
117 Tables_in_test
118 connection node_1;
119 SET SESSION wsrep_on = ON;
120 SET GLOBAL wsrep_on = OFF;
121 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
122 INSERT INTO t1 VALUES (1);
123 START TRANSACTION;
124 INSERT INTO t1 VALUES (2);
125 COMMIT;
126 connection node_2;
127 SHOW TABLES;
128 Tables_in_test
129 connection node_1;
130 DROP TABLE t1;
131 SET GLOBAL wsrep_on = ON;
132 connection node_2;