Bug #77717 perfschema.no_threads : fails sporadically on daily-trunk
Submitted: 14 Jul 2015 11:23 Modified: 23 Nov 2015 17:04
Reporter: Viswanatham Gudipati Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[14 Jul 2015 11:23] Viswanatham Gudipati
Description:
This testcase has been failing sporadically on daily-trunk and trunk , the date of last failure was on 2014-07-24 15:57:44and again it was started failing after the following push , but we can not conclude that it was due to the following push. Because the failure symptoms are exactly the same .Most of the time it fails on Windows machine on Trunk and Daily-trunk

Push info :
Dependancies used:

commit 80318892e347b888fb46876ffc1e184f3e837181
Author: Jimmy Yang <jimmy.yang@oracle.com>
Date:   Fri Jul 10 15:23:45 2015 +0800

    Follow up fix for WL#8149 change, fix create_thd() issue and test mismatches

commit ca9e83e4e3c659006e3c39858ce8976849a55c6c
Author: Jimmy Yang <jimmy.yang@oracle.com>
Date:   Fri Jul 10 13:52:15 2015 +0800

    Merge WL#8149 related worklogs to mysql-trunk
    
        WL#8149  B-tree Index Support on non-materialized virtual columns
        WL#8114  Don't store virtual generated columns in database
        WL#8227  Support SEs to create index on virtual generated columns
        WL#8481  Callback for computation of virtual column index values
        from InnoDB purge threads
        All 4 worklogs are to support virtual column and virtual index on such
        columns

Failure hostory :
-----------------
daily-trunk:
-------------
http://pb2.no.oracle.com/?template=mysql_show_test_failure&test_failure_id=&test_output_id...

trunk history:
--------------
http://pb2.no.oracle.com/?template=mysql_show_test_failure&test_failure_id=&test_output_id...

failure log:
--------------
perfschema.no_threads                    w5 [ fail ]
        Test ended at 2015-07-13 19:25:43

CURRENT_TEST: perfschema.no_threads
'diff' is not recognized as an internal or external command,
operable program or batch file.
--- G:/ade/test/sb_1-15893271-1436805747.94/mysql-advanced-5.8.0-m17-winx64/mysql-test/suite/perfschema/r/no_threads.result	2015-07-13 18:03:28.000000000 +0300
+++ R:\var-normal-big\5\log\no_threads.reject	2015-07-13 20:25:42.554604200 +0300
@@ -29,16 +29,13 @@
 left(source, locate(":", source)) as short_source
 from performance_schema.events_waits_current;
 event_name	operation	short_source
-wait/synch/mutex/mysys/THR_LOCK_myisam	lock	mi_create.c:
 select event_name, operation,
 left(source, locate(":", source)) as short_source
 from performance_schema.events_waits_history;
 event_name	operation	short_source
-wait/synch/mutex/mysys/THR_LOCK_myisam	lock	mi_create.c:
 select event_name, operation,
 left(source, locate(":", source)) as short_source
 from performance_schema.events_waits_history_long;
 event_name	operation	short_source
-wait/synch/mutex/mysys/THR_LOCK_myisam	lock	mi_create.c:
 update performance_schema.setup_instruments set enabled='YES';
 drop table test.t1;

mysqltest: Result content mismatch

 - the logfile can be found in 'R:/var-normal-big/log/perfschema.no_threads/no_threads.log'

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

rpl.rpl_row_img_sanity 'row'             w8 [ pass ]  91653
i_main.plugin_auth_sha256_bug17675203    w1 [ pass ]   3391
rpl.rpl_row_inexist_tbl 'row'            w8 [ pass ]   1511
perfschema.no_threads                    w5 [ retry-fail ]
        Test ended at 2015-07-13 19:25:47

CURRENT_TEST: perfschema.no_threads 

How to repeat:
Run Command :
Daily-trunk:
mysql-test-run.pl  --force --timer --big-test --testcase-timeout=90 --parallel=8  --comment=normal-big 

Trunk :
mysql-test-run.pl  --timer --debug-server --force --parallel=8 --comment=n_mix-debug --vardir=R:/var-n_mix --mysqld=--binlog-format=mixed --experimental=collections/default.experimental --skip-test-list=collections/disabled-per-push.list --unit-tests-report
[23 Nov 2015 17:04] Paul DuBois
Fixed in 5.7.11. Changes for test suite. No changelog entry needed.
[18 Jun 2016 21:26] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0