replication error and "missing" binlog
am 04.03.2006 14:42:39 von sean quiltyHelp!
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=3D65535)
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]#=20
How do we fix this problem?