Bug #55576 Two perfschema tests failed on mysql-next-mr-innodb PB2 tests
Submitted: 27 Jul 2010 2:59 Modified: 10 Dec 2010 10:11
Reporter: Jimmy Yang Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.6, 5,5 OS:Any
Assigned to: Marc Alff
Triage: Triaged: D3 (Medium)

[27 Jul 2010 2:59] Jimmy Yang
Description:
There are two perfschema tests failed on our PB2 test run on mysql-next-mr-innodb branches:

 perfschema.start_server_on
 perfschema.server_init

1) perfschema.start_server_on               [ fail ]
        Test ended at 2010-07-26 15:32:21

....
-Performance_schema_mutex_instances_lost	0
+Performance_schema_mutex_instances_lost	181
 

 
2) perfschema.server_init                   [ fail ]
        Test ended at 2010-07-26 17:03:12

CURRENT_TEST: perfschema.server_init
--- /export/home2/pb2/test/sb_1-2078845-1280150348.61/mysql-5.6.99-m4-freebsd7.0-i386-test/mysql-test/suite/perfschema/r/server_init.result	2010-07-26 14:12:33.000000000 +0300
+++ /export/home2/pb2/test/sb_1-2078845-1280150348.61/mysql-5.6.99-m4-freebsd7.0-i386-test/mysql-test/suite/perfschema/r/server_init.reject	2010-07-26 18:03:12.000000000 +0300
@@ -126,7 +126,7 @@
 select count(name) from MUTEX_INSTANCES
 where name like "wait/synch/mutex/sql/LOG_INFO::lock";
 count(name)
-1
+0
 select count(name) from MUTEX_INSTANCES
 where name like "wait/synch/mutex/sql/Query_cache::structure_guard_mutex";
 count(name)
@@ -134,7 +134,7 @@
 select count(name) from MUTEX_INSTANCES
 where name like "wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state";
 count(name)
-1
+0

More info, please refer to
Link: http://pb2.norway.sun.com/?template=show_pushes&branch=mysql-next-mr-innodb-pb2

How to repeat:
PB2 tests
[24 Aug 2010 23:22] 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/116697

3192 Marc Alff	2010-08-24
      Bug#55576 Two perfschema tests failed on mysql-next-mr-innodb PB2 tests
      
      Before this fix, some tests failed due to lack of instrumentation slots
      in the performance schema, because the default sizing was too low.
      
      Now that more code has been instrumented, the default sizing has to be adjusted
      to match the current instrumentation consumption.
      
      This change:
      - increases the number of rwlock classes from 20 to 30,
      - increases the number of rwlock and mutex instances to 1 million.
      Both are to account for the volume of data instrumented
      when the innodb storage engine is used (because of the innodb buffer pool).
      
      Adjusted the test output accordingly.
[27 Aug 2010 17:18] Christopher Powers
Approved.
[27 Aug 2010 21:03] Marc Alff
Pushed into:
- mysql-5.5-bugfixing
- mysql-trunk-bugfixing
- mysql-next-mr-bugfixing
[30 Aug 2010 8:30] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (version source revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (merge vers: 5.6.1-m4) (pib:21)
[30 Aug 2010 8:34] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (version source revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (pib:21)
[30 Aug 2010 8:36] Bugs System
Pushed into mysql-5.5 5.5.7-m3 (revid:alik@sun.com-20100830082727-5ac4czrxl61w9wle) (version source revid:alik@sun.com-20100830082727-5ac4czrxl61w9wle) (merge vers: 5.5.7-m3) (pib:21)
[30 Aug 2010 15:05] Paul Dubois
Noted in 5.5.7, 5.6.1 changelogs.

For Performance Schema, the default number of rwlock classes was 
increased to 30, and the default number of rwlock and mutex instances
was increased to 1 million. These changes were made to account for
the volume of data instrumented when the InnoDB storage engine is
used (because of the InnoDB buffer pool).
[10 Dec 2010 7:49] Anitha Gopi
Two tests are disabled on the trunk due to this bug. Please enable the tests if the bug is fixed. 

http://trollheim.norway.sun.com/archive/2653266.disabled_tests.html