Hi,
I more than once posted to the mysql mailing list about replication
problems (and saw others post similar problems) but it seems that list
isn't adequate for help with replication problems. Can anyone here help me
out? Or is there another mailing list I can go to for help?
I'm running linux, mysql 3.23.32 (latest stable)
I have 2 servers running a circular master-slave.
Server1 has:
[mysqld]
log-bin=/var/lib/mysql/binary_log
master-host=db1
master-user=repl
master-password=xxxxxx
log-slave-updates
server-id=1
Server2 has:
[mysqld]
log-bin=/var/lib/mysql/binary_log
master-host=db2
master-user=repl
master-password=xxxxxx
log-slave-updates
server-id=2
I've verified many times that replication works in general. But
both
servers are frequently getting into a situation where I continuously get:
--- (from server 1) -----------
010125 11:08:36 Slave: reconnected to master,replication resumed in log 'binary_log.001
' at position 1169067
010125 11:08:36 Error reading packet from server: Could not find first
log (read_errno 0,server_errno=65535)
--- (from server 2) -----------
010125 11:09:20 Slave: reconnected to master,replication resumed in log 'binary_log.002
' at position 19702
010125 11:09:20 Error reading packet from server: Could not find first
log (read_errno 0,server_errno=65535)
This just goes on and on. How can I remedy this??
Thanks
Ricardo
