Promote Slave with MySQL GTIDs failing with slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs

Question

Working on promoting a slave to master with MySQL GTIDs. Normally without GTID we would pause traffic flip replication streams then start traffic again.

With GTIDs do we still need to pause traffic?

Tried failing traffic to the slave then changing the replication to slave off the new master and got this error

Change master I ran once traffic was flipped

change master to master_host='10.1.1.1',
master_port=3306,
master_user='repluser',
master_password='pass123',
master_auto_position=1;

Error:

                Connect_Retry: 60
              Master_Log_File: mysql-bin.005469
          Read_Master_Log_Pos: 603648891
               Relay_Log_File: mysql-relay-bin.015360
                Relay_Log_Pos: 603649120
        Relay_Master_Log_File: mysql-bin.005469
             Slave_IO_Running: No
            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: 603648891
              Relay_Log_Space: 603650938
              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: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 1236
                Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.'
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 20480692
                  Master_UUID: bd2460c7-a276-11ed-b0cf-3cfdfe585078
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp: 230201 13:24:26
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set: 841bee21-1349-11e8-9b4a-848f69db3506:4104210343-4121201463,
87b97127-4922-11ea-8a61-3cfdfe585078:1-2191361294:2191361334-6685867732
            Executed_Gtid_Set: 841bee21-1349-11e8-9b4a-848f69db3506:4104210343-4121201463,
87b97127-4922-11ea-8a61-3cfdfe585078:1-6685867732,
b6159a7e-4918-11ea-a449-3cfdfe708df0:1-56

If I pause traffic this flip seems to work, but I was under the impressions you didn't need to do this with GTIDs and the new master could process transactions? Or am I doing something else wrong.

Promote Slave with MySQL GTIDs failing with slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs

0 Answers0