MySQL Bugs: #46882: Suite timeout doesn't kill stray processes

Bug #46882	Suite timeout doesn't kill stray processes
Submitted:	24 Aug 2009 8:02	Modified:	14 Oct 2010 13:33
Reporter:	Kent Boortz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tools: MTR / mysql-test-run	Severity:	S7 (Test Cases)
Version:	5.0	OS:	Any
Assigned to:	Bjørn Munch	CPU Architecture:	Any

Description:
On some slow hosts we get suite timeout but stray "mysqld" processes without
a parent are left running. On some/most/all Unix systems this means the "sshd"
will not terminate, waiting for all processes associated to terminate. And this
means we manually have to kick builds, making builds on slow machines even
slower, potentially delaying releases.

How to repeat:
This is observed during many release builds.

Setting high priority - risk to release schedules.

I would like some more "situation report" to know the nature of this problem:

Exactly what processes are left behind: my_safe_process and its child mysqld, or only mysqld (with 1 as parent)?

Have any tests failed imediately with mysqld complaining "Address already in use"?

Is it possible to see from timestamps whether the stray process(es) belong to the last test that was executed?

Observed in one instance on I5/OS: one mysqld process was left running but had been "orphaned". Presumably it must come from the last test, otherwise tests should have failed due to unavailable port.

This test suite had timed out, not yet known if it only happens then or if it can happen on other OS'es.

I also need to know which version, 5.0 or higher?

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/103699

2853 Bjorn Munch	2010-03-18
      Bug #46882 Suite timeout doesn't kill stray processes
      Call mtr_kill_leftovers() before terminating

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/103702

2853 Bjorn Munch	2010-03-18
      Bug #46882 Suite timeout doesn't kill stray processes
      Kill mysqltest and call mtr_kill_leftovers() before terminating

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/110980

2873 Bjorn Munch	2010-06-14
      Bug #46882 Suite timeout doesn't kill stray processes
      Kill mysqltest and call mtr_kill_leftovers() before terminating

Pushed to 5.0-bugteam, ported to lib/v1 and pushed to 5.1-bugteam and trunk-merge.

Pushed into 5.5.5-m3 (revid:alexey.kopytov@sun.com-20100615145247-8bj0vmuqlotbqsn9) (version source revid:bjorn.munch@sun.com-20100614093310-7vcxb111z5nxpnv6) (merge vers: 5.5.5-m3) (pib:16)

Pushed into mysql-next-mr (revid:alik@sun.com-20100615150216-cubqoyn1fj9b6a2p) (version source revid:alik@sun.com-20100615081608-4ieksdrefamsw3v9) (pib:16)

Changes to test suite. No changelog entry needed.

Pushed into 5.1.49 (revid:build@mysql.com-20100719143034-omcma40sblwmay3x) (version source revid:bjorn.munch@sun.com-20100614093122-gzn688k5z81fsyd6) (merge vers: 5.1.48) (pib:16)

Pushed into 5.0.92 (revid:georgi.kodinov@oracle.com-20100802074824-5201e4ppst9t3yqt) (version source revid:bjorn.munch@sun.com-20100614092642-x2gph634ezfr94xg) (merge vers: 5.0.92) (pib:18)

Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.20 (revid:martin.skold@mysql.com-20101014082627-jrmy9xbfbtrebw3c) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:21)

Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.39 (revid:martin.skold@mysql.com-20101014083757-5qo48b86d69zjvzj) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:21)

Pushed into mysql-5.1-telco-6.2 5.1.51-ndb-6.2.19 (revid:martin.skold@mysql.com-20101014084420-y54ecj85j5we27oa) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:21)

Set back to Closed state -- see previous comments.