Bug #47978 timer : expired after 90 seconds

• Submitted: 11 Oct 2009 14:59
• Modified: 17 Jun 2010 19:36
• Reporter: Vladislav Vaintroub
• Status: Closed
• Category: Tools: MTR / mysql-test-run
• Severity: S3 (Non-critical)
• Version: mysql-next-mr
• OS: Any
• Assigned to: Bjorn Munch

[11 Oct 2009 14:59] Vladislav Vaintroub

Description:
When running mtr with --paralell=10, 

I'm getting

timer -5932: expired after 90 seconds
main.mysqltest                           w7 [ pass ]  30045
timer -5696: expired after 90 seconds
main.sp-security                         w1 [ pass ]    374

After that, CPU utilization drops to ~1 %  from ~70%(the whole reason to run --parallel
is that mtr is painfully slow and does only utilize CPU  to 5-7% in the normal case ).

How to repeat:
mtr --paralell=10

Suggested fix:
No idea.

[12 Oct 2009 11:38] Bjorn Munch

You can't really expect this to work smoothly, if nothing else, disk contention would
likely slow things down considerably.

[27 Oct 2009 12:18] 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/88338

2851 Bjorn Munch	2009-10-27
      Bug #47978 timer : expired after 90 seconds
      Problems occur after killing threads on Windows
      Get rid of the timeout threads, implement simple timer in wait_any_timeout()

[27 Oct 2009 12:24] Bjorn Munch

This requires some active polling, OTOH we kan skip the fork. And I've set the time
between polls to increase slowly so we don't poll 100 times per second for tests taking
longer.

[24 Nov 2009 8:15] 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/91383

2861 Bjorn Munch	2009-11-24
      Bug #47978 timer : expired after 90 seconds
      Problems occur after killing threads on Windows
      Get rid of the timeout threads, implement simple timer in wait_any_timeout()

[24 Nov 2009 13:03] Bjorn Munch

Pushed to 5.1-mtr, trunk-mtr, next-mr-mtr, 6.0-codebase-mtr

[20 Feb 2010 9:32] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100220092844-jh07ayojyxn8uh9p) (version
source revid:[e-mail]-20091124125609-1yzq2dlkedgj34wr) (merge vers:
6.0.14-alpha) (pib:16)

[20 Feb 2010 9:34] Bugs System

Pushed into 5.5.3-m2 (revid:[e-mail]-20100220092622-wvhh1vfy5tjq4mhu) (version source
revid:[e-mail]-20091124112606-seetky6u168kxmgk) (merge vers: 5.5.0-beta)
(pib:16)

[20 Feb 2010 9:37] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100220092730-paoo5t9gcajs5dq8) (version
source revid:[e-mail]-20091124112719-cn314iyf7ngc6wr1) (pib:16)

[20 Feb 2010 19:01] Paul DuBois

Changes to test suite. No changelog entry needed.

Setting report to Need Merge pending push to 5.1.x.

[1 Mar 2010 8:45] Bugs System

Pushed into 5.1.45 (revid:[e-mail]-20100301083827-xnimmrjg6bh33o1o) (version source
revid:[e-mail]-20100222175719-viuh0f3gdsrkgv0r) (merge vers: 5.1.45) (pib:16)

[1 Mar 2010 16:15] Paul DuBois

No changelog entry needed.

[17 Jun 2010 12:19] Bugs System

Pushed into 5.1.47-ndb-7.0.16
(revid:[e-mail]-20100617114014-bva0dy24yyd67697) (version source
revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46)
(pib:16)

[17 Jun 2010 13:06] Bugs System

Pushed into 5.1.47-ndb-6.2.19
(revid:[e-mail]-20100617115448-idrbic6gbki37h1c) (version source
revid:[e-mail]-20100609140708-52rvuyq4q500sxkq) (merge vers:
5.1.45-ndb-6.2.19) (pib:16)

[17 Jun 2010 13:47] Bugs System

Pushed into 5.1.47-ndb-6.3.35
(revid:[e-mail]-20100617114611-61aqbb52j752y116) (version source
revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46)
(pib:16)