Shulou(Shulou.com)06/01 Report--

Enable auto_position=1 to keep reporting errors 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.', Error_code: 1236

Understanding of some variables in gtid

Retrieved_Gtid_Set: received the gtid collection

Executed_Gtid_Set: slave has already executed the gtid collection, which is initialized with the variable gtid_executed of the slave library

Gtid_executed: a collection of executed gtid

Gtid_purged: the gtid collection has been cleared by purge

How to calculate the starting GTID value / collection when executing start slave

In the gtid collection that has been executed from the slave library

Gtid_executed= {0dd527e9-af3e-11e8-9ed6-00505683b926:1-62memo 0dd527e9muraf3emur11e8-9ed6-00505683b927:1-3magi 87cf7b977luc c393-11e845bMich005056a9581414purl 1Mague bb014309mure1a6-11e8-b284-00505683b926:1-12Formc488995blice256-11e8-abb7-00505683b926:1-9}

Gtid collection executed on the main library

Master_gtid_executed = {c488995b-e256-11e8-abb7-00505683b926:1-10}

The first gtid value (or possibly a collection) sent by the master library to the slave library

Send_first_gtids= {master_gtid_executed-gtid_executed}

Send_first_gtids = {c488995b-e256-11e8-abb7-00505683b926:10}

At this point, the first gtid value / collection that master needs to send to slave is calculated.

If this value has been cleaned up by master purge (that is, it can't be found in master's binlog file)

Slave will report an error of 1236.

The specific error reports are as follows:

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.', Error_code: 1236

There are two solutions to this error.

1. Redo slave

two。 Find the historical binlog file, receive the required gtid collection log from the binlog file cp and execute it in slave (here you need to use mysqlbinlog-- include-gtids), and reinitialize the gtid_executed value of the slave library.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.