Bug #41154 main.bootstrap timeouts sporadically in pushbuild

• Submitted: 1 Dec 2008 16:59
• Modified: 15 Jan 2009 8:07
• Reporter: Sven Sandberg
• Status: Can't repeat
• Category: Tests: Server
• Severity: S7 (Test Cases)
• Version: 6.0
• OS: Any
• Assigned to: Zhenxing He
• CPU Architecture: Any
• Tags: 6.0-rpl-green, main.boostrap, pushbuild, sporadic, test failure, timeout

[1 Dec 2008 16:59] Sven Sandberg

Description:
sporadic pushbuild failure:

main.bootstrap                           [ fail ]  timeout after 900 minutes

Test case timeout after 900 seconds

== e:/var-ps_row-101/log/bootstrap.log == 
drop table if exists t1;

 == e:/var-ps_row-101/tmp/analyze-timeout-mysqld.1.err ==
SHOW PROCESSLIST;
Id	User	Host	db	Command	Time	State	Info
168	root	localhost:3273	NULL	Query	0	NULL	SHOW PROCESSLIST

 - saving 'e:/var-ps_row-101/log/main.bootstrap/' to 'e:/var-ps_row-101/log/main.bootstrap/'

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

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=112 vm-win2003-32-a/ps_row
xref: http://tinyurl.com/5kvbaq

[8 Jan 2009 12:27] Sven Sandberg

the recent failures have more debug info:

main.bootstrap                           [ fail ]  timeout after 900 seconds
        Test ended at 2008-12-15 18:15:41

Test case timeout after 900 seconds

== e:/var-ps_row-101/log/bootstrap.log == 
drop table if exists t1;

 == e:/var-ps_row-101/tmp/analyze-timeout-mysqld.1.err ==
SHOW PROCESSLIST;
Id	User	Host	db	Command	Time	State	Info
141	root	localhost:1344	NULL	Query	0	NULL	SHOW PROCESSLIST

 - saving 'e:/var-ps_row-101/log/main.bootstrap/' to 'e:/var-ps_row-101/log/main.bootstrap/'
Too many tests(10) failed! Terminating...
mysql-test-run: *** ERROR: Test suite aborted

The only command that made it to the query log was the initial 'drop table'. The most likely candidate to cause the timeout is then the call to "exec $MYSQLD_BOOTSTRAP_CMD" on line 20.