Greetings!
We have a few master/slave mysql server pairs.
The problem is that the slave disconnects often from the master.
Of course, it reconnects straight away, so if you don't go looking for
it, you may easily miss the problem.
However, executing "show processlist" on the master shows that the
slave comes up with a different Id all the time.
Of course, I didn't forget to assign different server-id's to master
and slave.
There is no problem on the network, as is evident from this snoop log:
slave -master TCP D=3306 S=32897 Ack=626414592 Seq=1800482976 Len=0
Win=49640
master -slave TCP D=32897 S=3306 Push Ack=1800482976 Seq=626414592
Len=150 Win=49640
slave -master TCP D=3306 S=32897 Ack=626414742 Seq=1800482976 Len=0
Win=49640
master -slave TCP D=32897 S=3306 Push Ack=1800482976 Seq=626414742
Len=133 Win=49640
slave -master TCP D=3306 S=32897 Ack=626414875 Seq=1800482976 Len=0
Win=49640
slave -master TCP D=3306 S=32897 Fin Ack=626414875 Seq=1800482976
Len=0 Win=49640
The slave just closes connection, and then reconnects. For no apparent
reason. Nothing in the logs (with log_warnings=1) on either slave or
master.
Almost all our slave/master pairs have this problem.
This is run on Solaris 10 sparc
Mysql versions - tried different ones for slave and master with no luck
- versions from 5.0.12 to 5.0.24a, downloaded from the mysql site.
Googling yields nothing on the subject.
Has anyone seen anything similar?
Tnak you.
