Bug #40574 main.thread_cache_size_func fails in pushbuild when run with pool of threads

• Submitted: 7 Nov 2008 12:42
• Modified: 21 Jan 17:03
• Reporter: Georgi Kodinov
• Status: Closed
• Category: Tests: Server
• Severity: S2 (Serious)
• Version: 6.0-bugteam
• OS: Any (SLES-ia64a)
• Assigned to: Horst Hunger
• Target Version: 6.0
• Tags: pusbuild
• Triage: Triaged: D3 (Medium)

[7 Nov 2008 12:42] Georgi Kodinov

Description:
The test fails in 6.0-bugteam tree when run with '-ps-protocol
--mysqld=--binlog-format=statement --mysqld=--thread-handling=pool-of-threads' since the
following push : http://tinyurl.com/5sasj9
The failure (http://tinyurl.com/6px57o):
main.thread_cache_size_func    [ fail ]

---
/data0/pushbuild/pb2-1/pb/bzr_mysql-6.0-bugteam/261/mysql-6.0.9-alpha-pb261/mysql-test/r/thread_cache_size_func.result	2008-11-07
11:48:20.000000000 +0300
+++
/data0/pushbuild/pb2-1/pb/bzr_mysql-6.0-bugteam/261/mysql-6.0.9-alpha-pb261/mysql-test/r/thread_cache_size_func.reject	2008-11-07
13:21:21.000000000 +0300
@@ -18,7 +18,7 @@
 ** Disconnecting conn1,conn2,conn3,conn4 **
 SHOW STATUS LIKE 'Threads_cached';
 Variable_name	Value
-Threads_cached	3
+Threads_cached	0
 3 Expected
 SET @@GLOBAL.thread_cache_size= 1;
 ** Connecting conn1 using username 'root' **
@@ -27,6 +27,6 @@
 ** Disconnecting conn1,conn2 **
 SHOW STATUS LIKE 'Threads_cached';
 Variable_name	Value
-Threads_cached	1
+Threads_cached	0
 1 Expected
 SET @@GLOBAL.thread_cache_size = @global_thread_cache_size;

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

main.thread_handling_basic     [ pass ]             20

How to repeat:
Run the test with '-ps-protocol --mysqld=--binlog-format=statement
--mysqld=--thread-handling=pool-of-threads'

Suggested fix:
Fix the test so it's not dependent on the run mode

[7 Nov 2008 12:46] 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/58168

2916 Georgi Kodinov	2008-11-07
      Bug #40574: main.thread_cache_size_func fails in pushbuild when run with
      pool of threads
      
        Disabled the test

[7 Nov 2008 12:50] Davi Arnaut

It seems that we need to determine whether Threads_cached is meaningful under pool of
threads.

[10 Nov 2008 11:51] Bugs System

Pushed into 6.0.9-alpha  (revid:[e-mail]-20081107114516-u0tmtttjhpe3loox)
(version source revid:[e-mail]-20081107114516-u0tmtttjhpe3loox) (pib:5)

[4 Dec 2008 12:28] 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/60588

2751 Horst Hunger	2008-12-04
      Fix for Bug#40574: testing the thread per connection make only sense if that thread
handling is set. In all other cases the must be skipped.

[4 Dec 2008 12:59] Matthias Leich

ok, to push
Please do not set the line in disabled.def to comment.
Remove it.

[5 Dec 2008 17:39] Patrick Crews

Ok to push as long as we remove the line from disabled.def.

[9 Dec 2008 13:03] 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/61040

2751 Horst Hunger	2008-12-09
      Fix for Bug#40574 after reviews: testing the thread per connection make only sense
if that thread handling is set. In all other cases the must be skipped.

[9 Dec 2008 15:54] Horst Hunger

pushed into 6.0 bugteam tree.

[20 Jan 19:59] Bugs System

Pushed into 6.0.10-alpha (revid:[e-mail]-20090119171328-2hemf2ndc1dxl0et) (version
source revid:[e-mail]-20081230114916-c290n83z25wkt6e4) (merge vers:
6.0.9-alpha) (pib:6)

[21 Jan 17:03] Paul DuBois

Test case changes. No changelog entry needed.