SQL: October 2016 Archives

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

mysql> show global variables like 'gtid_purged'; # show master's gtid_purged

mysql> stop slave;
mysql> set global gtid_purged = '3caafe57-7a46-11e6-a5c0-00505682159e:1-50'; # set slave's gtid_purged as master
mysql> reset master;
mysql> start slave;

About this Archive

This page is an archive of entries in the SQL category from October 2016.

SQL: April 2016 is the previous archive.

SQL: April 2018 is the next archive.

Find recent content on the main index or look in the archives to find all content.

Monthly Archives