Bug #41017 main.events_restart fails in pushbuild: "Server failed to restart"
Submitted: 25 Nov 2008 14:27 Modified: 30 Jan 2009 17:58
Reporter: Sven Sandberg Email Updates:
Status: Closed Impact on me:
None 
Category:Tests Severity:S7 (Test Cases)
Version:6.0-rpl OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any
Tags: 6.0-rpl-green, events_restart, pushbuild, test failure

[25 Nov 2008 14:27] Sven Sandberg
Description:
pushbuild failure. A funny observation: this happened sporadically (very seldom) between 2008-07-13 and 2008-10-29, but started to happen deterministically every time the test was run from 2008-11-24 and on. It never failed outside 6.0-rpl.

main.events_restart                      [ fail ]

CURRENT_TEST: main.events_restart
mysqltest: In included file "./include/wait_until_connected_again.inc": At line 23: Server failed to restart

The result from queries just before the failure was:
set global event_scheduler=off;
drop database if exists events_test;
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"

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

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

Similar to BUG#40704 (but not the same)

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=109 debx86-b/n_mix
xref: http://tinyurl.com/55dmnn
[19 Dec 2008 12:22] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/62085

2752 Andrei Elkin	2008-12-19
      Bug #41017 main.events_restart fails in pushbuild: "Server failed to restart"
      
      The reason of the bug was an incorrect name for the mtr-test expect file.
      
      The name was corrected in the restart macro and an error message in mtr plus
      detailed comments in the macro would serve as a good enough protection
      from the same thing happened again.
      Bug #40636 was found as a dup for the current.
[19 Dec 2008 13:10] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/62086

2763 Andrei Elkin	2008-12-19
      Bug #41017 main.events_restart fails in pushbuild: "Server failed to restart"
            
      The reason of the bug was an incorrect name for the mtr-test expect file.
            
      The name was corrected in the restart macro. Detailed comments in the macro 
      would serve as some protection from the same thing happened again.
      Bug #40636 was found as a dup for the current.
[19 Dec 2008 17:26] Andrei Elkin
Pushed to 6.0-rpl.
[30 Jan 2009 13:26] Bugs System
Pushed into 6.0.10-alpha (revid:luis.soares@sun.com-20090129165607-wiskabxm948yx463) (version source revid:luis.soares@sun.com-20090129163120-e2ntks4wgpqde6zt) (merge vers: 6.0.10-alpha) (pib:6)
[30 Jan 2009 17:58] Paul DuBois
Test suite changes. No changelog entry needed.