Bug #11233 More threads shown to be running than expected
Submitted: 10 Jun 2005 10:09 Modified: 3 Aug 2005 2:53
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.7 OS:Linux (Linux x86_64)
Assigned to: Jim Winstead CPU Architecture:Any

[10 Jun 2005 10:09] Joerg Bruehe
Description:
Build of 5.0.7, based on ChangeSet
  1.1950 05/06/09 16:53:08 kent@mysql.com +12 -0
  Many files:
    More yaSSL changes in Visual Studio 6 project files

In the "debug" build on "hammer", test "information_schema" failed. This happened in both the default and the "--ps-protocol" run, but only on this machine. Different scheduling?

-------------------------------------------------------
*** r/information_schema.result Thu Jun  9 18:11:40 2005
--- r/information_schema.reject Thu Jun  9 19:06:18 2005
***************
*** 676,682 ****
  Variable_name Value
  show global status like "Threads_running";
  Variable_name Value
! Threads_running       1
  create table t1(f1 int);
  create table t2(f2 int);
  create view v1 as select * from t1, t2;
--- 676,682 ----
  Variable_name Value
  show global status like "Threads_running";
  Variable_name Value
! Threads_running       2
  create table t1(f1 int);
  create table t2(f2 int);
  create view v1 as select * from t1, t2;
-------------------------------------------------------

How to repeat:
Run the test suite.
[6 Jul 2005 23:58] 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/internals/26743
[2 Aug 2005 23:26] 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/internals/27829
[3 Aug 2005 2:53] Jim Winstead
Fixed in 5.0.14.