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

Tests fail massively in buildbot on rhel8-ppc64le with floating point differences

    XMLWordPrintable

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-rhel8-ppc64le/builds/120/steps/mtr/logs/stdio

      10.3 f80e02e043103ab4e6ca12d9efffec6eb9aa3b74

      main.ps                                  w4 [ fail ]
              Test ended at 2019-09-07 12:37:15
       
      CURRENT_TEST: main.ps
      /usr/bin/mysqltest: Error on delete of '/dev/shm/var/4/tmp/f1.txt' (Errcode: 2 "No such file or directory")
      --- /usr/share/mysql-test/main/ps.result	2019-09-07 09:08:23.000000000 +0000
      +++ /dev/shm/var/4/log/ps.reject	2019-09-07 12:37:15.313985734 +0000
      @@ -3509,7 +3509,7 @@
       ) ENGINE=MyISAM DEFAULT CHARSET=latin1
       SELECT @a, @a - 123.4567 < 0.00001;
       @a	@a - 123.4567 < 0.00001
      -123.45670318603516	1
      +123.45669555664062	1
       DROP TEMPORARY TABLE tmp1;
       DROP PROCEDURE p1;
       
       
      mysqltest: Result content mismatch
      

      main.select_pkeycache                    w2 [ fail ]
              Test ended at 2019-09-07 12:45:11
       
      CURRENT_TEST: main.select_pkeycache
      --- /usr/share/mysql-test/main/select_pkeycache.result	2019-09-07 09:08:23.000000000 +0000
      +++ /dev/shm/var/2/log/select_pkeycache.reject	2019-09-07 12:45:11.110488630 +0000
      @@ -2804,7 +2804,7 @@
       0.6158	1.3762
       select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;
       max(key1)
      -0.3845
      +0.6158
       select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;
       min(key1)
       0.3845
       
      mysqltest: Result content mismatch
      

      main.select                              w2 [ fail ]
              Test ended at 2019-09-07 12:49:22
       
      CURRENT_TEST: main.select
      --- /usr/share/mysql-test/main/select.result	2019-09-07 09:08:23.000000000 +0000
      +++ /dev/shm/var/2/log/select.reject	2019-09-07 12:49:21.943951635 +0000
      @@ -2804,7 +2804,7 @@
       0.6158	1.3762
       select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;
       max(key1)
      -0.3845
      +0.6158
       select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;
       min(key1)
       0.3845
       
      mysqltest: Result content mismatch
      

      main.select_jcl6                         w2 [ fail ]
              Test ended at 2019-09-07 12:49:27
       
      CURRENT_TEST: main.select_jcl6
      --- /usr/share/mysql-test/main/select_jcl6.result	2019-09-07 09:08:23.000000000 +0000
      +++ /dev/shm/var/2/log/select_jcl6.reject	2019-09-07 12:49:26.854019423 +0000
      @@ -2815,7 +2815,7 @@
       0.6158	1.3762
       select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;
       max(key1)
      -0.3845
      +0.6158
       select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;
       min(key1)
       0.3845
       
      mysqltest: Result content mismatch
      

      main.sp w2 [ fail ]
      Test ended at 2019-09-07 12:49:41

      CURRENT_TEST: main.sp
      /usr/bin/mysqltest: Error on delete of '/dev/shm/var/2/tmp//t1.frm' (Errcode: 2 "No such file or directory")
      /usr/bin/mysqltest: Error on delete of '/dev/shm/var/2/tmp//t1.MYD' (Errcode: 2 "No such file or directory")
      — /usr/share/mysql-test/main/sp.result 2019-09-07 09:08:23.000000000 +0000
      +++ /dev/shm/var/2/log/sp.reject 2019-09-07 12:49:41.434220717 +0000
      @@ -5996,9 +5996,9 @@
      INSERT INTO t3 VALUES (1, 3.4), (1, 2), (1, 0.9), (2, 8), (2, 7)|
      SELECT SUM(f2), bug25373(f1) FROM t3 GROUP BY bug25373(f1) WITH ROLLUP|
      SUM(f2) bug25373(f1)
      -6.300000071525574 1
      +6.299999833106995 1
      15 2
      -21.300000071525574 NULL
      +21.299999833106995 NULL
      DROP FUNCTION bug25373|
      DROP TABLE t3|
      DROP DATABASE IF EXISTS mysqltest1|

      mysqltest: Result content mismatch

      main.derived_cond_pushdown               w1 [ fail ]
              Test ended at 2019-09-07 12:49:54
       
      CURRENT_TEST: main.derived_cond_pushdown
      --- /usr/share/mysql-test/main/derived_cond_pushdown.result	2019-09-07 09:08:23.000000000 +0000
      +++ /dev/shm/var/1/log/derived_cond_pushdown.reject	2019-09-07 12:49:54.364399231 +0000
      @@ -7894,7 +7894,7 @@
                   "access_type": "ALL",
                   "rows": 3,
                   "filtered": 100,
      -            "attached_condition": "t1.i = 2.7100000381469727"
      +            "attached_condition": "t1.i = 2.7099997997283936"
                 }
               }
             }
       
      mysqltest: Result content mismatch
      

      main.type_float w2 [ fail ]
      Test ended at 2019-09-07 12:50:39

      CURRENT_TEST: main.type_float
      — /usr/share/mysql-test/main/type_float.result 2019-09-07 09:08:24.000000000 +0000
      +++ /dev/shm/var/2/log/type_float.reject 2019-09-07 12:50:39.495022304 +0000
      @@ -385,12 +385,12 @@
      Warning 1264 Out of range value for column 'f1' at row 2
      select f1 + 0e0 from t1;
      f1 + 0e0
      -1.0000000150474662e29
      --1.0000000150474662e29
      -1.0000000150474662e30
      --1.0000000150474662e30
      -1.0000000150474662e30
      --1.0000000150474662e30
      +9.999999206001366e28
      +-9.999999206001366e28
      +9.999999394896025e29
      +-9.999999394896025e29
      +9.999999394896025e29
      +-9.999999394896025e29
      drop table t1;
      create table t1 (c char(6));
      insert into t1 values (2e6),(2e-5);
      @@ -818,20 +818,20 @@
      INSERT INTO t1 VALUES (1.1);
      SELECT f FROM t1 UNION SELECT 1;
      f
      -1.100000023841858
      +1.0999999046325684
      1
      SELECT 1 UNION SELECT f FROM t1;
      1
      1
      -1.100000023841858
      +1.0999999046325684
      SELECT f FROM t1 UNION SELECT 2147483647;
      f
      -1.100000023841858
      +1.0999999046325684
      2147483647
      SELECT 2147483647 UNION SELECT f FROM t1;
      2147483647
      2147483647
      -1.100000023841858
      +1.0999999046325684
      SELECT CASE WHEN 0 THEN (SELECT f FROM t1) ELSE 2147483647 END AS c1,
      CASE WHEN 1 THEN 2147483647 ELSE (SELECT f FROM t1) END AS c2;
      c1 c2

      mysqltest: Result length mismatch

       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated: