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

mroonga datetime test fails on arch alpha

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Incomplete
    • 10.0.22
    • N/A
    • Platform Debian
    • None

    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.

      Attachments

        Issue Links

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.