Debian Codegraph @

mysql-test/suite/rpl/r/rpl_terminology_use_previous.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 #### Specify scenarios ####
7
8 #### Initialize Server State ####
9 include/disable_binlog.inc
10 SET @save_replica_parallel_workers = @@global.replica_parallel_workers;
11 SET @@global.replica_parallel_workers = 4;
12 include/start_slave_sql.inc
13 SET @save_replica_net_timeout = @@global.replica_net_timeout;
14 SET @@global.replica_net_timeout = 300;
15 CREATE TABLE statement_result (name VARCHAR(256), KEY(name));
16 include/disable_binlog.inc
17 CREATE TABLE statement_result (name VARCHAR(256), KEY(name));
18 # Adding debug point 'syncpoint_begin_register_replica' to @@GLOBAL.debug
19 SET @@session.debug_sync = "now WAIT_FOR reached_begin_register_replica";
20 START REPLICA IO_THREAD;
21
22 #### Test terminology_use_previous=0 ####
23
24 SET @@session.terminology_use_previous = 0;
25 Warnings:
26 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
27 SELECT @@session.terminology_use_previous;
28 @@session.terminology_use_previous
29 NONE
30 Warnings:
31 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
32 SET @@session.terminology_use_previous = 0;
33 Warnings:
34 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
35 SELECT @@session.terminology_use_previous;
36 @@session.terminology_use_previous
37 NONE
38 Warnings:
39 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
40
41 ---- mutex ----
42 * performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME)
43 include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
44 include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
45 * performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME)
46 include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
47 include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
48 * performance_schema.events_waits_summary_by_instance(EVENT_NAME)
49 include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
50 include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
51 * performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME)
52 include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
53 include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
54 * performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME)
55 include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
56 include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
57 * performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME)
58 include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
59 include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
60 * performance_schema.mutex_instances(NAME)
61 include/assert.inc [There should be 12 unique 'new' mutex names in performance_schema.mutex_instances(NAME) on server 2]
62 include/assert.inc [There should be 0 unique 'old' mutex names in performance_schema.mutex_instances(NAME) on server 2]
63
64 ---- rwlock ----
65 * performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME)
66 include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
67 include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
68 * performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME)
69 include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
70 include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
71 * performance_schema.events_waits_summary_by_instance(EVENT_NAME)
72 include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
73 include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
74 * performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME)
75 include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
76 include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
77 * performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME)
78 include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
79 include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
80 * performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME)
81 include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
82 include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
83 * performance_schema.rwlock_instances(NAME)
84 include/assert.inc [There should be 1 unique 'new' rwlock names in performance_schema.rwlock_instances(NAME) on server 2]
85 include/assert.inc [There should be 0 unique 'old' rwlock names in performance_schema.rwlock_instances(NAME) on server 2]
86
87 ---- cond ----
88 * performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME)
89 include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
90 include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
91 * performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME)
92 include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
93 include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
94 * performance_schema.events_waits_summary_by_instance(EVENT_NAME)
95 include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
96 include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
97 * performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME)
98 include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
99 include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
100 * performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME)
101 include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
102 include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
103 * performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME)
104 include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
105 include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
106 * performance_schema.cond_instances(NAME)
107 include/assert.inc [There should be 7 unique 'new' cond names in performance_schema.cond_instances(NAME) on server 2]
108 include/assert.inc [There should be 0 unique 'old' cond names in performance_schema.cond_instances(NAME) on server 2]
109
110 ---- memory ----
111 * performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME)
112 include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) on server 2]
113 include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) on server 2]
114 * performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME)
115 include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) on server 2]
116 include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) on server 2]
117 * performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME)
118 include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
119 include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
120 * performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME)
121 include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) on server 2]
122 include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) on server 2]
123 * performance_schema.memory_summary_global_by_event_name(EVENT_NAME)
124 include/assert.inc [There should be 5 unique 'new' memory names in performance_schema.memory_summary_global_by_event_name(EVENT_NAME) on server 2]
125 include/assert.inc [There should be 0 unique 'old' memory names in performance_schema.memory_summary_global_by_event_name(EVENT_NAME) on server 2]
126
127 ---- thread ----
128 * performance_schema.threads(NAME)
129 include/assert.inc [There should be 3 unique 'new' thread names in performance_schema.threads(NAME) on server 2]
130 include/assert.inc [There should be 0 unique 'old' thread names in performance_schema.threads(NAME) on server 2]
131
132 ---- stage ----
133 * performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME)
134 include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) on server 2]
135 include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) on server 2]
136 * performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME)
137 include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) on server 2]
138 include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) on server 2]
139 * performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME)
140 include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
141 include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
142 * performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME)
143 include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) on server 2]
144 include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) on server 2]
145 * performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME)
146 include/assert.inc [There should be 25 unique 'new' stage names in performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) on server 2]
147 include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) on server 2]
148 * performance_schema.threads(PROCESSLIST_STATE)
149 include/assert.inc [There should be 2 unique 'new' stage names in performance_schema.threads(PROCESSLIST_STATE) on server 2]
150 include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.threads(PROCESSLIST_STATE) on server 2]
151 * performance_schema.processlist(STATE)
152 include/assert.inc [There should be 2 unique 'new' stage names in performance_schema.processlist(STATE) on server 2]
153 include/assert.inc [There should be 0 unique 'old' stage names in performance_schema.processlist(STATE) on server 2]
154 * INFORMATION_SCHEMA.PROCESSLIST(STATE)
155 include/assert.inc [There should be 2 unique 'new' stage names in INFORMATION_SCHEMA.PROCESSLIST(STATE) on server 2]
156 include/assert.inc [There should be 0 unique 'old' stage names in INFORMATION_SCHEMA.PROCESSLIST(STATE) on server 2]
157 * SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7)
158 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result]
159 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result]
160 include/assert.inc [There should be 2 unique 'new' stage names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) on server 2]
161 include/assert.inc [There should be 0 unique 'old' stage names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) on server 2]
162 * SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7)
163 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result]
164 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result]
165 include/assert.inc [There should be 2 unique 'new' stage names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) on server 2]
166 include/assert.inc [There should be 0 unique 'old' stage names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) on server 2]
167
168 ---- command ----
169 * performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME)
170 include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) on server 1]
171 include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) on server 1]
172 * performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME)
173 include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) on server 1]
174 include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) on server 1]
175 * performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME)
176 include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) on server 1]
177 include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) on server 1]
178 * performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME)
179 include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) on server 1]
180 include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) on server 1]
181 * performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME)
182 include/assert.inc [There should be 1 unique 'new' command names in performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) on server 1]
183 include/assert.inc [There should be 0 unique 'old' command names in performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) on server 1]
184 * performance_schema.threads(PROCESSLIST_COMMAND)
185 include/assert.inc [There should be 1 unique 'new' command names in performance_schema.threads(PROCESSLIST_COMMAND) on server 1]
186 include/assert.inc [There should be 0 unique 'old' command names in performance_schema.threads(PROCESSLIST_COMMAND) on server 1]
187 * performance_schema.processlist(COMMAND)
188 include/assert.inc [There should be 1 unique 'new' command names in performance_schema.processlist(COMMAND) on server 1]
189 include/assert.inc [There should be 0 unique 'old' command names in performance_schema.processlist(COMMAND) on server 1]
190 * INFORMATION_SCHEMA.PROCESSLIST(COMMAND)
191 include/assert.inc [There should be 1 unique 'new' command names in INFORMATION_SCHEMA.PROCESSLIST(COMMAND) on server 1]
192 include/assert.inc [There should be 0 unique 'old' command names in INFORMATION_SCHEMA.PROCESSLIST(COMMAND) on server 1]
193 * SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5)
194 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result]
195 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result]
196 include/assert.inc [There should be 1 unique 'new' command names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) on server 1]
197 include/assert.inc [There should be 0 unique 'old' command names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) on server 1]
198 * SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5)
199 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result]
200 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result]
201 include/assert.inc [There should be 1 unique 'new' command names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) on server 1]
202 include/assert.inc [There should be 0 unique 'old' command names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) on server 1]
203 * SHOW REPLICA STATUS(column 1)
204 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW REPLICA STATUS -> statement_result]
205 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW REPLICA STATUS -> statement_result]
206 include/assert.inc [There should be 1 unique 'new' command names in SHOW REPLICA STATUS(column 1) on server 1]
207 include/assert.inc [There should be 0 unique 'old' command names in SHOW REPLICA STATUS(column 1) on server 1]
208 * SHOW REPLICA STATUS(column 45)
209 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW REPLICA STATUS -> statement_result]
210 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW REPLICA STATUS -> statement_result]
211 include/assert.inc [There should be 1 unique 'new' command names in SHOW REPLICA STATUS(column 45) on server 1]
212 include/assert.inc [There should be 0 unique 'old' command names in SHOW REPLICA STATUS(column 45) on server 1]
213 * SHOW SLAVE STATUS(column 1)
214 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW SLAVE STATUS -> statement_result]
215 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW SLAVE STATUS -> statement_result]
216 include/assert.inc [There should be 1 unique 'new' command names in SHOW SLAVE STATUS(column 1) on server 1]
217 include/assert.inc [There should be 0 unique 'old' command names in SHOW SLAVE STATUS(column 1) on server 1]
218 * SHOW SLAVE STATUS(column 45)
219 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW SLAVE STATUS -> statement_result]
220 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 0; SHOW SLAVE STATUS -> statement_result]
221 include/assert.inc [There should be 1 unique 'new' command names in SHOW SLAVE STATUS(column 45) on server 1]
222 include/assert.inc [There should be 0 unique 'old' command names in SHOW SLAVE STATUS(column 45) on server 1]
223
224 #### Test terminology_use_previous=1 ####
225
226 SET @@session.terminology_use_previous = 1;
227 Warnings:
228 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
229 SELECT @@session.terminology_use_previous;
230 @@session.terminology_use_previous
231 BEFORE_8_0_26
232 Warnings:
233 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
234 SET @@session.terminology_use_previous = 1;
235 Warnings:
236 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
237 SELECT @@session.terminology_use_previous;
238 @@session.terminology_use_previous
239 BEFORE_8_0_26
240 Warnings:
241 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
242
243 ---- mutex ----
244 * performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME)
245 include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
246 include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
247 * performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME)
248 include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
249 include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
250 * performance_schema.events_waits_summary_by_instance(EVENT_NAME)
251 include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
252 include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
253 * performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME)
254 include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
255 include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
256 * performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME)
257 include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
258 include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
259 * performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME)
260 include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
261 include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
262 * performance_schema.mutex_instances(NAME)
263 include/assert.inc [There should be 0 unique 'new' mutex names in performance_schema.mutex_instances(NAME) on server 2]
264 include/assert.inc [There should be 12 unique 'old' mutex names in performance_schema.mutex_instances(NAME) on server 2]
265
266 ---- rwlock ----
267 * performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME)
268 include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
269 include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
270 * performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME)
271 include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
272 include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
273 * performance_schema.events_waits_summary_by_instance(EVENT_NAME)
274 include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
275 include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
276 * performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME)
277 include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
278 include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
279 * performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME)
280 include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
281 include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
282 * performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME)
283 include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
284 include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
285 * performance_schema.rwlock_instances(NAME)
286 include/assert.inc [There should be 0 unique 'new' rwlock names in performance_schema.rwlock_instances(NAME) on server 2]
287 include/assert.inc [There should be 1 unique 'old' rwlock names in performance_schema.rwlock_instances(NAME) on server 2]
288
289 ---- cond ----
290 * performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME)
291 include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
292 include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_account_by_event_name(EVENT_NAME) on server 2]
293 * performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME)
294 include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
295 include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_host_by_event_name(EVENT_NAME) on server 2]
296 * performance_schema.events_waits_summary_by_instance(EVENT_NAME)
297 include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
298 include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_instance(EVENT_NAME) on server 2]
299 * performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME)
300 include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
301 include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
302 * performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME)
303 include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
304 include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_by_user_by_event_name(EVENT_NAME) on server 2]
305 * performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME)
306 include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
307 include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.events_waits_summary_global_by_event_name(EVENT_NAME) on server 2]
308 * performance_schema.cond_instances(NAME)
309 include/assert.inc [There should be 0 unique 'new' cond names in performance_schema.cond_instances(NAME) on server 2]
310 include/assert.inc [There should be 7 unique 'old' cond names in performance_schema.cond_instances(NAME) on server 2]
311
312 ---- memory ----
313 * performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME)
314 include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) on server 2]
315 include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_by_account_by_event_name(EVENT_NAME) on server 2]
316 * performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME)
317 include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) on server 2]
318 include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_by_host_by_event_name(EVENT_NAME) on server 2]
319 * performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME)
320 include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
321 include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
322 * performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME)
323 include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) on server 2]
324 include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_by_user_by_event_name(EVENT_NAME) on server 2]
325 * performance_schema.memory_summary_global_by_event_name(EVENT_NAME)
326 include/assert.inc [There should be 0 unique 'new' memory names in performance_schema.memory_summary_global_by_event_name(EVENT_NAME) on server 2]
327 include/assert.inc [There should be 5 unique 'old' memory names in performance_schema.memory_summary_global_by_event_name(EVENT_NAME) on server 2]
328
329 ---- thread ----
330 * performance_schema.threads(NAME)
331 include/assert.inc [There should be 0 unique 'new' thread names in performance_schema.threads(NAME) on server 2]
332 include/assert.inc [There should be 3 unique 'old' thread names in performance_schema.threads(NAME) on server 2]
333
334 ---- stage ----
335 * performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME)
336 include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) on server 2]
337 include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_by_account_by_event_name(EVENT_NAME) on server 2]
338 * performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME)
339 include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) on server 2]
340 include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_by_host_by_event_name(EVENT_NAME) on server 2]
341 * performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME)
342 include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
343 include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_by_thread_by_event_name(EVENT_NAME) on server 2]
344 * performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME)
345 include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) on server 2]
346 include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_by_user_by_event_name(EVENT_NAME) on server 2]
347 * performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME)
348 include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) on server 2]
349 include/assert.inc [There should be 25 unique 'old' stage names in performance_schema.events_stages_summary_global_by_event_name(EVENT_NAME) on server 2]
350 * performance_schema.threads(PROCESSLIST_STATE)
351 include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.threads(PROCESSLIST_STATE) on server 2]
352 include/assert.inc [There should be 2 unique 'old' stage names in performance_schema.threads(PROCESSLIST_STATE) on server 2]
353 * performance_schema.processlist(STATE)
354 include/assert.inc [There should be 0 unique 'new' stage names in performance_schema.processlist(STATE) on server 2]
355 include/assert.inc [There should be 2 unique 'old' stage names in performance_schema.processlist(STATE) on server 2]
356 * INFORMATION_SCHEMA.PROCESSLIST(STATE)
357 include/assert.inc [There should be 0 unique 'new' stage names in INFORMATION_SCHEMA.PROCESSLIST(STATE) on server 2]
358 include/assert.inc [There should be 2 unique 'old' stage names in INFORMATION_SCHEMA.PROCESSLIST(STATE) on server 2]
359 * SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7)
360 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result]
361 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result]
362 include/assert.inc [There should be 0 unique 'new' stage names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) on server 2]
363 include/assert.inc [There should be 2 unique 'old' stage names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 7) on server 2]
364 * SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7)
365 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result]
366 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result]
367 include/assert.inc [There should be 0 unique 'new' stage names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) on server 2]
368 include/assert.inc [There should be 2 unique 'old' stage names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 7) on server 2]
369
370 ---- command ----
371 * performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME)
372 include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) on server 1]
373 include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_by_account_by_event_name(EVENT_NAME) on server 1]
374 * performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME)
375 include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) on server 1]
376 include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_by_host_by_event_name(EVENT_NAME) on server 1]
377 * performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME)
378 include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) on server 1]
379 include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_by_thread_by_event_name(EVENT_NAME) on server 1]
380 * performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME)
381 include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) on server 1]
382 include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_by_user_by_event_name(EVENT_NAME) on server 1]
383 * performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME)
384 include/assert.inc [There should be 0 unique 'new' command names in performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) on server 1]
385 include/assert.inc [There should be 1 unique 'old' command names in performance_schema.events_statements_summary_global_by_event_name(EVENT_NAME) on server 1]
386 * performance_schema.threads(PROCESSLIST_COMMAND)
387 include/assert.inc [There should be 0 unique 'new' command names in performance_schema.threads(PROCESSLIST_COMMAND) on server 1]
388 include/assert.inc [There should be 1 unique 'old' command names in performance_schema.threads(PROCESSLIST_COMMAND) on server 1]
389 * performance_schema.processlist(COMMAND)
390 include/assert.inc [There should be 0 unique 'new' command names in performance_schema.processlist(COMMAND) on server 1]
391 include/assert.inc [There should be 1 unique 'old' command names in performance_schema.processlist(COMMAND) on server 1]
392 * INFORMATION_SCHEMA.PROCESSLIST(COMMAND)
393 include/assert.inc [There should be 0 unique 'new' command names in INFORMATION_SCHEMA.PROCESSLIST(COMMAND) on server 1]
394 include/assert.inc [There should be 1 unique 'old' command names in INFORMATION_SCHEMA.PROCESSLIST(COMMAND) on server 1]
395 * SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5)
396 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result]
397 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST -> statement_result]
398 include/assert.inc [There should be 0 unique 'new' command names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) on server 1]
399 include/assert.inc [There should be 1 unique 'old' command names in SET @@global.performance_schema_show_processlist = 1; SHOW PROCESSLIST(column 5) on server 1]
400 * SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5)
401 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result]
402 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST -> statement_result]
403 include/assert.inc [There should be 0 unique 'new' command names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) on server 1]
404 include/assert.inc [There should be 1 unique 'old' command names in SET @@global.performance_schema_show_processlist = 0; SHOW PROCESSLIST(column 5) on server 1]
405 * SHOW REPLICA STATUS(column 1)
406 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW REPLICA STATUS -> statement_result]
407 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW REPLICA STATUS -> statement_result]
408 include/assert.inc [There should be 0 unique 'new' command names in SHOW REPLICA STATUS(column 1) on server 1]
409 include/assert.inc [There should be 1 unique 'old' command names in SHOW REPLICA STATUS(column 1) on server 1]
410 * SHOW REPLICA STATUS(column 45)
411 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW REPLICA STATUS -> statement_result]
412 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW REPLICA STATUS -> statement_result]
413 include/assert.inc [There should be 0 unique 'new' command names in SHOW REPLICA STATUS(column 45) on server 1]
414 include/assert.inc [There should be 1 unique 'old' command names in SHOW REPLICA STATUS(column 45) on server 1]
415 * SHOW SLAVE STATUS(column 1)
416 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW SLAVE STATUS -> statement_result]
417 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW SLAVE STATUS -> statement_result]
418 include/assert.inc [There should be 0 unique 'new' command names in SHOW SLAVE STATUS(column 1) on server 1]
419 include/assert.inc [There should be 1 unique 'old' command names in SHOW SLAVE STATUS(column 1) on server 1]
420 * SHOW SLAVE STATUS(column 45)
421 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW SLAVE STATUS -> statement_result]
422 include/include/save_result_in_table.inc [SET @@session.terminology_use_previous = 1; SHOW SLAVE STATUS -> statement_result]
423 include/assert.inc [There should be 0 unique 'new' command names in SHOW SLAVE STATUS(column 45) on server 1]
424 include/assert.inc [There should be 1 unique 'old' command names in SHOW SLAVE STATUS(column 45) on server 1]
425 # Check SET terminology_use_previous = DEFAULT
426 SET @@session.terminology_use_previous = DEFAULT;
427 Warnings:
428 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
429 SELECT @@session.terminology_use_previous;
430 @@session.terminology_use_previous
431 NONE
432 Warnings:
433 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
434
435 #### Clean up ####
436 SET @@session.debug_sync = "now SIGNAL continue_begin_register_replica";
437 include/wait_for_slave_io_to_start.inc
438 SET @@global.replica_parallel_workers = @save_replica_parallel_workers;
439 SET @@global.replica_net_timeout = @save_replica_net_timeout;
440 include/restore_binlog.inc
441 # Removing debug point 'syncpoint_begin_register_replica' from @@GLOBAL.debug
442 DROP TABLE statement_result;
443 include/sync_slave_sql_with_master.inc
444 include/rpl_end.inc