Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connect replica, 127.0.0.1, root, , test, $NODE_MYPORT_2;
4 connect primary, 127.0.0.1, root, , test, $NODE_MYPORT_3;
5 create user repl@'%' identified by 'repl';
6 grant all on *.* to repl@'%';
7 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
8 connection node_1;
9 connection replica;
10 connection primary;
11 connection replica;
12 START SLAVE;
13 connection primary;
14 CREATE TABLE t1 (id bigint auto_increment primary key, msg varchar(100)) engine=innodb;
15 # Intentionally generate 1k GTID-events
16 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
17 EXPECT_1000
18 1000
19 connection replica;
20 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
21 EXPECT_1
22 1
23 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
24 EXPECT_1
25 1
26 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
27 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
28 0-3-1004 0-3-1004 0-3-1004
29 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
30 EXPECT_1000
31 1000
32 connection node_1;
33 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
34 EXPECT_1
35 1
36 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
37 EXPECT_1
38 1
39 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
40 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
41 0-3-1004 0-3-1004 0-3-1004
42 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
43 EXPECT_1000
44 1000
45 connection replica;
46 # Verify that graceful shutdown succeeds in replica.
47 # Force SST
48 connection node_1;
49 # Waiting until replica is not part of cluster anymore
50 connection replica;
51 # Start replica again
52 # Wait until replica is back on cluster
53 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
54 EXPECT_1
55 1
56 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
57 EXPECT_1
58 1
59 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
60 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
61 0-3-1004 0-3-1004 0-3-1004
62 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
63 EXPECT_1000
64 1000
65 connection node_1;
66 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
67 EXPECT_1
68 1
69 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
70 EXPECT_1
71 1
72 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
73 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
74 0-3-1004 0-3-1004 0-3-1004
75 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
76 EXPECT_1000
77 1000
78 connection primary;
79 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
80 EXPECT_1000
81 1000
82 drop table t1;
83 connection replica;
84 connection node_1;
85 connection primary;
86 CREATE TABLE t1 (id bigint auto_increment primary key, msg varchar(100)) engine=innodb;
87 # Intentionally generate 1k GTID-events
88 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
89 EXPECT_1000
90 1000
91 connection replica;
92 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
93 EXPECT_1
94 1
95 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
96 EXPECT_1
97 1
98 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
99 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
100 0-3-2006 0-3-2006 0-3-2006
101 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
102 EXPECT_1000
103 1000
104 connection node_1;
105 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
106 EXPECT_1
107 1
108 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
109 EXPECT_1
110 1
111 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
112 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
113 0-3-2006 0-3-2006 0-3-2006
114 connection replica;
115 # Verify that graceful shutdown succeeds in replica.
116 # Force SST
117 connection node_1;
118 # Waiting until replica is not part of cluster anymore
119 # Add writes to primary
120 connection primary;
121 # Intentionally generate 1k GTID-events
122 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
123 EXPECT_2000
124 2000
125 connection replica;
126 # Start replica again
127 # Wait until replica is back on cluster
128 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
129 EXPECT_1
130 1
131 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
132 EXPECT_1
133 1
134 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
135 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
136 0-3-3006 0-3-3006 0-3-3006
137 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
138 EXPECT_2000
139 2000
140 connection node_1;
141 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
142 EXPECT_1
143 1
144 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
145 EXPECT_1
146 1
147 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
148 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
149 0-3-3006 0-3-3006 0-3-3006
150 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
151 EXPECT_2000
152 2000
153 connection primary;
154 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
155 EXPECT_2000
156 2000
157 drop table t1;
158 connection replica;
159 connection node_1;
160 connection replica;
161 STOP SLAVE;
162 RESET SLAVE ALL;
163 connection primary;
164 RESET MASTER;
165 connection node_1;
166 disconnect primary;
167 disconnect replica;
168 disconnect node_2;
169 disconnect node_1;
170 # End of test