[MDEV-8483] mysql-test - perfschema.setup_objects 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 issue was observed just on s390.

mariadb-10.0.20-18.1.s390x

s390vsl048:/usr/share/mysql-test # ./mysql-test-run.pl perfschema.setup_objects

Logging: ./mysql-test-run.pl  perfschema.setup_objects

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.setup_objects                 [ fail ]

        Test ended at 2015-07-14 10:49:41

CURRENT_TEST: perfschema.setup_objects

--- /usr/share/mysql-test/suite/perfschema/r/setup_objects.result	2015-06-17 16:54:12.000000000 +0200

+++ /usr/share/mysql-test/suite/perfschema/r/setup_objects.reject	2015-07-14 10:49:41.756244479 +0200

@@ -181,12 +181,6 @@

 group by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA

 order by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA;

 OBJECT_TYPE	OBJECT_NAME	OBJECT_SCHEMA

-TABLE	t1	db1

-TABLE	t1	db2

-TABLE	t1	db3

-TABLE	t3	db1

-TABLE	t4	db1

-TABLE	t5	db1

 update performance_schema.setup_objects

 set timed='YES' where OBJECT_SCHEMA = '%';

 create table db5.t3(a int);

mysqltest: Result length mismatch

 - saving '/usr/share/mysql-test/var/log/perfschema.setup_objects/' to '/usr/share/mysql-test/var/log/perfschema.setup_objects/'

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 0.000 of 4 seconds executing testcases

Failure: Failed 1/1 tests, 0.00% were successful.

Failing test(s): perfschema.setup_objects

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=937957

Attachments

Issue Links

relates to

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:13

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

Field	Original Value	New Value
Fix Version/s		10.0 [ 16000 ]
Description	This issue was observed just on s390. mariadb-10.0.20-18.1.s390x s390vsl048:/usr/share/mysql-test # ./mysql-test-run.pl perfschema.setup_objects Logging: ./mysql-test-run.pl perfschema.setup_objects 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.setup_objects [ fail ] Test ended at 2015-07-14 10:49:41 CURRENT_TEST: perfschema.setup_objects --- /usr/share/mysql-test/suite/perfschema/r/setup_objects.result 2015-06-17 16:54:12.000000000 +0200 +++ /usr/share/mysql-test/suite/perfschema/r/setup_objects.reject 2015-07-14 10:49:41.756244479 +0200 @@ -181,12 +181,6 @@ group by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA order by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA; OBJECT_TYPE OBJECT_NAME OBJECT_SCHEMA -TABLE t1 db1 -TABLE t1 db2 -TABLE t1 db3 -TABLE t3 db1 -TABLE t4 db1 -TABLE t5 db1 update performance_schema.setup_objects set timed='YES' where OBJECT_SCHEMA = '%'; create table db5.t3(a int); mysqltest: Result length mismatch - saving '/usr/share/mysql-test/var/log/perfschema.setup_objects/' to '/usr/share/mysql-test/var/log/perfschema.setup_objects/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 4 seconds executing testcases Failure: Failed 1/1 tests, 0.00% were successful. Failing test(s): perfschema.setup_objects 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=937957	This issue was observed just on s390. mariadb-10.0.20-18.1.s390x {noformat} s390vsl048:/usr/share/mysql-test # ./mysql-test-run.pl perfschema.setup_objects Logging: ./mysql-test-run.pl perfschema.setup_objects 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.setup_objects [ fail ] Test ended at 2015-07-14 10:49:41 CURRENT_TEST: perfschema.setup_objects --- /usr/share/mysql-test/suite/perfschema/r/setup_objects.result 2015-06-17 16:54:12.000000000 +0200 +++ /usr/share/mysql-test/suite/perfschema/r/setup_objects.reject 2015-07-14 10:49:41.756244479 +0200 @@ -181,12 +181,6 @@ group by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA order by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA; OBJECT_TYPE OBJECT_NAME OBJECT_SCHEMA -TABLE t1 db1 -TABLE t1 db2 -TABLE t1 db3 -TABLE t3 db1 -TABLE t4 db1 -TABLE t5 db1 update performance_schema.setup_objects set timed='YES' where OBJECT_SCHEMA = '%'; create table db5.t3(a int); mysqltest: Result length mismatch - saving '/usr/share/mysql-test/var/log/perfschema.setup_objects/' to '/usr/share/mysql-test/var/log/perfschema.setup_objects/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 4 seconds executing testcases Failure: Failed 1/1 tests, 0.00% were successful. Failing test(s): perfschema.setup_objects 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=937957
Labels	SUSE	SUSE s390x

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

Link

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

Elena Stepanova added a comment - 2016-01-14 01:56 - edited

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.setup_objects --noreorder

Elena Stepanova added a comment - 2016-01-14 01:56 - edited 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.setup_objects --noreorder

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

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	Open [ 1 ]	Closed [ 6 ]

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

Workflow

MariaDB v3 [ 70658 ]

MariaDB v4 [ 149384 ]

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:13

Updated:: 2016-01-14 02:01

Resolved:: 2016-01-14 01:56

Git Integration

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

MariaDB Server