Bug #39570 rpl_truncate_2myisam timeouts sporadically on pushbuild

Submitted: 21 Sep 2008 15:47 Modified: 30 Jan 2010 10:33
Reporter: Sven Sandberg Email Updates:
Status: Can't repeat Impact on me:
None 
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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.