Bug #40704 main.events_restart fails sporadically in pushbuild: "server has gone away"
Submitted: 13 Nov 2008 16:32 Modified: 30 Jan 2009 17:35
Reporter: Sven Sandberg Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S7 (Test Cases)
Version:5.1-rpl, 6.0-rpl OS:Any
Assigned to: Zhenxing He CPU Architecture:Any
Tags: 5.1-rpl-green, 51rpl, 6.0-rpl-green, events_restart, pushbuild, sporadic, test failure

[13 Nov 2008 16:32] Sven Sandberg 
Description:
main.events_restart fails sporadically in pushbuild with the following message:

main.events_restart                      [ fail ]

CURRENT_TEST: main.events_restart
mysqltest: At line 48: query 'use events_test' failed: 2006: MySQL server has gone away

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-ps_row-121/3/log/main.events_restart/' to '/dev/shm/var-ps_row-121/log/main.events_restart/'

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

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-rpl&order=74 sapsrv2/ps_row
xref: http://tinyurl.com/65pupo
[24 Nov 2008 13:31] Andrei Elkin 
Fyi: met this failure at 6.0 main -> rpl merging today.
[25 Nov 2008 14:23] Andrei Elkin 
Actually the failure only looked similarly. There is no crash in my case but rather these lines in the mtr log:

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
[15 Dec 2008 14:11] Matthias Leich 
No success till now in
1. Search for more information about this failure in
   Pushbuild runs
2. attempts to replay the problem
[19 Dec 2008 15:48] 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/62129

2711 Magnus Svensson	2008-12-19
      Bug #40704  	main.events_restart fails sporadically in pushbuild: "server has gone away"
[25 Dec 2008 9:53] 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/62320

2708 He Zhenxing	2008-12-25
      BUG#40704 main.events_restart fails sporadically in pushbuild: "server has gone away"
      
      mysqltest command 'shutdown_server' is supposed to shutdown the server
      and wait for it to be gone, and kill it when timeout. But because the
      arguments passed to my_kill were in the wrong order, 'shutdown_server'
      does not wait nor kill the server at all. So after 'shutdown_server',
      the server is still running, and the server may still accepting
      connections.
[7 Jan 2009 13:52] 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/62597

2775 He Zhenxing	2009-01-07 [merge]
      Merge patch for BUG#40704 from 5.1-rpl to 6.0-rpl
[7 Jan 2009 14:26] 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/62605

2709 He Zhenxing	2009-01-07 [merge]
      Auto merge
[9 Jan 2009 8:35] Zhenxing He 
pushed to 5.1-rpl and 6.0-rpl
[30 Jan 2009 13:27] 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 15:08] Bugs System 
Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:zhenxing.he@sun.com-20090107142538-aeoxq3lddk0g4uff) (merge vers: 5.1.31) (pib:6)
[30 Jan 2009 17:35] Paul DuBois 
Test case changes. No changelog entry needed.
[17 Feb 2009 14:54] Bugs System 
Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 16:42] Bugs System 
Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 18:18] Bugs System 
Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090201210519-vehobc4sy3g9s38e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)