Scenario Master – Master replication

MasterA is a client facing server
MasterB is a warm standby server (read only)

MasterB restarted abruptly and when instances were braught back up MasterA (it’s slave) was showing the following error:

MasterA has the following error in show slave status:
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: stop slave;

Master: flush logs
Master: show master status; — take note of the master log file and master log position

Slave: CHANGE MASTER TO MASTER_LOG_FILE=’log-bin.00000X′, MASTER_LOG_POS=106;
Slave: start slave;

VN:F [1.9.22_1171]
Rating: 8.5/10 (25 votes cast)
VN:F [1.9.22_1171]
Rating: +16 (from 26 votes)

Could not find first log file name in binary log index file, 8.5 out of 10 based on 25 ratings

  1. [...] lí mais nenhum artigo desse blog de referência, mas recomendo a visita através desse link. Parece uma boa fonte de informação, mas lembre-se que o site oficial do MySQL é vasto de [...]

  2. Nitin Bansod says:

    Thanks.. your solution helped me……………

  3. M. Faraz says:

    THANX A MIL…LITERALLY…!
    U just saved my 4 mill customers…!

  4. Jyoti Prasad says:

    simple stop slave and than restart i.e
    mysql>stop slave;start slave;show slave status;

  5. Ross Carver says:

    This is also an error when using the mysqlbinlog utility whereby you don’t provide the binary log filename to reference when using the remote server option in mySQL 5.6

  6. web traffic says:

    Below are 20 purposes of them to increase your traffic and
    sales. This opens the door for identity fraud, digital forgery, online fraud, more spam,
    data theft, any cybercrime, or even distributed denial-of-service attacks that
    could make a cell phone network disabled for a period of time like a computer network server.
    Viral marketing is often a sort of undercover advertising,
    through which videos, games, articles and the like are spread on the Internet through blogs or sites,
    obtaining the company’s name attached to them.

    Feel free to visit my webpage web traffic

  7. Tamara says:

    It’s awesome for me to have a website, which is good in support of my experience. thanks admin

*