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: Bjørn Munch
• CPU Architecture: Any

[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] Bjørn 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] Bjørn 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] Bjørn 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)