I have also encountered this problem when upgrading master and slave from
3.23.31 to 32.23.32. The upgrade of the master went fine, and both servers
remained in sync throughout the process. However, when I upgraded the
slave and restarted, it gave the same error that it could not find first
log. This log was listed in the index file, and was readable (permissions
had not been changed). I have done this on two master/slave setups, and
both of them broke when the slave was upgraded. I have had to reset both
master and slave after the upgrade to bring machines back into sync. The
error I received was:
010123 10:01:59 Slave: reconnected to master
'slave@hostname:3306',replication resumed in log
'radius1-bin.006
' at position 33488482
010123 10:01:59 Error reading packet from server: Could not find first
log (read_errno 0,server_errno=65535)
010123 10:02:59 Slave: Failed reading log event, reconnecting to retry,
log 'radius1-bin.006
' position 33488482
010123 10:02:59 Slave: reconnected to master
'slave@hostname:3306',replication resumed in log
'radius1-bin.006
' at position 33488482
010123 10:02:59 Error reading packet from server: Could not find first
log (read_errno 0,server_errno=65535)
010123 10:03:24 Slave thread exiting, replication stopped in log
'radius1-bin.006
' at position 33488482
Thanks for your help in this matter,
John
[EMAIL PROTECTED]
On Tue, 23 Jan 2001, Sasha Pachev wrote:
> >Just tried a 3.23.32 slave (on Linux, all rpms from www.mysql.com) against a
> 3.23.30 server:
>
> >010123 09:38:05 mysqld started
> /usr/sbin/mysqld: ready for connections
> >010123 9:38:05 Slave: connected to master '[EMAIL PROTECTED]:3306',
> replication started in log 'jfontain-bin.008
> ' at position 149358
> 010123 9:38:05 Error reading packet from server: Could not find first log
> (read_errno 0,server_errno=65535)
> 010123 9:38:05 Slave: Failed reading log event, reconnecting to retry, log
> 'jfontain-bin.008
> ' position 149358
> 010123 9:38:05 Slave: reconnected to master
> '[EMAIL PROTECTED]:3306',replication resumed in log 'jfontain-bin.008
> ' at position 149358
> 010123 9:38:05 Error reading packet from server: Could not find first log
> (read_errno 0,server_errno=65535)
> 010123 9:38:06 /usr/sbin/mysqld: Normal shutdown
>
> >010123 9:38:06 Slave thread exiting, replication stopped in log
> 'jfontain-bin.008
> ' at position 149358
> >010123 9:38:06 /usr/sbin/mysqld: Shutdown Complete
>
> Do you have jfontain-bin.008 log on the master? If yes, is it readable by the
> master, and is it listed in the log index ( do SHOW MASTER LOGS on the
> master). The error message indicates that the log is either not there, not
> readable, not listed in the index, otherwise it is a bug. If you have done
> reset master, but have not done reset slave, or have been careless with PURGE
> LOGS, this would explain the problem.
>
>
> >Do I need to upgrade master and slave?
>
> Only if you find a bug
>
> >Is it safe? (these are production machines) or should I wait a while?
>
> It depends on how you do it.
>
> --
> MySQL Development Team
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
> <___/
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
