… us this output: Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event ‘mysql… with a error on max_allowed_packet. The next step is to check the binary logs of both masters. MasterA: masterA> mysqlbinlog data/mysql-bin…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
February 22, 2011 By 21 Comments
… and copying the data. When we try and restart the new slave with those values we get the following error. Got fatal error 1236 from master when reading data from binary log: ‘error reading log entry’ Lots of posts have recommended increasing the max_allowed_packet and keeping them the same on the master/slave…
Comment: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… post: “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.’” That can happen often if you purge binary logs from the master and then…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
April 7, 2011 By 21 Comments
Getting this error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’ tried changing binlon file to position to full path, but no luck, any suggestions?
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
Getting this error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’ tried changing binlon file to position to full path, but no luck, any suggestions?
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… error: slave1 [localhost] {msandbox} ((none)) > show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘event read from binlog did not pass crc check; the first event ‘mysql-bin.000001′ at 2793, the last event read from…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…. This is the error we are going to get: Slave_IO_Running: No Slave_SQL_Running: Yes 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…
