[MDEV-8483] mysql-test - perfschema.setup_objects 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-8692 perfschema test failures on ARM (on D... Closed

 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



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

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