[MDEV-8484] mysql-test - perfschema.func_file_io Created: 2015-07-17  Updated: 2019-07-23  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_file_io 
Logging: ./mysql-test-run.pl  perfschema.func_file_io
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_file_io                  [ fail ]
        Test ended at 2015-07-14 10:12:32
 
CURRENT_TEST: perfschema.func_file_io
--- /usr/share/mysql-test/suite/perfschema/r/func_file_io.result	2015-06-17 16:54:12.000000000 +0200
+++ /usr/share/mysql-test/suite/perfschema/r/func_file_io.reject	2015-07-14 10:12:32.706244479 +0200
@@ -21,10 +21,10 @@
 AND (OBJECT_NAME LIKE '%t1.MYD'));
 SELECT (@before_count >= 0) as have_before_count;
 have_before_count
-1
+NULL
 SELECT IF(@before_count > 0, 'Success', 'Failure') has_instrumentation;
 has_instrumentation
-Success
+Failure
 SELECT * FROM t1 WHERE id < 4;
 id	b
 1	initial value
@@ -36,10 +36,10 @@
 AND (OBJECT_NAME LIKE '%t1.MYD') AND (1 = 1));
 SELECT (@after_count >= 0) as have_after_count;
 have_after_count
-1
+NULL
 SELECT IF((@after_count - @before_count) > 0, 'Success', 'Failure') test_ff1_timed;
 test_ff1_timed
-Success
+Failure
 UPDATE performance_schema.setup_instruments SET enabled='NO';
 SET @before_count = (SELECT SUM(TIMER_WAIT)
 FROM performance_schema.events_waits_history_long
@@ -47,7 +47,7 @@
 AND (OBJECT_NAME LIKE '%t1.MYD') AND (2 = 2));
 SELECT (@before_count >= 0) as have_before_count;
 have_before_count
-1
+NULL
 SELECT * FROM t1 WHERE id < 6;
 id	b
 1	initial value
@@ -61,7 +61,7 @@
 AND (OBJECT_NAME LIKE '%t1.MYD') AND (3 = 3));
 SELECT (@after_count >= 0) as have_after_count;
 have_after_count
-1
+NULL
 SELECT IF((COALESCE(@after_count, 0) - COALESCE(@before_count, 0)) = 0, 'Success', 'Failure') test_ff2_timed;
 test_ff2_timed
 Success
 
mysqltest: Result length mismatch
 
 - saving '/usr/share/mysql-test/var/log/perfschema.func_file_io/' to '/usr/share/mysql-test/var/log/perfschema.func_file_io/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 10 seconds executing testcases
 
Failure: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): perfschema.func_file_io
 
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=937955



 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_file_io --noreorder

Comment by Oleksandr Byelkin [ 2019-07-18 ]

Actually buildbot fails on 5.5 almost in the same way

Comment by Elena Stepanova [ 2019-07-23 ]

sanja, there is still MDEV-5708 open for the failure that happens with 5.5 on kvm-rpm-centos74-aarch64

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