Skip navigation links

MySQL Forums :: Replication :: Could not find first log file name in binary log index file


Advanced Search

Re: Could not find first log file name in binary log index file
Posted by: Paul Eident ()
Date: January 14, 2009 09:33AM

I have either figured out the replication or have messed it up. The Slave IO and SQL are now both yes and Slave_IO_State: Waiting for master to send event .

What I did was I looked on the master to see what binary logs were in /var/run/mysqld. All I saw was mysqld-bin.000001 .

I also noticed in the error this information in the krex data server mysqld log:

090114 8:55:44 [Note] Slave SQL thread initialized, starting replication in log 'mysqld-bin.000009' at position 108959, relay log '/var/run/mysqld/mysqld-relay-bin.000001' position: 98

So I went back to the slave server and did the following:

mysql> STOP SLAVE;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.00 sec)

mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)

mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysqld-bin.000001';
Query OK, 0 rows affected (0.00 sec)

mysql> CHANGE MASTER TO MASTER_LOG_POS=98;
Query OK, 0 rows affected (0.00 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

The Slave IO and SQL are now both yes. Slave_IO_State: Waiting for master to send event .

I spot checked the data on both the slave and master. They look synced.

Options: ReplyQuote


Subject Views Written By Posted
Could not find first log file name in binary log index file 35308 David Griffiths 12/22/2004 05:21PM
Re: Could not find first log file name in binary log index file 19410 Paul Eident 01/14/2009 08:41AM
Re: Could not find first log file name in binary log index file 17559 Paul Eident 01/14/2009 09:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.