Bug #39570 rpl_truncate_2myisam timeouts sporadically on pushbuild

• Submitted: 21 Sep 2008 15:47
• Modified: 30 Jan 2010 10:33
• Reporter: Sven Sandberg
• Status: Can't repeat
• Category: Tests: Replication
• Severity: S7 (Test Cases)
• Version: 6.0-rpl,5.4
• OS: Any
• Assigned to: Libing Song
• CPU Architecture: Any
• Tags: pushbuild, rpl_truncate_2myisam, sporadic, test failure, timeout

[21 Sep 2008 15:47] Sven Sandberg

Description:
pushbuild failure:

rpl.rpl_truncate_2myisam                 [ fail ]  timeout after 15 minutes

Test case timeout after 15 minute(s)

 == /dev/shm/var-ps_row-131/2/tmp/analyze-timeout-mysqld.1.err ==
SHOW PROCESSLIST;
Id	User	Host	db	Command	Time	State	Info
149	root	localhost:38045	NULL	Sleep	842	NULL	NULL
150	root	localhost	NULL	Query	0	NULL	SHOW PROCESSLIST

Timeout [timer - pid: 16494, exit: 0] expired for running 'analyze-timeout'
 - saving '/dev/shm/var-ps_row-131/2/log/rpl.rpl_truncate_2myisam/' to '/dev/shm/var-ps_row-131/log/rpl.rpl_truncate_2myisam/'

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

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=75 'sles10-ia64-a' vanilla/ps_row

xref: http://tinyurl.com/4c7mco

Suggested fix:
Please check if the test case is just slow (note that it timesout during a call to sleep).

[21 Sep 2008 15:52] Sven Sandberg

Similar symptom in rpl_timezone found on:

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=75 'sles10-ia64-a' no innodb/ps_stm_threadpool
xref: http://tinyurl.com/4l9pk2

[30 Jan 2010 10:33] Libing Song

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_output_id=45a1fd1c9...
The timeout problem can not repeat now, it just appeared 22th Sept. 2009 ago.

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2579560
Another problem happening recently will be fixed by the patch for bug#50414