A week ago I posted that we were having horrible problems with MySQL's replication failing and reconnecting (after years of reliable operation). I still haven't come up with a solution to the problems, it just looks like the master keeps tearing down the replication connection, and the slave keeps reconnecting. Setting up more slaves, they exhibit the same exact problems. As noted in my previous emails, after about 4-6 errors like this:
040707 2:24:44 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 040707 2:24:44 Slave: Failed reading log event, reconnecting to retry, log 'mysql-bin.178' position 13468249 040707 2:24:44 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'mysql-bin.178' at position 13468249 040707 2:39:57 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 040707 2:39:57 Slave: Failed reading log event, reconnecting to retry, log 'mysql-bin.178' position 25712380 040707 2:39:57 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'mysql-bin.178' at position 25712380 The replication would completely stop with this error: 040702 4:13:51 Slave thread exiting, replication stopped in log 'mysql-bin.167' at position 108374685 Well, it turns out the slave disconnecting and reconnecting does not appear to be related to the slave stopping (odd since they both became problems around the same time). It looks like at 4am, our optimize database script fires off on the SLAVE, and it looks like the slave thread dies a little while after. I have turned off nightly optimization, and for the past 5 days, we have not seen the slave stop. So I would believe that we are running into bug: http://bugs.mysql.com/bug.php?id=1858 on the 3.53.57/3.53.58 line of code. The bug was already fixed on the 4.0.x line of code, but presumably a patch needs to be made to the 3.53.x line of code aswell. As for the rest of my replication problems... who knows :) Thanks, -Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]