[MDEV-8485] mysql-test - perfschema.func_mutex fails - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0.20
Fix Version/s: 10.0.23, 10.1.9
Component/s: OTHER
Labels:
- SUSE
- s390x
Environment:
SLES12 x86_64

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

Attachments

Issue Links

relates to

MDEV-5708 perfschema.func_file_io perfschema.func_mutex tests fail for architecture s390x

Closed

MDEV-8692 perfschema test failures on ARM (on Debian build system)

Closed

Activity

Ascending order - Click to sort in descending order

Nirbhay Choubey (Inactive) created issue - 2015-07-17 06:19

Elena Stepanova made changes - 2015-07-17 10:09

Field	Original Value	New Value
Fix Version/s		10.0 [ 16000 ]
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	This was observed just on s390. mariadb-10.0.20-18.1.s390x {noformat} 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 {noformat} https://bugzilla.suse.com/show_bug.cgi?id=937956
Labels	SUSE	SUSE s390x

Otto Kekäläinen made changes - 2015-08-28 10:10

Link

This issue relates to ~~MDEV-5708~~ [ ~~MDEV-5708~~ ]

Otto Kekäläinen made changes - 2015-08-28 12:04

Link

This issue relates to ~~MDEV-8692~~ [ ~~MDEV-8692~~ ]

Elena Stepanova made changes - 2016-01-14 02:02

Status

Open [ 1 ]

Confirmed [ 10101 ]

Elena Stepanova made changes - 2016-01-14 02:02

Component/s		OTHER [ 10125 ]
Component/s	Optimizer [ 10200 ]
Fix Version/s		10.1.9 [ 20301 ]
Fix Version/s		10.0.23 [ 20401 ]
Fix Version/s	10.0 [ 16000 ]
Assignee		Alexander Barkov [ bar ]
Resolution		Fixed [ 1 ]
Status	Confirmed [ 10101 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:41

Workflow

MariaDB v3 [ 70660 ]

MariaDB v4 [ 149386 ]

People

Assignee:: Alexander Barkov

Reporter:: Nirbhay Choubey (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2015-07-17 06:19

Updated:: 2016-01-14 02:02

Resolved:: 2016-01-14 02:02

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server