Bug #59150 perfschema.setup_objects fails sporadically in release build
Submitted: 24 Dec 2010 7:54 Modified: 14 May 2011 15:49
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.6.1 OS:Any
Assigned to: Marc ALFF CPU Architecture:Any
Tags: pb2, test failure

[24 Dec 2010 7:54] Alexander Nozdrin
Description:
perfschema.setup_objects w27 [ fail ]
        Test ended at 2010-12-23 18:17:18

CURRENT_TEST: perfschema.setup_objects
--- /export/home/pb2/test/sb_0-2709941-1293123302.09/mysql/reloc/mysql/mysql-test/suite/perfschema/r/setup_objects.result	Thu Dec 23 18:24:55 2010
+++ /export/home/pb2/test/sb_0-2709941-1293123302.09/mysql/reloc/mysql/mysql-test/suite/perfschema/r/setup_objects.reject	Thu Dec 23 20:17:18 2010
@@ -68,12 +68,9 @@
 order by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA;
 OBJECT_TYPE	OBJECT_NAME	OBJECT_SCHEMA
 TABLE	t1	db1
-TABLE	t1	db2
 TABLE	t2	db1
-TABLE	t2	db2
 TABLE	t3	db1
 TABLE	t4	db1
-TABLE	t5	db1
 select distinct OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA 
 from performance_schema.events_waits_history_long
 where OBJECT_SCHEMA like "db%" and TIMER_END is not NULL
@@ -81,10 +78,8 @@
 order by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA;
 OBJECT_TYPE	OBJECT_NAME	OBJECT_SCHEMA
 TABLE	t1	db1
-TABLE	t1	db2
 TABLE	t3	db1
 TABLE	t4	db1
-TABLE	t5	db1
 update performance_schema.setup_objects
 set timed='YES' where OBJECT_SCHEMA = '%';
 create table db3.t3(a int);

mysqltest: Result content mismatch

 - saving '/tmp/mtr-13286/var-normal/27/log/perfschema.setup_objects/' to '/tmp/mtr-13286/var-normal/log/perfschema.setup_objects/'

Retrying test perfschema.setup_objects, attempt(2/3)...

perfschema.setup_objects                 w27 [ retry-pass ]    830

Retrying test perfschema.setup_objects, attempt(3/3)...

perfschema.setup_objects                 w27 [ retry-pass ]    956

How to repeat:
Tree: http://pb2.norway.sun.com/?template=show_pushes&branch=mysql-5.6.1-m5-release

Log: http://pb2.norway.sun.com/?action=archive_download&archive_id=2710600&pretty=please

Xref: http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=&test_output_i...

According to Xref, this failure is new and specific to relelase builds only.
[14 May 2011 15:49] Paul DuBois
Noted in 5.6.3 changelog.

Some tables were not instrumented by the Performance Schema even
though they were listed in the setup_objects table. 

CHANGESET - http://lists.mysql.com/commits/137332