Master has purged binary logs containing GTIDs that the slave requires

Master has purged binary logs containing GTIDs that the slave requires

Problem : 

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.'

Solution :

stop slave;
Query OK, 0 rows affected (0.00 sec)

CHANGE MASTER TO MASTER_AUTO_POSITION = 0;
Query OK, 0 rows affected (0.01 sec)

start slave;
Query OK, 0 rows affected (0.00 sec)

Comments

Popular

SLEEP thread causing "Waiting for table metadata lock"

How to properly shutdown MySQL before any maintenance activity

How to Prepare for MySQL Certification Exam

Quickly configure replication using DBdeployer [SandBox]

MySQL 8.0 : Error Logging

errno: 24 - Too many open files

ERROR 1040 (HY000): Too many connections

Install MySQL on CentOS using DBdeployer

How to create CentOS VM using Vagrant