| 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 |
include/suppress_messages.inc |
| 8 |
# Connection 1 suppresses message <Source command COM_REGISTER_REPLICA failed: failed>. |
| 9 |
# Connection 1 suppresses message <Source command COM_BINLOG_DUMP failed: failed>. |
| 10 |
# Connection 1 suppresses message <Failed on request_dump.. for channel>. |
| 11 |
# Connection 2 suppresses message <Source command COM_REGISTER_REPLICA failed: failed>. |
| 12 |
# Connection 2 suppresses message <Source command COM_BINLOG_DUMP failed: failed>. |
| 13 |
# Connection 2 suppresses message <Failed on request_dump.. for channel>. |
| 14 |
|
| 15 |
#### Testing terminology_use_previous = 0 #### |
| 16 |
SET @@session.terminology_use_previous = 0; |
| 17 |
Warnings: |
| 18 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 19 |
|
| 20 |
---- replica_waiting_to_reconnect after failed_registration ---- |
| 21 |
# Adding debug point 'simulate_reconnect_after_failed_registration' to @@GLOBAL.debug |
| 22 |
# Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug |
| 23 |
START REPLICA IO_THREAD; |
| 24 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 25 |
STATE |
| 26 |
Waiting to reconnect after a failed registration on source |
| 27 |
Warnings: |
| 28 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 29 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 30 |
STATE |
| 31 |
Waiting to reconnect after a failed registration on source |
| 32 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 33 |
PROCESSLIST_STATE |
| 34 |
Waiting to reconnect after a failed registration on source |
| 35 |
Slave_IO_State = 'Waiting to reconnect after a failed registration on source' |
| 36 |
# Removing debug point 'simulate_reconnect_after_failed_registration' from @@GLOBAL.debug |
| 37 |
# Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug |
| 38 |
KILL THREAD_ID_OF_RECEIVER; |
| 39 |
include/wait_for_slave_io_to_stop.inc |
| 40 |
|
| 41 |
---- replica_reconnecting after failed_registration ---- |
| 42 |
# Adding debug point 'simulate_reconnect_after_failed_registration' to @@GLOBAL.debug |
| 43 |
# Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug |
| 44 |
START REPLICA IO_THREAD; |
| 45 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 46 |
STATE |
| 47 |
Reconnecting after a failed registration on source |
| 48 |
Warnings: |
| 49 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 50 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 51 |
STATE |
| 52 |
Reconnecting after a failed registration on source |
| 53 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 54 |
PROCESSLIST_STATE |
| 55 |
Reconnecting after a failed registration on source |
| 56 |
Slave_IO_State = 'Reconnecting after a failed registration on source' |
| 57 |
# Removing debug point 'simulate_reconnect_after_failed_registration' from @@GLOBAL.debug |
| 58 |
# Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug |
| 59 |
KILL THREAD_ID_OF_RECEIVER; |
| 60 |
include/wait_for_slave_io_to_stop.inc |
| 61 |
|
| 62 |
---- replica_waiting_to_reconnect after failed_binlog_dump ---- |
| 63 |
# Adding debug point 'simulate_reconnect_after_failed_binlog_dump' to @@GLOBAL.debug |
| 64 |
# Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug |
| 65 |
START REPLICA IO_THREAD; |
| 66 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 67 |
STATE |
| 68 |
Waiting to reconnect after a failed binlog dump request |
| 69 |
Warnings: |
| 70 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 71 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 72 |
STATE |
| 73 |
Waiting to reconnect after a failed binlog dump request |
| 74 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 75 |
PROCESSLIST_STATE |
| 76 |
Waiting to reconnect after a failed binlog dump request |
| 77 |
Slave_IO_State = 'Waiting to reconnect after a failed binlog dump request' |
| 78 |
# Removing debug point 'simulate_reconnect_after_failed_binlog_dump' from @@GLOBAL.debug |
| 79 |
# Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug |
| 80 |
KILL THREAD_ID_OF_RECEIVER; |
| 81 |
include/wait_for_slave_io_to_stop.inc |
| 82 |
|
| 83 |
---- replica_reconnecting after failed_binlog_dump ---- |
| 84 |
# Adding debug point 'simulate_reconnect_after_failed_binlog_dump' to @@GLOBAL.debug |
| 85 |
# Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug |
| 86 |
START REPLICA IO_THREAD; |
| 87 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 88 |
STATE |
| 89 |
Reconnecting after a failed binlog dump request |
| 90 |
Warnings: |
| 91 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 92 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 93 |
STATE |
| 94 |
Reconnecting after a failed binlog dump request |
| 95 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 96 |
PROCESSLIST_STATE |
| 97 |
Reconnecting after a failed binlog dump request |
| 98 |
Slave_IO_State = 'Reconnecting after a failed binlog dump request' |
| 99 |
# Removing debug point 'simulate_reconnect_after_failed_binlog_dump' from @@GLOBAL.debug |
| 100 |
# Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug |
| 101 |
KILL THREAD_ID_OF_RECEIVER; |
| 102 |
include/wait_for_slave_io_to_stop.inc |
| 103 |
|
| 104 |
---- replica_waiting_to_reconnect after failed_event_read ---- |
| 105 |
# Adding debug point 'simulate_reconnect_after_failed_event_read' to @@GLOBAL.debug |
| 106 |
# Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug |
| 107 |
START REPLICA IO_THREAD; |
| 108 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 109 |
STATE |
| 110 |
Waiting to reconnect after a failed source event read |
| 111 |
Warnings: |
| 112 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 113 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 114 |
STATE |
| 115 |
Waiting to reconnect after a failed source event read |
| 116 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 117 |
PROCESSLIST_STATE |
| 118 |
Waiting to reconnect after a failed source event read |
| 119 |
Slave_IO_State = 'Waiting to reconnect after a failed source event read' |
| 120 |
# Removing debug point 'simulate_reconnect_after_failed_event_read' from @@GLOBAL.debug |
| 121 |
# Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug |
| 122 |
KILL THREAD_ID_OF_RECEIVER; |
| 123 |
include/wait_for_slave_io_to_stop.inc |
| 124 |
|
| 125 |
---- replica_reconnecting after failed_event_read ---- |
| 126 |
# Adding debug point 'simulate_reconnect_after_failed_event_read' to @@GLOBAL.debug |
| 127 |
# Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug |
| 128 |
START REPLICA IO_THREAD; |
| 129 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 130 |
STATE |
| 131 |
Reconnecting after a failed source event read |
| 132 |
Warnings: |
| 133 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 134 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 135 |
STATE |
| 136 |
Reconnecting after a failed source event read |
| 137 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 138 |
PROCESSLIST_STATE |
| 139 |
Reconnecting after a failed source event read |
| 140 |
Slave_IO_State = 'Reconnecting after a failed source event read' |
| 141 |
# Removing debug point 'simulate_reconnect_after_failed_event_read' from @@GLOBAL.debug |
| 142 |
# Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug |
| 143 |
KILL THREAD_ID_OF_RECEIVER; |
| 144 |
include/wait_for_slave_io_to_stop.inc |
| 145 |
|
| 146 |
#### Testing terminology_use_previous = 1 #### |
| 147 |
SET @@session.terminology_use_previous = 1; |
| 148 |
Warnings: |
| 149 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 150 |
|
| 151 |
---- replica_waiting_to_reconnect after failed_registration ---- |
| 152 |
# Adding debug point 'simulate_reconnect_after_failed_registration' to @@GLOBAL.debug |
| 153 |
# Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug |
| 154 |
START REPLICA IO_THREAD; |
| 155 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 156 |
STATE |
| 157 |
Waiting to reconnect after a failed registration on master |
| 158 |
Warnings: |
| 159 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 160 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 161 |
STATE |
| 162 |
Waiting to reconnect after a failed registration on master |
| 163 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 164 |
PROCESSLIST_STATE |
| 165 |
Waiting to reconnect after a failed registration on master |
| 166 |
Slave_IO_State = 'Waiting to reconnect after a failed registration on master' |
| 167 |
# Removing debug point 'simulate_reconnect_after_failed_registration' from @@GLOBAL.debug |
| 168 |
# Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug |
| 169 |
KILL THREAD_ID_OF_RECEIVER; |
| 170 |
include/wait_for_slave_io_to_stop.inc |
| 171 |
|
| 172 |
---- replica_reconnecting after failed_registration ---- |
| 173 |
# Adding debug point 'simulate_reconnect_after_failed_registration' to @@GLOBAL.debug |
| 174 |
# Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug |
| 175 |
START REPLICA IO_THREAD; |
| 176 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 177 |
STATE |
| 178 |
Reconnecting after a failed registration on master |
| 179 |
Warnings: |
| 180 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 181 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 182 |
STATE |
| 183 |
Reconnecting after a failed registration on master |
| 184 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 185 |
PROCESSLIST_STATE |
| 186 |
Reconnecting after a failed registration on master |
| 187 |
Slave_IO_State = 'Reconnecting after a failed registration on master' |
| 188 |
# Removing debug point 'simulate_reconnect_after_failed_registration' from @@GLOBAL.debug |
| 189 |
# Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug |
| 190 |
KILL THREAD_ID_OF_RECEIVER; |
| 191 |
include/wait_for_slave_io_to_stop.inc |
| 192 |
|
| 193 |
---- replica_waiting_to_reconnect after failed_binlog_dump ---- |
| 194 |
# Adding debug point 'simulate_reconnect_after_failed_binlog_dump' to @@GLOBAL.debug |
| 195 |
# Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug |
| 196 |
START REPLICA IO_THREAD; |
| 197 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 198 |
STATE |
| 199 |
Waiting to reconnect after a failed binlog dump request |
| 200 |
Warnings: |
| 201 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 202 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 203 |
STATE |
| 204 |
Waiting to reconnect after a failed binlog dump request |
| 205 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 206 |
PROCESSLIST_STATE |
| 207 |
Waiting to reconnect after a failed binlog dump request |
| 208 |
Slave_IO_State = 'Waiting to reconnect after a failed binlog dump request' |
| 209 |
# Removing debug point 'simulate_reconnect_after_failed_binlog_dump' from @@GLOBAL.debug |
| 210 |
# Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug |
| 211 |
KILL THREAD_ID_OF_RECEIVER; |
| 212 |
include/wait_for_slave_io_to_stop.inc |
| 213 |
|
| 214 |
---- replica_reconnecting after failed_binlog_dump ---- |
| 215 |
# Adding debug point 'simulate_reconnect_after_failed_binlog_dump' to @@GLOBAL.debug |
| 216 |
# Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug |
| 217 |
START REPLICA IO_THREAD; |
| 218 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 219 |
STATE |
| 220 |
Reconnecting after a failed binlog dump request |
| 221 |
Warnings: |
| 222 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 223 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 224 |
STATE |
| 225 |
Reconnecting after a failed binlog dump request |
| 226 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 227 |
PROCESSLIST_STATE |
| 228 |
Reconnecting after a failed binlog dump request |
| 229 |
Slave_IO_State = 'Reconnecting after a failed binlog dump request' |
| 230 |
# Removing debug point 'simulate_reconnect_after_failed_binlog_dump' from @@GLOBAL.debug |
| 231 |
# Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug |
| 232 |
KILL THREAD_ID_OF_RECEIVER; |
| 233 |
include/wait_for_slave_io_to_stop.inc |
| 234 |
|
| 235 |
---- replica_waiting_to_reconnect after failed_event_read ---- |
| 236 |
# Adding debug point 'simulate_reconnect_after_failed_event_read' to @@GLOBAL.debug |
| 237 |
# Adding debug point 'hang_in_stage_replica_waiting_to_reconnect' to @@GLOBAL.debug |
| 238 |
START REPLICA IO_THREAD; |
| 239 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 240 |
STATE |
| 241 |
Waiting to reconnect after a failed master event read |
| 242 |
Warnings: |
| 243 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 244 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 245 |
STATE |
| 246 |
Waiting to reconnect after a failed master event read |
| 247 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 248 |
PROCESSLIST_STATE |
| 249 |
Waiting to reconnect after a failed master event read |
| 250 |
Slave_IO_State = 'Waiting to reconnect after a failed master event read' |
| 251 |
# Removing debug point 'simulate_reconnect_after_failed_event_read' from @@GLOBAL.debug |
| 252 |
# Removing debug point 'hang_in_stage_replica_waiting_to_reconnect' from @@GLOBAL.debug |
| 253 |
KILL THREAD_ID_OF_RECEIVER; |
| 254 |
include/wait_for_slave_io_to_stop.inc |
| 255 |
|
| 256 |
---- replica_reconnecting after failed_event_read ---- |
| 257 |
# Adding debug point 'simulate_reconnect_after_failed_event_read' to @@GLOBAL.debug |
| 258 |
# Adding debug point 'hang_in_stage_replica_reconnecting' to @@GLOBAL.debug |
| 259 |
START REPLICA IO_THREAD; |
| 260 |
SELECT STATE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%connect%after a failed%'; |
| 261 |
STATE |
| 262 |
Reconnecting after a failed master event read |
| 263 |
Warnings: |
| 264 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 265 |
SELECT STATE FROM performance_schema.processlist WHERE STATE LIKE '%connect%after a failed%'; |
| 266 |
STATE |
| 267 |
Reconnecting after a failed master event read |
| 268 |
SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE PROCESSLIST_STATE LIKE '%connect%after a failed%'; |
| 269 |
PROCESSLIST_STATE |
| 270 |
Reconnecting after a failed master event read |
| 271 |
Slave_IO_State = 'Reconnecting after a failed master event read' |
| 272 |
# Removing debug point 'simulate_reconnect_after_failed_event_read' from @@GLOBAL.debug |
| 273 |
# Removing debug point 'hang_in_stage_replica_reconnecting' from @@GLOBAL.debug |
| 274 |
KILL THREAD_ID_OF_RECEIVER; |
| 275 |
include/wait_for_slave_io_to_stop.inc |
| 276 |
|
| 277 |
#### Clean up #### |
| 278 |
SET @@session.terminology_use_previous = NONE; |
| 279 |
Warnings: |
| 280 |
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release. |
| 281 |
include/start_slave.inc |
| 282 |
include/rpl_end.inc |