Help!
We are getting the following errors on a slave server:
060304 7:42:03 Error reading packet from server: Could not find first log (server_errno=65535)
060304 7:43:03 Slave: Failed reading log event, reconnecting to retry, log 'wcassp801.2514' position 76
060304 7:43:03 Slave: reconnected to master 'repl@10.20.10.10:3306',replication resumed in log 'wcassp801.2514' at position 76
We are running mysql v3.23.58-max-log on a master and slave server. We had a problem earlier with the master where it had to be rebooted without an elegant shutdown. The above errors are now showing up in the slave.
When running “Show master logs”, we find a gap between 2512 and 2514…
| wcassp801.2509 |
| wcassp801.2510 |
| wcassp801.2511 |
| wcassp801.2512 |
| | ß- missing entry
| wcassp801.2515 |
| wcassp801.2516 |
| wcassp801.2517 |
+---------------------------------------------------------------------+
2516 rows in set (0.02 sec)
Yet the missing one, 2514 shows up in unix and appears to be a valid bin log (based on output from mysqlbinlog command)…
[root@wcassp801 log-bin]# ls -lat wcassp801.251[23456]
-rw-rw---- 1 mysql mysql 4922054 Mar 4 06:05 wcassp801.2516
-rw-rw---- 1 mysql mysql 1486137 Mar 4 05:20 wcassp801.2515
-rw-rw---- 1 mysql mysql 5129260 Mar 4 05:05 wcassp801.2514 ß- missing entry
-rw-rw---- 1 mysql mysql 73 Mar 4 04:14 wcassp801.2513
-rw-rw---- 1 mysql mysql 304917025 Mar 4 04:04 wcassp801.2512
[root@wcassp801 log-bin]# mysqlbinlog wcassp801.2514|wc -l
92883
[root@wcassp801 log-bin]# mysqlbinlog wcassp801.2514|tail
)
VALUES
(
'ME', '10014546', 'US', '2006/03/04', 'NEWRY', '1'
)
;
# at 5129220
#060304 5:05:00 server id 33 Rotate to wcassp801.2515
# at 5129247
#060304 5:05:00 server id 33 Stop
[root@wcassp801 log-bin]#
How do we fix this problem?