October 15, 2010 • Technology
1236: MySQL replication problem solved
<div id="mcePaste" Ever seen this before? <emGot fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'</em I had that after a MySQL server in my replication loop went down. When it came up, the next server in line gave this replication state <em'Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave'</em, which was quite logical since the end of the binlog had been corrupted due to external circumstances. </div