October 2016 Archives

Bliss HD

Vote 0 Votes

Classic HD Windows XP Wallpaper

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 from October 2016 listed from newest to oldest.

September 2016 is the previous archive.

December 2016 is the next archive.

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

Monthly Archives