Bug #42602 main.status: random failures

• Submitted: 4 Feb 2009 19:34
• Modified: 17 Feb 2009 18:22
• Reporter: Matthias Leich
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1, 6.0
• OS: Any
• Assigned to: Matthias Leich
• CPU Architecture: Any
• Tags: pushbuild, random, sporadic, test failure

[4 Feb 2009 19:34] Matthias Leich

Description:
mysql-5.1-bugteam PB run 2009-02-04 21:02:04.000000000 +0300
CURRENT_TEST: main.status
--- .../mysql-test/r/status.result
+++ .../mysql-test/r/status.reject
@@ -231,9 +231,9 @@
 CALL p1();
 1
 1
-SELECT 9;
-9
-9
+SELECT 10;
+10
+10
 DROP PROCEDURE p1;
 DROP FUNCTION f1;
 set @@global.concurrent_insert= @old_concurrent_insert;

I was able to replay the problem by shifting the
   disconnect user1;
   disconnect root;
belonging to the subtest for Bug#37908
between the
   CALL p1();
   disconnect user1;  <------
   disconnect root;   <------
   let $new_queries= `SHOW STATUS LIKE 'Queries'`;
of the subtest for Bug#41131.

This is a weakness within the test.
It must be ensured that the disconnects within
subtest for Bug#37908 are finished before
the subtest for Bug#41131 starts.

How to repeat:
See above

[4 Feb 2009 20:14] 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/65240

2770 Matthias Leich	2009-02-04
      Fix for Bug#42602 main.status: random failures
      + minor improvements

[4 Feb 2009 20:56] Patrick Crews

Ok to push.

[5 Feb 2009 16: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/65364

2787 Matthias Leich	2009-02-05
      Fix for Bug#42602 main.status: random failures
      + minor improvements

[5 Feb 2009 17:20] Matthias Leich

Pushed to
mysql-5.1-bugteam
mysql-6.0-bugteam

[9 Feb 2009 22:33] Bugs System

Pushed into 5.1.32 (revid:[e-mail]-20090209214102-gj3sb3ujpnvpiy4c) (version source revid:[e-mail]-20090209214102-gj3sb3ujpnvpiy4c) (merge vers: 5.1.32) (pib:6)

[14 Feb 2009 13:01] Bugs System

Pushed into 6.0.10-alpha (revid:[e-mail]-20090212211028-y72faag15q3z3szy) (version source revid:[e-mail]-20090206100220-tkvd9v83791i895x) (merge vers: 6.0.10-alpha) (pib:6)

[17 Feb 2009 14:54] Bugs System

Pushed into 5.1.32-ndb-6.3.23 (revid:[e-mail]-20090217131017-6u8qz1edkjfiobef) (version source revid:[e-mail]-20090216083408-rmvyaxjt6mk8sg1y) (merge vers: 5.1.32-ndb-6.3.23) (pib:6)

[17 Feb 2009 16:41] Bugs System

Pushed into 5.1.32-ndb-6.4.3 (revid:[e-mail]-20090217134419-5ha6xg4dpedrbmau) (version source revid:[e-mail]-20090216083646-m8st11oj1hhfuuh5) (merge vers: 5.1.32-ndb-6.4.3) (pib:6)

[17 Feb 2009 18:17] Bugs System

Pushed into 5.1.32-ndb-6.2.17 (revid:[e-mail]-20090217134216-5699eq74ws4oxa0j) (version source revid:[e-mail]-20090211111208-wf0acl7c1vl5653e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)

[17 Feb 2009 18:22] Paul DuBois

Test suite changes. No changelog entry needed.