[MXS-2053] binlog_change_master test fails after several iterations Created: 2018-09-17  Updated: 2019-06-18  Resolved: 2019-06-18

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter
Affects Version/s: 2.2.14
Fix Version/s: 2.3.8

Type: Bug Priority: Major
Reporter: Timofey Turenko Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Attachments: HTML File log100_1     File maxscale.log    

 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)



 Comments   
Comment by markus makela [ 2018-11-27 ]

This is fixed in 2.3.

Generated at Thu Feb 08 04:11:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.