Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.2.14
-
None
Description
`binlog_chanmge_master` test fails randomly.
to reproduce:
ctest -I 235,235 --repeat-until-fail 100 -VV
After failure:
- binlog router is not connected to the master according masters' `how slave hosts`
- show slave status from binlog router
MySQL [(none)]> show slave status\G
|
*************************** 1. row ***************************
|
Slave_IO_State: Binlog Dump
|
Master_Host: 192.168.121.247
|
Master_User: repl
|
Master_Port: 3306
|
Connect_Retry: 60
|
Master_Log_File: mar-bin.000005
|
Read_Master_Log_Pos: 203596
|
Relay_Log_File: mar-bin.000005
|
Relay_Log_Pos: 203596
|
Relay_Master_Log_File: mar-bin.000005
|
Slave_IO_Running: Yes
|
Slave_SQL_Running: Yes
|
Replicate_Do_DB:
|
Replicate_Ignore_DB:
|
Replicate_Do_Table:
|
Replicate_Ignore_Table:
|
Replicate_Wild_Do_Table:
|
Replicate_Wild_Ignore_Table:
|
Last_Errno: 0
|
Last_Error:
|
Skip_Counter: 0
|
Exec_Master_Log_Pos: 203596
|
Relay_Log_Space: 203596
|
Until_Condition: None
|
Until_Log_File:
|
Until_Log_Pos: 0
|
Master_SSL_Allowed: No
|
Master_SSL_CA_File:
|
Master_SSL_CA_Path:
|
Master_SSL_Cert:
|
Master_SSL_Cipher:
|
Master_SSL_Key:
|
Seconds_Behind_Master: 0
|
Master_SSL_Verify_Server_Cert: No
|
Last_IO_Errno: 0
|
Last_IO_Error:
|
Last_SQL_Errno: 0
|
Last_SQL_Error:
|
Replicate_Ignore_Server_Ids:
|
Master_Server_Id: 3
|
Master_UUID: 7df10d0e-b87d-11e8-bbd4-52540086ca0c
|
Master_Info_File: /var/lib/maxscale/Binlog_Service/master.ini
|
SQL_Delay: 0
|
SQL_Remaining_Delay: NULL
|
Slave_SQL_Running_State: Slave running
|
Master_Retry_Count: 1000
|
Master_Bind:
|
Last_IO_Error_TimeStamp:
|
Last_SQL_Error_Timestamp:
|
Master_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: No
|
Gtid_IO_Pos: 0-3-302
|
1 row in set (0.00 sec)
|
show master status from binlogrouter:
MySQL [(none)]> show master status\G
|
*************************** 1. row ***************************
|
File: mar-bin.000005
|
Position: 203596
|
Binlog_Do_DB:
|
Binlog_Ignore_DB:
|
Execute_Gtid_Set:
|
1 row in set (0.00 sec)
|