今天例行检查数据库时,发现备机IO_THREAD停掉了,而SQL_THREAD仍然运行中。于是使用STOP SLAVE;START SLAVE;打算重新启动IO线程,发现还是启动不起来,查看错误日志发现有这样的错误信息:
090107 15:31:42 [Note] Error reading relay log event: slave SQL thread was killed
090107 15:31:47 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000045' at position 942196485, relay log './slave-relay-bin.007380' position: 235
090107 15:31:47 [Note] Slave I/O thread: connected to master 'doslave@172.16.219.110:3306', replication started in log 'mysql-bin.000045' at position 942196485
090107 15:31:47 [ERROR] Error reading packet from server: error reading log entry ( server_errno=1236)
090107 15:31:47 [ERROR] Got fatal error 1236: 'error reading log entry' from master when reading data from binary log
090107 15:31:47 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000045', position 942196485
090107 15:31:42 [Note] Error reading relay log event: slave SQL thread was killed
090107 15:31:47 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000045' at position 942196485, relay log './slave-relay-bin.007380' position: 235
090107 15:31:47 [Note] Slave I/O thread: connected to master 'doslave@172.16.219.110:3306', replication started in log 'mysql-bin.000045' at position 942196485
090107 15:31:47 [ERROR] Error reading packet from server: error reading log entry ( server_errno=1236)
090107 15:31:47 [ERROR] Got fatal error 1236: 'error reading log entry' from master when reading data from binary log
090107 15:31:47 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000045', position 942196485