Bug #39937 Sporadic failures of main.status around results containing the word "thread"
Submitted: 8 Oct 2008 17:30 Modified: 5 Feb 2009 13:03
Reporter: Matthias Leich Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:6.0+ OS:Any
Assigned to: Horst Hunger CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[8 Oct 2008 17:30] Matthias Leich
Description:
The sporadic failure:
---------------------
--- ... status.result ...
+++ ... status.reject ...
@@ -218,7 +218,9 @@
 FLUSH STATUS;
 SELECT * FROM v1 WHERE NAME = 'Threads_connected' AND VALUE < @tc;
 NAME	VALUE
+THREADS_CONNECTED	4
 SELECT * FROM v1 WHERE NAME = 'Threads_running' AND VALUE < @tr;
 NAME	VALUE
+THREADS_RUNNING	1
 DROP VIEW v1;
 set @@global.concurrent_insert= @old_concurrent_insert;

How often:
~123 times in Pushbuild between 2008 May till October 
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
All failures occur in a subtest for
   Bug #17954: Threads_connected > Threads_created
around line 296 of the script. This subtest does
only exist in MySQL version >= 6.0.

How to reproduce the problem outside of Pushbuild:
./mysql-test-run.pl  `perl -e 'for (1 .. 100) { print "status "}'`
+ some "luck"

How to repeat:
Please see above
[2 Feb 2009 9:13] Lars Thalmann
See also BUG#39857
[3 Feb 2009 13:31] 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/65003

3007 Horst Hunger	2009-02-03
      Fix for bug#39937: Set the disconnect_timeout to 30 seconds to have more time in case of lower performance and specified a weaker condition as sometime also a "Quit" is counted as query.
[3 Feb 2009 14:47] 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/65022

2768 Horst Hunger	2009-02-03
      Revised fix for bug#39937: Set the disconnect_timeout to 30 seconds to have more time in
      case of lower performance and specified a weaker condition as sometime also a "Quit" is
      counted as query.
[4 Feb 2009 10: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/65109

2768 Horst Hunger	2009-02-04
      New fix for bug#39937: I inserted a waiting until the server has gone and increased the disconnection_timeout to 30 seconds to give the server more time to change the status variables in case of low perfoemance. I tried to change as less as possible in the test, means no changes in the result.
[4 Feb 2009 19:00] Davi Arnaut
Duplicate of Bug#37481?