Nov 122013

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 'repl@x.x.x.x: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..