Could not find first log file name in binary log index file
We've had a replication setup running for about 6 months on 4.0.20 under SuSE.
A developer made a mistake the other day, and was writing to the slave and the master. Replication stopped.
I've been trying to get it set back up using the InnoDB hot backup, but there have been issues. I put the backup in place on the slave (and add skip-slave-start to the mysqld section of the my.cnf), start the slave, and get the binary log and position from the .err file:
InnoDB: Doing recovery: scanned up to log sequence number 5 1100523020
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: position 0 12061339, file name colossus-bin.013
InnoDB: Last MySQL binlog file position 0 694885, file name ./colossus-bin.001
041222 13:27:55 InnoDB: Flushing modified pages from the buffer pool...
041222 13:27:55 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306
I then execute a "change master" like,
CHANGE MASTER TO
MASTER_LOG_FILE='./colossus-bin.001',
MASTER_LOG_POS=694885;
And this shows up in the .err file:
041222 13:28:50 Slave SQL thread initialized, starting replication in log './colossus-bin.001' at position 694885, relay log './titan-relay-bin.001' position: 4
041222 13:28:50 Slave I/O thread: connected to master 'repl@xx.xx.xx.xxx:3306', replication started in log './colossus-bin.001' at position 694885
041222 13:28:50 Error reading packet from server: Could not find first log file name in binary log index file (server_errno=1236)
041222 13:28:50 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
The server-id's are set, and the permissions haven't changed.
The contents of the master.info on the slave are (the ip address is correct, but I've x'd it out),
colossus-bin.001
4636352
xx.xx.xx.xxx
repl
xxxx
3306
60
Searching the web has not produced any info. The master's .err file does not have any info.
The colossus-bin.index file has one line:
./colossus-bin.001
Not sure what this error is - I can't find any documentation.
Anyone have any ideas?
David
Subject
Views
Written By
Posted
Could not find first log file name in binary log index file
56424
December 22, 2004 05:21PM
26460
January 14, 2009 08:41AM
23696
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.