Bug #36733 main.thread_cache_size_func fails randomly

Submitted: 15 May 2008 9:42 Modified: 10 Nov 2008 17:38
Reporter: Georgi Kodinov Email Updates:
Status: Closed Impact on me:
None 
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:horst@mysql.com-20081015191249-a2u7h2b3ukpo0b0t) (version source revid:horst@mysql.com-20081015191249-a2u7h2b3ukpo0b0t) (pib:5)
[10 Nov 2008 11:35] Bugs System
Pushed into 5.1.30  (revid:horst@mysql.com-20081015185853-hjehqk2qr0takhoi) (version source revid:horst@mysql.com-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:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-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:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-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:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.070 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.