Bug #36733 main.thread_cache_size_func fails randomly

• Submitted: 15 May 2008 9:42
• Modified: 10 Nov 2008 17:38
• Reporter: Georgi Kodinov
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• Assigned to: Horst Hunger
• CPU Architecture: Any
• Tags: tests random failures

[15 May 2008 9:42] Georgi Kodinov

Description:
The new test main.thread_cache_size_func fails randomly in both 5.1-bugteam (http://tinyurl.com/4angtm) and 5.1-main(http://tinyurl.com/4w38z7).

with messages like : 
main.thread_cache_size_func    [ fail ]

--- /data0/pushbuild/pb2/pb/mysql-5.1/1626/mysql-5.1.25-rc-pb1626/mysql-test/r/thread_cache_size_func.result	2008-05-14 18:43:16.000000000 +0300
+++ /data0/pushbuild/pb2/pb/mysql-5.1/1626/mysql-5.1.25-rc-pb1626/mysql-test/r/thread_cache_size_func.reject	2008-05-15 05:39:46.264357523 +0300
@@ -29,7 +29,7 @@
 0 Expected
 SHOW STATUS LIKE 'Threads_cached';
 Variable_name	Value
-Threads_cached	3
+Threads_cached	2
 3 Expected
 SET @@GLOBAL.thread_cache_size=1;
 Saving threads cached, threads created values
@@ -38,7 +38,7 @@
 0 Expected
 SHOW STATUS LIKE 'Threads_cached';
 Variable_name	Value
-Threads_cached	3
+Threads_cached	2
 1 Expected
 Bug: The number of threads cached should have decreased with cache size decrease.
 ** Connecting conn1 using username 'root' **
@@ -50,7 +50,7 @@
 Bug: The number of threads created should have increased because the cache should have 1 thread only
 SHOW STATUS LIKE 'Threads_cached';
 Variable_name	Value
-Threads_cached	1
+Threads_cached	0
 0 Expected
 Bug: The number of threads created should have decreased because atleast 1 new connection came in
 ** Connection default **

I'm disabling it until the random failure is addressed.

How to repeat:
Run the test enough times

[28 Aug 2008 17:16] 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/52869

2729 Horst Hunger	2008-08-28
      Fix for bug#36733: Replaced sleeps by polling and reduced test to needed code.

[1 Sep 2008 16:18] Matthias Leich

Review with comments sent via email to Horst.
If the recommended changes are followed
ok to push.

[11 Sep 2008 15:53] 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/53839

2735 Horst Hunger	2008-09-11
      Changes as result of the 1. review for Bug#36733.

[29 Sep 2008 12:58] Patrick Crews

Ok to push.

[15 Oct 2008 18:57] 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/56290

2667 Horst Hunger	2008-10-15
      Final patch for bug#36733 containing all changes.

[15 Oct 2008 19: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/56291

2875 Horst Hunger	2008-10-15 [merge]
      Merge of patch for bug#36733 from 5.1 to 6.0

[10 Nov 2008 10:51] Bugs System

Pushed into 6.0.8-alpha  (revid:[e-mail]-20081015191249-a2u7h2b3ukpo0b0t) (version source revid:[e-mail]-20081015191249-a2u7h2b3ukpo0b0t) (pib:5)

[10 Nov 2008 11:35] Bugs System

Pushed into 5.1.30  (revid:[e-mail]-20081015185853-hjehqk2qr0takhoi) (version source revid:[e-mail]-20081015185853-hjehqk2qr0takhoi) (pib:5)

[10 Nov 2008 17:38] Paul DuBois

Test case changes. No changelog entry needed.

[19 Jan 2009 11:27] Bugs System

Pushed into 5.1.31-ndb-6.2.17 (revid:[e-mail]-20090119095303-uwwvxiibtr38djii) (version source revid:[e-mail]-20090108105244-8opp3i85jw0uj5ib) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)

[19 Jan 2009 13:05] Bugs System

Pushed into 5.1.31-ndb-6.3.21 (revid:[e-mail]-20090119104956-guxz190n2kh31fxl) (version source revid:[e-mail]-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)

[19 Jan 2009 16:11] Bugs System

Pushed into 5.1.31-ndb-6.4.1 (revid:[e-mail]-20090119144033-4aylstx5czzz88i5) (version source revid:[e-mail]-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)