[MDEV-8485] mysql-test - perfschema.func_mutex fails Created: 2015-07-17  Updated: 2016-01-14  Resolved: 2016-01-14

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.0.20
Fix Version/s: 10.0.23, 10.1.9

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: SUSE, s390x
Environment:

SLES12 x86_64


Issue Links:
Relates
relates to MDEV-5708 perfschema.func_file_io perfschema.fu... Closed
relates to MDEV-8692 perfschema test failures on ARM (on D... Closed

 Description   

This was observed just on s390.

mariadb-10.0.20-18.1.s390x

s390vsl048:/usr/share/mysql-test # ./mysql-test-run.pl perfschema.func_mutex 
Logging: ./mysql-test-run.pl  perfschema.func_mutex
vardir: /usr/share/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/usr/share/mysql-test/var'...
Checking supported features...
MariaDB Version 10.0.20-MariaDB
 - SSL connections supported
Collecting tests...
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
perfschema.func_mutex                    [ fail ]
        Test ended at 2015-07-14 10:24:13
 
CURRENT_TEST: perfschema.func_mutex
--- /usr/share/mysql-test/suite/perfschema/r/func_mutex.result	2015-06-17 16:54:12.000000000 +0200
+++ /usr/share/mysql-test/suite/perfschema/r/func_mutex.reject	2015-07-14 10:24:13.236244479 +0200
@@ -40,7 +40,7 @@
 WHERE (EVENT_NAME = 'wait/synch/mutex/sql/TABLE_SHARE::tdc.LOCK_table_share'));
 SELECT IF((@after_count - @before_count) > 0, 'Success', 'Failure') test_fm1_timed;
 test_fm1_timed
-Success
+Failure
 UPDATE performance_schema.setup_instruments SET enabled = 'NO'
 WHERE NAME = 'wait/synch/mutex/sql/TABLE_SHARE::tdc.LOCK_table_share';
 TRUNCATE TABLE performance_schema.events_waits_history_long;
@@ -83,7 +83,7 @@
 WHERE (EVENT_NAME = 'wait/synch/rwlock/sql/LOCK_system_variables_hash'));
 SELECT IF((@after_count - @before_count) > 0, 'Success', 'Failure') test_fm1_rw_timed;
 test_fm1_rw_timed
-Success
+Failure
 UPDATE performance_schema.setup_instruments SET enabled = 'NO'
 WHERE NAME = 'wait/synch/rwlock/sql/LOCK_system_variables_hash';
 TRUNCATE TABLE performance_schema.events_waits_history_long;
 
mysqltest: Result content mismatch
 
 - saving '/usr/share/mysql-test/var/log/perfschema.func_mutex/' to '/usr/share/mysql-test/var/log/perfschema.func_mutex/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 5 seconds executing testcases
 
Failure: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): perfschema.func_mutex
 
The log files in var/log may give you some hint of what went wrong.
 
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
 
mysql-test-run: *** ERROR: there were failing test cases

https://bugzilla.suse.com/show_bug.cgi?id=937956



 Comments   
Comment by Elena Stepanova [ 2016-01-14 ]

Fixed by the patch MDEV-8692.

To reproduce on affected platforms before the crash, two tests needed to be run together:

perl ./mtr perfschema.privilege perfschema.func_mutex --noreorder

Generated at Thu Feb 08 07:27:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.