Bug #40142 rpl_start_stop_slave times out sporadically in pushbuild

Submitted: 19 Oct 2008 13:59 Modified: 30 Jan 2009 17:41
Reporter: Sven Sandberg Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:6.0-rpl, 5.1 OS:Linux (sles10-ia64)
Assigned to: Serge Kozlov CPU Architecture:Any
Tags: 51rpl, 6.0-rpl-green, pushbuild, rpl_start_stop_slave, sporadic, test failure

[19 Oct 2008 13:59] Sven Sandberg
Description:
rpl_start_stop_slave times out sporadically in 6.0-rpl in pushbuild on sles10-ia64-a-1 and sles10-ia64-a-2:

rpl.rpl_start_stop_slave                 [ fail ]  timeout after 15 minutes

Test case timeout after 15 minute(s)

 == /dev/shm/var-ps_row-151/5/tmp/analyze-timeout-mysqld.1.err ==
SHOW PROCESSLIST;
Id	User	Host	db	Command	Time	State	Info
185	root	localhost:58347	NULL	Sleep	879	NULL	NULL
186	root	localhost	NULL	Query	0	NULL	SHOW PROCESSLIST

Timeout [timer - pid: 25863, exit: 0] expired for running 'analyze-timeout'
 - saving '/dev/shm/var-ps_row-151/5/log/rpl.rpl_start_stop_slave/' to '/dev/shm/var-ps_row-151/log/rpl.rpl_start_stop_slave/'

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

Another failure with different processlist:

rpl.rpl_start_stop_slave                 [ fail ]  timeout after 15 minutes

Test case timeout after 15 minute(s)

 == /dev/shm/var-ps_stm_threadpool-171/7/tmp/analyze-timeout-mysqld.1.err ==
SHOW PROCESSLIST;
Id	User	Host	db	Command	Time	State	Info
42	root	localhost:43503	NULL	Sleep	901	NULL	NULL
43	root	localhost	NULL	Query	0	Waiting on cond	SHOW PROCESSLIST

Timeout [timer - pid: 9803, exit: 0] expired for running 'analyze-timeout'
 - saving '/dev/shm/var-ps_stm_threadpool-171/7/log/rpl.rpl_start_stop_slave/' to '/dev/shm/var-ps_stm_threadpool-171/log/rpl.rpl_start_stop_slave/'

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

How to repeat:
The first failure is on https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=78 sles10-ia64-a-2/ps_row

The second failure is on https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=73 sles10-ia64-a-2/ps_stm_threadpool

xref: http://tinyurl.com/5wz4k6
[7 Dec 2008 22:05] 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/60839

2747 Serge Kozlov	2008-12-08
      Bug#40142: possible reason of timeout is stopped slave threads before sync_with_master
      command. The patch add waiting of proper state of slave before sync with master.
[12 Dec 2008 11: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/61465

2706 Serge Kozlov	2008-12-12
      Bug#40142: possible reason of timeout is stopped slave threads before
      sync_with_master command. The patch add waiting of proper state of slave 
      before sync with master.
[12 Dec 2008 13:08] 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/61480

2751 Serge Kozlov	2008-12-12 [merge]
      Merge. Bug#40142, Bug#41108, Bug#41186
[15 Dec 2008 9: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/61645

2743 He Zhenxing	2008-12-15 [merge]
      Auto merge
[30 Jan 2009 13:29] 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:09] Bugs System
Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:alfranio.correia@sun.com-20081213194819-3u93g1xpzyy18u28) (merge vers: 5.1.31) (pib:6)
[30 Jan 2009 17:41] Paul DuBois
Test case changes. No changelog entry needed.
[17 Feb 2009 14:56] 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:44] 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:20] 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)

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

Page generated in 0.077 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.