MySQL Forums
Forum List  »  Replication

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
Re: Could not find first log file name in binary log index file
23924
January 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.