something i feel could greatly help someone else in our situation this morning: a potential fix for mysql errno 1236.
131112 9:26:02 [Note] Slave I/O thread: connected to master 'firstname.lastname@example.org:3306', replication started in log 'je.000041' at position 90217258 131112 9:26:02 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236) 131112 9:26:02 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log 131112 9:26:02 [Note] Slave I/O thread exiting, read up to log 'je.000041', position 90217258
after struggling for close to 30 minutes to find a fix – purging binary logs, checking index files, using alternate binlogs – we had yet to come up with a fix. what could be going wrong?
it turned out to be really simple, and really dumb. we had typo’d the master_log_file attribute of our
change master – instead of je.000041, it should have read je1.000041!
changing the binlog name in the
change master statement fixed everything. what a pain..