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
• Status: Closed
• 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:[e-mail]-20090129165607-wiskabxm948yx463) (version source revid:[e-mail]-20090129163120-e2ntks4wgpqde6zt) (merge vers: 6.0.10-alpha) (pib:6)

[30 Jan 2009 15:09] Bugs System

Pushed into 5.1.32 (revid:[e-mail]-20090129165946-d6jnnfqfokuzr09y) (version source revid:[e-mail]-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:[e-mail]-20090217131017-6u8qz1edkjfiobef) (version source revid:[e-mail]-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:[e-mail]-20090217134419-5ha6xg4dpedrbmau) (version source revid:[e-mail]-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:[e-mail]-20090217134216-5699eq74ws4oxa0j) (version source revid:[e-mail]-20090201210519-vehobc4sy3g9s38e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)