[#MDEV-28694] rocksdb.col_opt* and rocksdb.type_float fail deterministically on kvm-rpm-rhel8-ppc64le in buildbot

10.6 57e66dc7
rocksdb.col_opt_not_null 'write_committed' w3 [ fail ]
Test ended at 2022-05-25 08:42:46

CURRENT_TEST: rocksdb.col_opt_not_null
--- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/col_opt_not_null.result 2022-05-24 20:29:08.000000000 +0000
+++ /dev/shm/var/3/log/col_opt_not_null.reject 2022-05-25 08:42:46.385003815 +0000
@@ -1550,7 +1550,7 @@
d53 1234566789123456800
d53_10 100000000000000000.0000000000
f0 12345.1
-f20_3 56789.988
+f20_3 56789.984
f23_0 123457000
r1_1 0.9
INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10,pk) VALUES (0,0,0,0,0,0,0,0,0,0,2);
@@ -1593,7 +1593,7 @@
f0 12345.1
f0 1e38
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f23_0 0
f23_0 123457000
@@ -1633,7 +1633,7 @@
f0 1e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f23_0 -1000
f23_0 0
@@ -1725,7 +1725,7 @@
f0 3.40282e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f20_3 99999998430674940.000
f23_0 -1000
@@ -1807,7 +1807,7 @@
f0 3.40282e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f20_3 99999998430674940.000
f20_3 99999998430674940.000

mysqltest: Result content mismatch

rocksdb.col_opt_null 'write_committed' w3 [ fail ]
Test ended at 2022-05-25 08:42:49

CURRENT_TEST: rocksdb.col_opt_null
--- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/col_opt_null.result 2022-05-24 20:29:08.000000000 +0000
+++ /dev/shm/var/3/log/col_opt_null.reject 2022-05-25 08:42:48.795043932 +0000
@@ -1337,7 +1337,7 @@
d53 1234566789123456800
d53_10 100000000000000000.0000000000
f0 12345.1
-f20_3 56789.988
+f20_3 56789.984
f23_0 123457000
r1_1 0.9
INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10,pk) VALUES (0,0,0,0,0,0,0,0,0,0,2);
@@ -1380,7 +1380,7 @@
f0 12345.1
f0 1e38
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f23_0 0
f23_0 123457000
@@ -1420,7 +1420,7 @@
f0 1e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f23_0 -1000
f23_0 0
@@ -1512,7 +1512,7 @@
f0 3.40282e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f20_3 99999998430674940.000
f23_0 -1000
@@ -1594,7 +1594,7 @@
f0 3.40282e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f20_3 99999998430674940.000
f20_3 99999998430674940.000

mysqltest: Result content mismatch

rocksdb.type_float 'write_committed' w1 [ fail ]
Test ended at 2022-05-25 08:43:13

CURRENT_TEST: rocksdb.type_float
--- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/type_float.result 2022-05-24 20:29:08.000000000 +0000
+++ /dev/shm/var/1/log/type_float.reject 2022-05-25 08:43:13.245449747 +0000
@@ -34,7 +34,7 @@
d53 1234566789123456800
d53_10 100000000000000000.0000000000
f0 12345.1
-f20_3 56789.988
+f20_3 56789.984
f23_0 123457000
r1_1 0.9
INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10,pk) VALUES (0,0,0,0,0,0,0,0,0,0,2);
@@ -77,7 +77,7 @@
f0 12345.1
f0 1e38
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f23_0 0
f23_0 123457000
@@ -117,7 +117,7 @@
f0 1e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f23_0 -1000
f23_0 0
@@ -209,7 +209,7 @@
f0 3.40282e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f20_3 99999998430674940.000
f23_0 -1000
@@ -291,7 +291,7 @@
f0 3.40282e38
f20_3 -99999998430674940.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f20_3 99999998430674940.000
f20_3 99999998430674940.000

mysqltest: Result content mismatch

rocksdb.col_opt_unsigned 'write_committed' w2 [ fail ]
Test ended at 2022-05-25 08:44:09

CURRENT_TEST: rocksdb.col_opt_unsigned
--- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/col_opt_unsigned.result 2022-05-24 20:29:08.000000000 +0000
+++ /dev/shm/var/2/log/col_opt_unsigned.reject 2022-05-25 08:44:09.766382250 +0000
@@ -213,7 +213,7 @@
d53 1234566789123456800
d53_10 100000000000000000.0000000000
f0 12345.1
-f20_3 56789.988
+f20_3 56789.984
f23_0 123457000
r1_1 0.9
INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10,pk) VALUES (0,0,0,0,0,0,0,0,0,0,2);
@@ -256,7 +256,7 @@
f0 12345.1
f0 1e38
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f23_0 0
f23_0 123457000
@@ -307,7 +307,7 @@
f0 1e38
f20_3 0.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f23_0 0
f23_0 0
@@ -399,7 +399,7 @@
f0 3.40282e38
f20_3 0.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f20_3 99999998430674940.000
f23_0 0
@@ -481,7 +481,7 @@
f0 3.40282e38
f20_3 0.000
f20_3 0.000
-f20_3 56789.988
+f20_3 56789.984
f20_3 99999998430674940.000
f20_3 99999998430674940.000
f20_3 99999998430674940.000

mysqltest: Result content mismatch

The tests have been failing apparently since the builder was created, in early 2020 (with a gap in between when install failed and thus MTR didn't run).

[MDEV-28694] rocksdb.col_opt* and rocksdb.type_float fail deterministically on kvm-rpm-rhel8-ppc64le in buildbot Created: 2022-05-29 Updated: 2023-04-27
Status:	Open
Project:	MariaDB Server
Component/s:	Platform Power, Storage Engine - RocksDB, Tests
Affects Version/s:	10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s:	10.4, 10.5, 10.6

[MDEV-28694] rocksdb.col_opt* and rocksdb.type_float fail deterministically on kvm-rpm-rhel8-ppc64le in buildbot Created: 2022-05-29 Updated: 2023-04-27