Pank: October 2016 Archives

Bliss HD

user-pic
Vote 0 Votes

Classic HD Windows XP Wallpaper
Download

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 recent entries written by Pank in October 2016.

Pank: September 2016 is the previous archive.

Pank: December 2016 is the next archive.

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

Monthly Archives