Bug #27991 Slave crashes during ALTER EVENT query
Submitted: 20 Apr 2007 20:39 Modified: 15 Oct 2007 11:06
Reporter: Serge Kozlov Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.1.18-bk OS:Any (FC4 64bit)
Assigned to: Sven Sandberg CPU Architecture:Any

[20 Apr 2007 20:39] Serge Kozlov
Description:
Seems slave server can't replcate ALTER EVENT query correctly:

How to repeat:
1. Use test file from archive
2. Try  to record result file for one.

=======================================================
Starting Tests in the 'main' suite

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

rpl_bug_event                  [ fail ]

Errors are (from /home/ndbdev/skozlov/builds/mysql-test/var/log/mysqltest-time)
:
mysqltest: At line 16: failed in 'select master_pos_wait('master-bin.000001', 32
4)': 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)
Result from queries before failure can be found in /home/ndbdev/skozlov/builds/m
ysql-test/var/log/rpl_bug_event.log

Aborting: rpl_bug_event failed in default mode. To continue, re-run with '--forc
e'.
Stopping All Servers

3. Look at var/log/slave.err (or use same log from attached file).
[20 Apr 2007 20:42] Serge Kozlov
testcase and log file

Attachment: bug27991.tar.gz (application/x-gzip, text), 1.59 KiB.

[15 Oct 2007 11:06] Sven Sandberg
Can repeat in 5.1.18, but not in latest bk tree (what will become 5.1.23).