Bug #57915 perfschema.threads_mysql fails sporadically after WL#4674
Submitted: 2 Nov 2010 8:26 Modified: 11 Dec 2010 17:55
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.6.x (Erica) OS:Any
Assigned to: Marc ALFF CPU Architecture:Any
Tags: pb2, sporadic, test failure

[2 Nov 2010 8:26] Alexander Nozdrin
Description:
perfschema.threads_mysql [ fail ]
        Test ended at 2010-11-01 15:03:43

CURRENT_TEST: perfschema.threads_mysql
--- /export/home/pb2/test/sb_1-2474992-1288615960.83/mysql-5.6.99-m5-freebsd7.0-i386-test/mysql-test/suite/perfschema/r/threads_mysql.result	2010-11-01 14:19:09.000000000 +0300
+++ /export/home/pb2/test/sb_1-2474992-1288615960.83/mysql-5.6.99-m5-freebsd7.0-i386-test/mysql-test/suite/perfschema/r/threads_mysql.reject	2010-11-01 17:03:42.000000000 +0300
@@ -7,6 +7,16 @@
 FROM performance_schema.THREADS
 WHERE name LIKE 'thread/sql%'
 ORDER BY name;
+name	thread/sql/event_scheduler
+type	FOREGROUND
+processlist_user	NULL
+processlist_host	NULL
+processlist_db	NULL
+processlist_command	Connect
+processlist_info	NULL
+unified_parent_thread_id	unified parent_thread_id
+role	NULL
+instrumented	YES
 name	thread/sql/main
 type	BACKGROUND
 processlist_user	NULL

mysqltest: Result content mismatch

 - saving '/export/home/pb2/test/sb_1-2474992-1288615960.83/mysql-5.6.99-m5-freebsd7.0-i386-test/mysql-test/var-ps_row/log/perfschema.threads_mysql/' to '/export/home/pb2/test/sb_1-2474992-1288615960.83/mysql-5.6.99-m5-freebsd7.0-i386-test/mysql-test/var-ps_row/log/perfschema.threads_mysql/'

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

perfschema.threads_mysql                 [ retry-pass ]   4095

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

perfschema.threads_mysql                 [ retry-pass ]   6710

How to repeat:
http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=&test_output_i...
[11 Nov 2010 14:36] 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/123627

3381 Marc Alff	2010-11-11
      Bug#57915 perfschema.threads_mysql fails sporadically after WL#4674
      
      Fixed the new performance_schema.threads_mysql test case to be more robust,
      to avoid spurious failures.
[15 Nov 2010 2:07] Christopher Powers
Patch approved.
[16 Nov 2010 5:29] Marc ALFF
Pushed into:
- mysql-trunk-bugfixing
[5 Dec 2010 12:40] Bugs System
Pushed into mysql-trunk 5.6.1 (revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (version source revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (merge vers: 5.6.1) (pib:23)
[11 Dec 2010 17:55] Paul DuBois
Changes to test suite. No changelog entry needed.