On Wednesday 24 January 2001 08:37, Josef Chladek wrote:
>hi,
>
>we have the same problem with replication: if we reset the master and the
>slaves and then start the slaves, replication works perfectly (we use two
>linux-server as the slaves and one solaris as the master, and we just
>upgraded from 27_beta - where replication worked).
>but if we stop a slave we get the following error
>
>010124 15:37:48 Slave thread exiting, replication stopped in log
>'wirtschaftsblatt100-bin.002' at position 50178
>010124 15:37:48 /usr/local/mysql_3.23.32/bin/mysqld: Shutdown Complete
>
>010124 15:37:48 mysqld ended
>
>010124 15:37:51 mysqld started
>/usr/local/mysql_3.23.32/bin/mysqld: ready for connections
>010124 15:37:51 Slave: connected to master 'replicate@our_master:3306',
>replication started in log 'wirtschaftsblatt100-bin.002
>' at position 50178
>010124 15:37:51 Error reading packet from server: Could not find first log
>(read_errno 0,server_errno=65535)
>010124 15:37:51 Slave: Failed reading log event, reconnecting to retry, log
>'wirtschaftsblatt100-bin.002
>' position 50178
>010124 15:37:51 Slave: reconnected to master
>'replicate@our_master:3306',replication resumed in log
>'wirtschaftsblatt100-bin.002
>' at position 50178
>010124 15:37:51 Error reading packet from server: Could not find first log
>(read_errno 0,server_errno=65535)
>010124 15:38:47 Slave thread exiting, replication stopped in log
>'wirtschaftsblatt100-bin.002
>' at position 50178
>
>and replication is not established until we reset master and slave again.
>for me it looks like the master info file gets 'corrupted' by a line-break:
>starting clean (after a reset):
>our_master-bin.001
>438979
>our_master
>replicate
>rep64D
>3306
>60
>
>and after restarting the mysql:
>our_master-bin.001
>
>(some number)
>our_master
>replicate
>rep64D
>3306
>60
>
>so there is a line break between the binlog and the position in that log.
>can you verify that??
I am currently investigating this. In the mean time, see if the following
workaround will solve the problem:
CHANGE MASTER TO
MASTER_HOST='your-master',MASTER_USER='user',MASTER_PASSWORD='master-pass',
MASTER_LOG_POS=position_from_master_info,MASTER_LOG_FILE='log_file_from_master_info';
SLAVE START;
--
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
