Bug #28873 ALTER EVENT let server crash.
Submitted: 4 Jun 2007 12:53 Modified: 3 Jul 2007 17:42
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S1 (Critical)
Version:5.1.19 OS:Linux (suse 10.1)
Assigned to: Andrey Hristov CPU Architecture:Any

[4 Jun 2007 12:53] Horst Hunger
Description:
The test program that caused the crash is attached. 
It might have to do with privileges as a "REVOKE event ..." is involved.
the backtrace:

Program terminated with signal 11, Segmentation fault.

warning: Can't read pathname for load map: Eingabe-/Ausgabefehler.
Reading symbols from /lib/libz.so.1...done.
Loaded symbols for /lib/libz.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/libpthread.so.0...done.
Loaded symbols for /lib/libpthread.so.0
Reading symbols from /lib/librt.so.1...done.
Loaded symbols for /lib/librt.so.1
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libm.so.6...done.
Loaded symbols for /lib/libm.so.6
Reading symbols from /lib/libc.so.6...done.
Loaded symbols for /lib/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libgcc_s.so.1...done.
Loaded symbols for /lib/libgcc_s.so.1
#0  0xffffe410 in __kernel_vsyscall ()
(gdb) bt
#0  0xffffe410 in __kernel_vsyscall ()
#1  0xb7f845f6 in pthread_kill () from /lib/libpthread.so.0
#2  0x0842f05b in write_core (sig=11) at stacktrace.c:229
#3  0x08275188 in handle_segfault (sig=11) at mysqld.cc:2237
#4  <signal handler called>
#5  0x0845e1f8 in Event_job_data::execute (this=0xb742e3bc, thd=0x8a33c28, drop=false)
    at event_data_objects.cc:1989
#6  0x0845d219 in Event_worker_thread::run (this=0xb742e45f, thd=0x8a33c28,
    event=0x8984250) at event_scheduler.cc:308
#7  0x0845d330 in event_worker_thread (arg=0x8984250) at event_scheduler.cc:258
#8  0xb7f8034b in start_thread () from /lib/libpthread.so.0
#9  0xb7ea165e in clone () from /lib/libc.so.6
(gdb)

How to repeat:
copy the attched fiel into .../mysql-test/t, generate a result file (touch ...) and execute
perl mysql-test-run.pl  ev_bug5
[4 Jun 2007 13:07] MySQL Verification Team
Thank you for the bug report. Verified as described.
[6 Jun 2007 17:04] Andrey Hristov
Possible duplicate of bug#28924 "If I drop the user who is the definer of an active event then server cores"
[27 Jun 2007 12:40] Andrey Hristov
Fix for bug#29156 fixes the problem
[3 Jul 2007 17:42] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.1.21 changelog per Andrey's comments.