Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5708

perfschema.func_file_io perfschema.func_mutex tests fail for architecture s390x

        Details

          Description

          As seen in the log https://buildd.debian.org/status/fetch.php?pkg=mariadb-5.5&arch=s390x&ver=5.5.35-1&stamp=1392725213 MariaDB for s390x seem to build OK but there are some tests that fail:

          Completed: Failed 3/2678 tests, 99.89% were successful.
          Failing test(s): main.gis-precise perfschema.func_file_io perfschema.func_mutex

          Do these actually indicate a real issue in the build? Could the root cause or the tests themselves be fixed?

          I would rather not disable build tests in Debian packages as they are a good tool to spot possible errors in built binaries.

            Gliffy Diagrams

              Attachments

                Issue Links

                is duplicated by

                Bug - A problem which impairs or prevents the functions of the product. MDEV-4153 Test case gis-precise fails on s390(x) and ppc(64)

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Closed
                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8484 mysql-test - perfschema.func_file_io

                • Major - Major loss of function.
                • Open

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8485 mysql-test - perfschema.func_mutex fails

                • Major - Major loss of function.
                • Open

                  Activity

                  Ascending order - Click to sort in descending order
                  8 older comments
                  Hide
                  Permalink
                  otto Otto Kekäläinen added a comment -

                  Any progress on this one? This issue has been open since February. Can somebody take a look at this, please? Rasmus Johansson Kristian Nielsen

                  Show
                  otto Otto Kekäläinen added a comment - Any progress on this one? This issue has been open since February. Can somebody take a look at this, please? Rasmus Johansson Kristian Nielsen
                  Hide
                  Permalink
                  otto Otto Kekäläinen added a comment -

                  In latest builds the failing tests are mostly about connect: Failing test(s): connect.part_file connect.part_table connect.alter connect.bin connect.dbf connect.index connect.mrr connect.updelx connect.updelx2 perfschema.func_file_io

                  See https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.0&arch=s390x&ver=10.0.16-1&stamp=1422955799

                  Show
                  otto Otto Kekäläinen added a comment - In latest builds the failing tests are mostly about connect: Failing test(s): connect.part_file connect.part_table connect.alter connect.bin connect.dbf connect.index connect.mrr connect.updelx connect.updelx2 perfschema.func_file_io See https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.0&arch=s390x&ver=10.0.16-1&stamp=1422955799
                  Hide
                  Permalink
                  holyfoot Alexey Botchkov added a comment -

                  The gis-precise test is now fixed.

                  Show
                  holyfoot Alexey Botchkov added a comment - The gis-precise test is now fixed.
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Alexey Botchkov,

                  Re: your question on IRC: naturally, if you can fix other tests, please do so. If you can't, please reassign to whoever it fits best.

                  Show
                  elenst Elena Stepanova added a comment - Alexey Botchkov , Re: your question on IRC: naturally, if you can fix other tests, please do so. If you can't, please reassign to whoever it fits best.
                  Hide
                  Permalink
                  otto Otto Kekäläinen added a comment -

                  Status from latest build at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.0&arch=s390x&ver=10.0.21-2&stamp=1440716829

                  Failing test(s): perfschema.func_file_io perfschema.func_mutex perfschema.global_read_lock perfschema.setup_objects

perfschema.func_file_io                  [ fail ]
        Test ended at 2015-08-27 23:02:08

CURRENT_TEST: perfschema.func_file_io
--- /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/func_file_io.result	2015-08-05 18:11:30.000000000 +0000
+++ /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/func_file_io.reject	2015-08-27 23:02:08.473394440 +0000
@@ -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 '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.func_file_io/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.func_file_io/'
perfschema.func_mutex                    [ fail ]
        Test ended at 2015-08-27 23:02:09

CURRENT_TEST: perfschema.func_mutex
--- /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/func_mutex.result	2015-08-05 18:11:30.000000000 +0000
+++ /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/func_mutex.reject	2015-08-27 23:02:09.377394440 +0000
@@ -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 '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.func_mutex/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.func_mutex/'
perfschema.global_read_lock              [ fail ]
        Test ended at 2015-08-27 23:02:10

CURRENT_TEST: perfschema.global_read_lock
--- /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/global_read_lock.result	2015-08-05 18:11:30.000000000 +0000
+++ /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/global_read_lock.reject	2015-08-27 23:02:10.485394440 +0000
@@ -26,7 +26,7 @@
 from performance_schema.events_waits_current
 where event_name like "wait/synch/cond/sql/MDL_context::COND_wait_status";
 event_name	short_source	timer_end	timer_wait	operation
-wait/synch/cond/sql/MDL_context::COND_wait_status	mdl.cc:	SET	SET	timed_wait
+wait/synch/cond/sql/MDL_context::COND_wait_status	mdl.cc:	NULL	NULL	timed_wait
 unlock tables;
 update performance_schema.setup_instruments set enabled='NO';
 update performance_schema.setup_instruments set enabled='YES';

mysqltest: Result length mismatch

 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.global_read_lock/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.global_read_lock/'
perfschema.indexed_table_io              [ pass ]    120
perfschema.information_schema            [ pass ]     25
perfschema.memory_table_io               [ pass ]     88
perfschema.merge_table_io                [ pass ]     89
perfschema.mks_timer-6258                [ pass ]     11
perfschema.multi_table_io                [ pass ]     92
perfschema.myisam_table_io               [ pass ]     88
perfschema.nesting                       [ pass ]    107
perfschema.ortho_iter                    [ pass ]    609
perfschema.privilege                     [ pass ]    213
perfschema.privilege_table_io            [ pass ]     96
perfschema.read_only                     [ pass ]    254
perfschema.schema                        [ pass ]     20
perfschema.server_init                   [ pass ]     31
perfschema.setup_actors                  [ pass ]    119
perfschema.setup_objects                 [ fail ]
        Test ended at 2015-08-27 23:02:16

CURRENT_TEST: perfschema.setup_objects
--- /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/setup_objects.result	2015-08-05 18:11:30.000000000 +0000
+++ /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/setup_objects.reject	2015-08-27 23:02:16.093390440 +0000
@@ -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 '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.setup_objects/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.setup_objects/'
                  Show
                  otto Otto Kekäläinen added a comment - Status from latest build at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.0&arch=s390x&ver=10.0.21-2&stamp=1440716829 Failing test(s): perfschema.func_file_io perfschema.func_mutex perfschema.global_read_lock perfschema.setup_objects perfschema.func_file_io [ fail ] Test ended at 2015-08-27 23:02:08 CURRENT_TEST: perfschema.func_file_io --- /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/func_file_io.result 2015-08-05 18:11:30.000000000 +0000 +++ /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/func_file_io.reject 2015-08-27 23:02:08.473394440 +0000 @@ -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 '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.func_file_io/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.func_file_io/' perfschema.func_mutex [ fail ] Test ended at 2015-08-27 23:02:09 CURRENT_TEST: perfschema.func_mutex --- /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/func_mutex.result 2015-08-05 18:11:30.000000000 +0000 +++ /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/func_mutex.reject 2015-08-27 23:02:09.377394440 +0000 @@ -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 '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.func_mutex/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.func_mutex/' perfschema.global_read_lock [ fail ] Test ended at 2015-08-27 23:02:10 CURRENT_TEST: perfschema.global_read_lock --- /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/global_read_lock.result 2015-08-05 18:11:30.000000000 +0000 +++ /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/global_read_lock.reject 2015-08-27 23:02:10.485394440 +0000 @@ -26,7 +26,7 @@ from performance_schema.events_waits_current where event_name like "wait/synch/cond/sql/MDL_context::COND_wait_status"; event_name short_source timer_end timer_wait operation -wait/synch/cond/sql/MDL_context::COND_wait_status mdl.cc: SET SET timed_wait +wait/synch/cond/sql/MDL_context::COND_wait_status mdl.cc: NULL NULL timed_wait unlock tables; update performance_schema.setup_instruments set enabled='NO'; update performance_schema.setup_instruments set enabled='YES'; mysqltest: Result length mismatch - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.global_read_lock/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.global_read_lock/' perfschema.indexed_table_io [ pass ] 120 perfschema.information_schema [ pass ] 25 perfschema.memory_table_io [ pass ] 88 perfschema.merge_table_io [ pass ] 89 perfschema.mks_timer-6258 [ pass ] 11 perfschema.multi_table_io [ pass ] 92 perfschema.myisam_table_io [ pass ] 88 perfschema.nesting [ pass ] 107 perfschema.ortho_iter [ pass ] 609 perfschema.privilege [ pass ] 213 perfschema.privilege_table_io [ pass ] 96 perfschema.read_only [ pass ] 254 perfschema.schema [ pass ] 20 perfschema.server_init [ pass ] 31 perfschema.setup_actors [ pass ] 119 perfschema.setup_objects [ fail ] Test ended at 2015-08-27 23:02:16 CURRENT_TEST: perfschema.setup_objects --- /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/setup_objects.result 2015-08-05 18:11:30.000000000 +0000 +++ /«PKGBUILDDIR»/mysql-test/suite/perfschema/r/setup_objects.reject 2015-08-27 23:02:16.093390440 +0000 @@ -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 '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.setup_objects/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/perfschema.setup_objects/'

                    People

                    • Assignee:
                      holyfoot Alexey Botchkov
                      Reporter:
                      otto Otto Kekäläinen
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      5 Start watching this issue

                      Dates

                      • Created:
                        Updated: