[MDEV-9270] mroonga datetime test fails on arch alpha Created: 2015-12-11  Updated: 2022-11-13  Resolved: 2022-11-10

Status: Closed
Project: MariaDB Server
Component/s: Platform Debian
Affects Version/s: 10.0.22
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Otto Kekäläinen Assignee: Vicențiu Ciorbaru
Resolution: Incomplete Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-9268 rpl.rpl_skip_replication test fails o... Closed

 Description   

In Debian, the builds for the unofficial alpha platform fails due to failing test:

mroonga/storage.column_date_with_index   w2 [ pass ]    804
 
mroonga/storage.column_date_without_index w2 [ pass ]    591
 
mroonga/storage.column_date_zero_date    w2 [ pass ]    423
 
mroonga/storage.column_datetime_32bit_2038 w2 [ fail ]
 
        Test ended at 2015-12-11 05:29:37
 
 
 
CURRENT_TEST: mroonga/storage.column_datetime_32bit_2038
 
--- /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_2038.result	2015-10-28 12:34:45.000000000 +0000
 
+++ /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_2038.reject	2015-12-11 05:29:37.518810961 +0000
 
@@ -16,10 +16,8 @@
 
 VALUES ('2038-01-18 03:14:07', '2038-01-18 03:14:07');
 
 INSERT INTO diaries (title, created_at)
 
 VALUES ('2038-01-20 03:14:08', '2038-01-20 03:14:08');
 
-Warnings:
 
-Warning	1265	Data truncated for column 'created_at' at row 1
 
 SELECT * FROM diaries;
 
 id	title	created_at
 
 1	2038-01-18 03:14:07	2038-01-18 03:14:07
 
-2	2038-01-20 03:14:08	1970-01-01 00:00:00
 
+2	2038-01-20 03:14:08	2038-01-20 03:14:08
 
 DROP TABLE diaries;
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/2/log/mroonga/storage.column_datetime_32bit_2038/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/storage.column_datetime_32bit_2038/'
 
 
 
Retrying test mroonga/storage.column_datetime_32bit_2038, attempt(2/3)...
 
 
 
mroonga/storage.column_datetime_32bit_before_unix_epoch w2 [ fail ]
 
        Test ended at 2015-12-11 05:29:39
 
 
 
CURRENT_TEST: mroonga/storage.column_datetime_32bit_before_unix_epoch
 
--- /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_before_unix_epoch.result	2015-10-28 12:34:45.000000000 +0000
 
+++ /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_before_unix_epoch.reject	2015-12-11 05:29:39.095499280 +0000
 
@@ -14,9 +14,7 @@
 
 ) ENGINE=Mroonga DEFAULT CHARSET=utf8
 
 INSERT INTO diaries (title, created_at)
 
 VALUES ('1000-01-01 00:00:00', '1000-01-01 00:00:00');
 
-Warnings:
 
-Warning	1265	Data truncated for column 'created_at' at row 1
 
 SELECT * FROM diaries;
 
 id	title	created_at
 
-1	1000-01-01 00:00:00	1970-01-01 00:00:00
 
+1	1000-01-01 00:00:00	1000-01-01 00:00:00
 
 DROP TABLE diaries;
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/2/log/mroonga/storage.column_datetime_32bit_before_unix_epoch/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/storage.column_datetime_32bit_before_unix_epoch/'
 
 
 
Retrying test mroonga/storage.column_datetime_32bit_before_unix_epoch, attempt(2/3)...
 
 
 
mroonga/storage.column_datetime_32bit_max w2 [ fail ]
 
        Test ended at 2015-12-11 05:29:40
 
 
 
CURRENT_TEST: mroonga/storage.column_datetime_32bit_max
 
--- /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_max.result	2015-10-28 12:34:45.000000000 +0000
 
+++ /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_max.reject	2015-12-11 05:29:40.697602290 +0000
 
@@ -14,9 +14,7 @@
 
 ) ENGINE=Mroonga DEFAULT CHARSET=utf8
 
 INSERT INTO diaries (title, created_at)
 
 VALUES ('9999-12-31 23:59:59', '9999-12-31 23:59:59');
 
-Warnings:
 
-Warning	1265	Data truncated for column 'created_at' at row 1
 
 SELECT * FROM diaries;
 
 id	title	created_at
 
-1	9999-12-31 23:59:59	1970-01-01 00:00:00
 
+1	9999-12-31 23:59:59	9999-12-31 23:59:59
 
 DROP TABLE diaries;
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/2/log/mroonga/storage.column_datetime_32bit_max/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/storage.column_datetime_32bit_max/'
 
 
 
Retrying test mroonga/storage.column_datetime_32bit_max, attempt(2/3)...
 
 
 
mroonga/storage.column_datetime_32bit_2038 w2 [ retry-fail ]
 
        Test ended at 2015-12-11 05:29:42
 
 
 
CURRENT_TEST: mroonga/storage.column_datetime_32bit_2038
 
--- /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_2038.result	2015-10-28 12:34:45.000000000 +0000
 
+++ /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_2038.reject	2015-12-11 05:29:42.167744405 +0000
 
@@ -16,10 +16,8 @@
 
 VALUES ('2038-01-18 03:14:07', '2038-01-18 03:14:07');
 
 INSERT INTO diaries (title, created_at)
 
 VALUES ('2038-01-20 03:14:08', '2038-01-20 03:14:08');
 
-Warnings:
 
-Warning	1265	Data truncated for column 'created_at' at row 1
 
 SELECT * FROM diaries;
 
 id	title	created_at
 
 1	2038-01-18 03:14:07	2038-01-18 03:14:07
 
-2	2038-01-20 03:14:08	1970-01-01 00:00:00
 
+2	2038-01-20 03:14:08	2038-01-20 03:14:08
 
 DROP TABLE diaries;
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/2/log/mroonga/storage.column_datetime_32bit_2038/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/storage.column_datetime_32bit_2038/'
 
 
 
Test mroonga/storage.column_datetime_32bit_2038 has failed 2 times, no more retries!
 
 
 
mroonga/storage.column_datetime_32bit_before_unix_epoch w2 [ retry-fail ]
 
        Test ended at 2015-12-11 05:29:44
 
 
 
CURRENT_TEST: mroonga/storage.column_datetime_32bit_before_unix_epoch
 
--- /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_before_unix_epoch.result	2015-10-28 12:34:45.000000000 +0000
 
+++ /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_before_unix_epoch.reject	2015-12-11 05:29:44.024971811 +0000
 
@@ -14,9 +14,7 @@
 
 ) ENGINE=Mroonga DEFAULT CHARSET=utf8
 
 INSERT INTO diaries (title, created_at)
 
 VALUES ('1000-01-01 00:00:00', '1000-01-01 00:00:00');
 
-Warnings:
 
-Warning	1265	Data truncated for column 'created_at' at row 1
 
 SELECT * FROM diaries;
 
 id	title	created_at
 
-1	1000-01-01 00:00:00	1970-01-01 00:00:00
 
+1	1000-01-01 00:00:00	1000-01-01 00:00:00
 
 DROP TABLE diaries;
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/2/log/mroonga/storage.column_datetime_32bit_before_unix_epoch/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/storage.column_datetime_32bit_before_unix_epoch/'
 
 
 
Test mroonga/storage.column_datetime_32bit_before_unix_epoch has failed 2 times, no more retries!
 
 
 
mroonga/storage.column_datetime_32bit_max w2 [ retry-fail ]
 
        Test ended at 2015-12-11 05:29:45
 
 
 
CURRENT_TEST: mroonga/storage.column_datetime_32bit_max
 
--- /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_max.result	2015-10-28 12:34:45.000000000 +0000
 
+++ /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_max.reject	2015-12-11 05:29:45.758058227 +0000
 
@@ -14,9 +14,7 @@
 
 ) ENGINE=Mroonga DEFAULT CHARSET=utf8
 
 INSERT INTO diaries (title, created_at)
 
 VALUES ('9999-12-31 23:59:59', '9999-12-31 23:59:59');
 
-Warnings:
 
-Warning	1265	Data truncated for column 'created_at' at row 1
 
 SELECT * FROM diaries;
 
 id	title	created_at
 
-1	9999-12-31 23:59:59	1970-01-01 00:00:00
 
+1	9999-12-31 23:59:59	9999-12-31 23:59:59
 
 DROP TABLE diaries;
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/2/log/mroonga/storage.column_datetime_32bit_max/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/storage.column_datetime_32bit_max/'
 
 
 
Test mroonga/storage.column_datetime_32bit_max has failed 2 times, no more retries!
 
 
 
mroonga/storage.column_datetime_32bit_out_of_range w2 [ fail ]
 
        Test ended at 2015-12-11 05:29:47
 
 
 
CURRENT_TEST: mroonga/storage.column_datetime_32bit_out_of_range
 
--- /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_out_of_range.result	2015-10-28 12:34:45.000000000 +0000
 
+++ /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_out_of_range.reject	2015-12-11 05:29:47.536109096 +0000
 
@@ -19,5 +19,5 @@
 
 Warning	1265	Data truncated for column 'created_at' at row 1
 
 SELECT * FROM diaries;
 
 id	title	created_at
 
-1	2012	1970-01-01 00:00:00
 
+1	2012	0000-01-01 00:00:00
 
 DROP TABLE diaries;
 
 
 
mysqltest: Result content mismatch
 
 
 
 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/2/log/mroonga/storage.column_datetime_32bit_out_of_range/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/storage.column_datetime_32bit_out_of_range/'
 
 
 
Retrying test mroonga/storage.column_datetime_32bit_out_of_range, attempt(2/3)...
 
 
 
mroonga/storage.column_datetime_64bit_2038 w2 [ skipped ]  Need a 64 binary
 
mroonga/storage.column_datetime_64bit_before_unix_epoch w2 [ skipped ]  Need a 64 binary
 
main.index_intersect_innodb 'innodb_plugin' w3 [ pass ]  15787
 
mroonga/storage.column_datetime_32bit_out_of_range w2 [ retry-fail ]
 
        Test ended at 2015-12-11 05:29:50
 
 
 
CURRENT_TEST: mroonga/storage.column_datetime_32bit_out_of_range
 
--- /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_out_of_range.result	2015-10-28 12:34:45.000000000 +0000
 
+++ /«PKGBUILDDIR»/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_32bit_out_of_range.reject	2015-12-11 05:29:49.789219186 +0000
 
@@ -19,5 +19,5 @@
 
 Warning	1265	Data truncated for column 'created_at' at row 1
 
 SELECT * FROM diaries;
 
 id	title	created_at
 
-1	2012	1970-01-01 00:00:00
 
+1	2012	0000-01-01 00:00:00
 
 DROP TABLE diaries;
 
 
 
mysqltest: Result content mismatch
 
 
 
 - saving '/«PKGBUILDDIR»/builddir/mysql-test/var/2/log/mroonga/storage.column_datetime_32bit_out_of_range/' to '/«PKGBUILDDIR»/builddir/mysql-test/var/log/storage.column_datetime_32bit_out_of_range/'
 
 
 
Test mroonga/storage.column_datetime_32bit_out_of_range has failed 2 times, no more retries!

Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.0&arch=alpha&ver=10.0.22-2&stamp=1449822712

This issue is very minor, I don't expect anybody to fix it unless the fix is very easy or if somebody anywhere ever actually is found to be using Alpha machines.

 Comments   
Comment by Elena Stepanova [ 2016-01-05 ]

Is it not a duplicate of MDEV-7210, which was recently fixed?

Comment by Otto Kekäläinen [ 2016-01-05 ]

No, it is not a duplicate of MDEV-7210 - the symptoms are not the same (not related to 32-bitness) and anyway that one was fixed and has disappeared some releases ago. This new issue surfaced only when Ubuntu/Launchpad enabled s390x builds for their standard repos.

Comment by Elena Stepanova [ 2016-02-07 ]

Another story: alpha is 64-bit, right? The 32-bit test shouldn't even run there; if it does, apparently it's incorrectly recognized.
Not long ago Monty fixed a similar problem (which lead to the exact same test failure) for Solaris:
https://github.com/MariaDB/server/commit/c2ec897745f37c1479dc9be3a2a3b476e4ed694f
But he only fixed it in 10.1.
otto, can you apply it and see if it fixes it for alpha as well? If so, we just need to push it into 10.0.

Comment by Elena Stepanova [ 2016-08-21 ]

Re-opening - if we have to mark the test unstable, we can't just close the report.

Comment by Sergei Golubchik [ 2017-06-26 ]

Still an issue?

Comment by Otto Kekäläinen [ 2017-06-27 ]

As it is an unofficial arch, Jessie is not built for it, only unstable (Sid) and thus we only have logs for 10.1 series. There the test is disabled (since this issue was filed):

mroonga/storage.column_datetime_32bit_2038 [ disabled ]  MDEV-9270
 
mroonga/storage.column_datetime_32bit_before_unix_epoch [ disabled ]  MDEV-9270
 
mroonga/storage.column_datetime_32bit_max [ disabled ]  MDEV-9270
 
mroonga/storage.column_datetime_32bit_out_of_range [ disabled ]  MDEV-9270

https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.1&arch=alpha&ver=10.1.24-6&stamp=1498229454&raw=0

We need to re-enable the test and make a new upload to see what the status is today. I could basically re-enable all disabled tests in one upload to get a status update to this and similar MDEVs.

Comment by Elena Stepanova [ 2017-07-31 ]

Any luck on getting the updated status?

Comment by Elena Stepanova [ 2017-08-29 ]

oerdnj, maybe you have an update on this?

Comment by Ondřej Surý (Inactive) [ 2017-08-30 ]

I've re-enabled the test that have been disabled before for `10.1.26-1` and now it looks better:

https://buildd.debian.org/status/package.php?p=mariadb-10.1

There's a build failure on mips64el that needs to be yet filled in JIRA and test failure on hppa + many failures on x32 (which is hybrid architecture, so it's sort of expected...)

Comment by Elena Stepanova [ 2017-09-29 ]

oerdnj,

In the build above (it's this log, right? https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.1&arch=alpha&ver=10.1.26-1&stamp=1503581553&raw=0 ) the tests are still skipped: 

mroonga/storage.column_datetime_32bit_2038 [ disabled ]  Wrong result on Alpha
 
mroonga/storage.column_datetime_32bit_before_unix_epoch [ disabled ]  Wrong result on Alpha
 
mroonga/storage.column_datetime_32bit_max [ disabled ]  Wrong result on Alpha
 
mroonga/storage.column_datetime_32bit_out_of_range [ disabled ]  Wrong result on Alpha

They are disabled through the unstable-tests list, exactly due to this bug report and other similar ones. To find out whether they work or not, you need to either remove them from the list, or to try running tests without the list (there might be other failures then).

Comment by Elena Stepanova [ 2017-11-05 ]

cvicentiu, could you please figure it out so that we could close the bug report?

Comment by Elena Stepanova [ 2022-11-10 ]

The only alpha build I can find now is this 40-day-old 10.6 on Sid
https://buildd.debian.org/status/logs.php?pkg=mariadb-10.6&ver=1%3A10.6.10-1&arch=alpha
and it didn't build, so no MTR was run.

Comment by Otto Kekäläinen [ 2022-11-13 ]

MariaDB 10.5 a year ago still built on Alpha:
https://buildd.debian.org/status/logs.php?pkg=mariadb-10.5
https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.5&arch=alpha&ver=1%3A10.5.12-1&stamp=1628596323&raw=0

While Alpha is an esoteric architecture, mistakes that break cross-arch builds are typically due to misuse of C++ syntax/concepts and fixing them usually benefits all architectures.

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