Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_purged_maintained.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 ######## Initialize ########
7 CREATE TABLE t1 (a INT) ENGINE = InnoDB;
8 include/sync_slave_sql_with_master.inc
9 ######## corruption_mode = 1 of 2 ########
10 Phase one: Generating logs
11 include/rpl_reset.inc
12 ======== restart_i = 1 of 2 ========
13 include/stop_slave.inc
14 include/rpl_restart_server.inc [server_number=1 gtids=on parameters: --debug=d,skip_writing_previous_gtids_log_event]
15 include/rpl_restart_server.inc [server_number=1 gtids=on]
16 include/start_slave.inc
17 -------- flush_i = 1 of 2 --------
18 FLUSH LOGS;
19 INSERT INTO t1 VALUES (1);
20 FLUSH LOGS;
21 [on slave]
22 include/sync_slave_sql_with_master.inc
23 include/assert.inc [no gtids lost yet on slave]
24 include/assert.inc [committed gno 1 on slave]
25 [on master]
26 include/assert.inc [no gtids lost yet on master]
27 include/assert.inc [committed gno 1 on master]
28 -------- flush_i = 2 of 2 --------
29 FLUSH LOGS;
30 INSERT INTO t1 VALUES (2);
31 INSERT INTO t1 VALUES (3);
32 FLUSH LOGS;
33 [on slave]
34 include/sync_slave_sql_with_master.inc
35 include/assert.inc [no gtids lost yet on slave]
36 include/assert.inc [committed gno 3 on slave]
37 [on master]
38 include/assert.inc [no gtids lost yet on master]
39 include/assert.inc [committed gno 3 on master]
40 ======== restart_i = 2 of 2 ========
41 include/stop_slave.inc
42 include/rpl_restart_server.inc [server_number=1 gtids=on parameters: --debug=d,skip_writing_previous_gtids_log_event]
43 include/rpl_restart_server.inc [server_number=1 gtids=on]
44 include/start_slave.inc
45 -------- flush_i = 1 of 2 --------
46 FLUSH LOGS;
47 INSERT INTO t1 VALUES (4);
48 FLUSH LOGS;
49 [on slave]
50 include/sync_slave_sql_with_master.inc
51 include/assert.inc [no gtids lost yet on slave]
52 include/assert.inc [committed gno 4 on slave]
53 [on master]
54 include/assert.inc [no gtids lost yet on master]
55 include/assert.inc [committed gno 4 on master]
56 -------- flush_i = 2 of 2 --------
57 FLUSH LOGS;
58 INSERT INTO t1 VALUES (5);
59 INSERT INTO t1 VALUES (6);
60 FLUSH LOGS;
61 [on slave]
62 include/sync_slave_sql_with_master.inc
63 include/assert.inc [no gtids lost yet on slave]
64 include/assert.inc [committed gno 6 on slave]
65 [on master]
66 include/assert.inc [no gtids lost yet on master]
67 include/assert.inc [committed gno 6 on master]
68 FLUSH LOGS;
69 include/sync_slave_sql_with_master.inc
70 ######## corruption_mode = 1 ########
71 Phase two: Purging logs
72 ======== restart_i = 1 of 2 ========
73 include/purge_first_log.inc
74 include/assert.inc [lost gtids from 1 to 0 on master]
75 include/purge_first_log.inc
76 include/assert.inc [lost gtids from 1 to 0 on master]
77 -------- flush_i = 1 of 2 --------
78 include/purge_first_log.inc
79 include/assert.inc [lost gtids from 1 to 0 on master]
80 include/purge_first_log.inc
81 include/assert.inc [lost gtids from 1 to 1 on master]
82 -------- flush_i = 2 of 2 --------
83 include/purge_first_log.inc
84 include/assert.inc [lost gtids from 1 to 1 on master]
85 include/purge_first_log.inc
86 include/assert.inc [lost gtids from 1 to 3 on master]
87 ======== restart_i = 2 of 2 ========
88 include/purge_first_log.inc
89 include/assert.inc [lost gtids from 1 to 3 on master]
90 include/purge_first_log.inc
91 include/assert.inc [lost gtids from 1 to 3 on master]
92 -------- flush_i = 1 of 2 --------
93 include/purge_first_log.inc
94 include/assert.inc [lost gtids from 1 to 3 on master]
95 include/purge_first_log.inc
96 include/assert.inc [lost gtids from 1 to 4 on master]
97 -------- flush_i = 2 of 2 --------
98 include/purge_first_log.inc
99 include/assert.inc [lost gtids from 1 to 4 on master]
100 include/purge_first_log.inc
101 include/assert.inc [lost gtids from 1 to 6 on master]
102 ######## corruption_mode = 2 of 2 ########
103 Phase one: Generating logs
104 include/rpl_reset.inc
105 ======== restart_i = 1 of 2 ========
106 include/stop_slave.inc
107 include/rpl_restart_server.inc [server_number=1 gtids=on]
108 include/rpl_restart_server.inc [server_number=1 gtids=on]
109 include/start_slave.inc
110 -------- flush_i = 1 of 2 --------
111 FLUSH LOGS;
112 INSERT INTO t1 VALUES (1);
113 FLUSH LOGS;
114 [on slave]
115 include/sync_slave_sql_with_master.inc
116 include/assert.inc [no gtids lost yet on slave]
117 include/assert.inc [committed gno 1 on slave]
118 [on master]
119 include/assert.inc [no gtids lost yet on master]
120 include/assert.inc [committed gno 1 on master]
121 -------- flush_i = 2 of 2 --------
122 FLUSH LOGS;
123 INSERT INTO t1 VALUES (2);
124 INSERT INTO t1 VALUES (3);
125 FLUSH LOGS;
126 [on slave]
127 include/sync_slave_sql_with_master.inc
128 include/assert.inc [no gtids lost yet on slave]
129 include/assert.inc [committed gno 3 on slave]
130 [on master]
131 include/assert.inc [no gtids lost yet on master]
132 include/assert.inc [committed gno 3 on master]
133 ======== restart_i = 2 of 2 ========
134 include/stop_slave.inc
135 include/rpl_restart_server.inc [server_number=1 gtids=on]
136 include/rpl_restart_server.inc [server_number=1 gtids=on]
137 include/start_slave.inc
138 -------- flush_i = 1 of 2 --------
139 FLUSH LOGS;
140 INSERT INTO t1 VALUES (4);
141 FLUSH LOGS;
142 [on slave]
143 include/sync_slave_sql_with_master.inc
144 include/assert.inc [no gtids lost yet on slave]
145 include/assert.inc [committed gno 4 on slave]
146 [on master]
147 include/assert.inc [no gtids lost yet on master]
148 include/assert.inc [committed gno 4 on master]
149 -------- flush_i = 2 of 2 --------
150 FLUSH LOGS;
151 INSERT INTO t1 VALUES (5);
152 INSERT INTO t1 VALUES (6);
153 FLUSH LOGS;
154 [on slave]
155 include/sync_slave_sql_with_master.inc
156 include/assert.inc [no gtids lost yet on slave]
157 include/assert.inc [committed gno 6 on slave]
158 [on master]
159 include/assert.inc [no gtids lost yet on master]
160 include/assert.inc [committed gno 6 on master]
161 FLUSH LOGS;
162 include/sync_slave_sql_with_master.inc
163 ######## corruption_mode = 2 ########
164 Phase two: Purging logs
165 ======== restart_i = 1 of 2 ========
166 include/purge_first_log.inc
167 include/assert.inc [lost gtids from 1 to 0 on master]
168 include/purge_first_log.inc
169 include/assert.inc [lost gtids from 1 to 0 on master]
170 -------- flush_i = 1 of 2 --------
171 include/purge_first_log.inc
172 include/assert.inc [lost gtids from 1 to 0 on master]
173 include/purge_first_log.inc
174 include/assert.inc [lost gtids from 1 to 1 on master]
175 -------- flush_i = 2 of 2 --------
176 include/purge_first_log.inc
177 include/assert.inc [lost gtids from 1 to 1 on master]
178 include/purge_first_log.inc
179 include/assert.inc [lost gtids from 1 to 3 on master]
180 ======== restart_i = 2 of 2 ========
181 include/purge_first_log.inc
182 include/assert.inc [lost gtids from 1 to 3 on master]
183 include/purge_first_log.inc
184 include/assert.inc [lost gtids from 1 to 3 on master]
185 -------- flush_i = 1 of 2 --------
186 include/purge_first_log.inc
187 include/assert.inc [lost gtids from 1 to 3 on master]
188 include/purge_first_log.inc
189 include/assert.inc [lost gtids from 1 to 4 on master]
190 -------- flush_i = 2 of 2 --------
191 include/purge_first_log.inc
192 include/assert.inc [lost gtids from 1 to 4 on master]
193 include/purge_first_log.inc
194 include/assert.inc [lost gtids from 1 to 6 on master]
195 ######## Clean up ########
196 DROP TABLE t1;
197 include/rpl_end.inc