Hi, I used replication as a real-time backup for months and I'am now trying to configure a two-way replication between two MySQL servers (srv1 and srv2). So, srv1 replicates from srv2 and srv2 replicates from srv1 (They are both master and slave). The One-way replication is working fine from srv1 to srv2. But often every minute, srv1 failed to replicate from srv2.
Here is the message from .err file: 020614 5:37:36 Error reading packet from server: (server_errno=1159) 020614 5:38:36 Slave: Failed reading log event, reconnecting to retry, log 'srv02-bin.003' position 386 020614 5:38:36 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'srv02-bin.003' at position 386 (You can see that the replication is working quite fine because the slave restarts by himself after "Connect_retry" secondes) According to the include/mysqld_error.h file, the error number 1159 is ER_NET_READ_INTERRUPTED. So it seems to be a network error ? The configuration is exactly the same on the two boxes (MySQL 3.23.51 compiled on mipsel linux). And the configuration options are exactly the same. Does anyone has any suggestion ? S¨¦bastien sql, query --------------------------------------------------------------------- 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
