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