Wednesday 13 February 2013

Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'

Below error in SHOW SLAVE STATUS \G;
 
Last_IO_Errno: 1236
Last_IO_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’
 











Solution:--
 
Slave Server: stop slave;
 
 
In Master Server: flush logs

 
In Master Server: show master status; — take note of the master log file and master log position

 









 
 
Slave Server : CHANGE MASTER TO MASTER_LOG_FILE=’viznet-db-bin.000002′, MASTER_LOG_POS=2478;


Slave Server: start slave;

 

No comments:

Post a Comment