Bug #41181 events_restart failed with "query succeeded - should have failed"

• Submitted: 2 Dec 2008 18:23
• Modified: 17 Feb 2009 9:48
• Reporter: Sven Sandberg
• Status: Can't repeat
• Category: Tests: Server
• Severity: S7 (Test Cases)
• Version: 6.0-rpl
• OS: Any
• Assigned to: Horst Hunger
• CPU Architecture: Any
• Tags: events_restart, pushbuild, sporadic, test failure

[2 Dec 2008 18:23] Sven Sandberg

Description:
this pushbuild failure happened only once:

main.events_restart                      [ fail ]

CURRENT_TEST: main.events_restart
mysqltest: At line 53: query 'show events' succeeded - should have failed with errno 1577...

The result from queries just before the failure was:
< snip >
create database events_test;
use events_test;
create table execution_log(name char(10));
create event abc1 on schedule every 1 second do
insert into execution_log value('abc1');
create event abc2 on schedule every 1 second do
insert into execution_log value('abc2');
create event abc3 on schedule every 1 second do 
insert into execution_log value('abc3');
create table event_like like mysql.event;
insert into event_like select * from mysql.event;
alter table mysql.event
change column body  body longtext character set utf8 collate utf8_bin;
"Now we restart the server"
use events_test;
select @@event_scheduler;
@@event_scheduler
OFF

More results from queries before failure can be found in /dev/shm/var-n_mix-100/3/log/events_restart.log

 - saving '/dev/shm/var-n_mix-100/3/log/main.events_restart/' to '/dev/shm/var-n_mix-100/log/main.events_restart/'

Retrying test, attempt(2/3)...

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=75 sapsrv2/n_mix
xref: http://tinyurl.com/6odqnb

Cf. BUG#40704, BUG#41017