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

main.timezone started failing in Debian on MEST vs CET time zone difference

Details

    Description

      Recent builds on the official Debian CI system started failing because the time zone in main.timezone changes. I don't know why it changed, and if it is a legit change or not. This upstream bug report is an ask to assess if the current hard-coded time zone value in the test makes sense or not.

      main.timezone                            w4 [ fail ]
      		 
              Test ended at 2024-10-06 06:28:50
      		 
      CURRENT_TEST: main.timezone
      		 
      --- /usr/share/mariadb/mariadb-test/main/timezone.result	2024-08-20 03:41:36.000000000 +0200
      		 
      +++ /tmp/tmp.XgWRvorQ7g/var/4/log/timezone.reject	2024-10-06 08:28:49.819975055 +0200
      		 
      @@ -1,6 +1,6 @@
      		 
       show variables like "system_time_zone";
      		 
       Variable_name	Value
      		 
      -system_time_zone	MET
      		 
      +system_time_zone	CEST
      		 
       #
      		 
       # Test unix timestamp
      		 
       #
      		 
      @@ -82,7 +82,7 @@
      		 
       SET @@time_zone= default;
      		 
       SELECT DATE_FORMAT('2009-11-01 22:23:00', '%z %Z') AS current_timezone;
      		 
       current_timezone
      		 
      -+0100 MET
      		 
      ++0100 CET
      		 
       SELECT DATE_FORMAT('2008-06-04 02:23:00', '%z %Z') AS current_timezone;
      		 
       current_timezone
      		 
      -+0200 MEST
      		 
      ++0200 CEST
      		 
      Result length mismatch

      See failures in action at e.g.
      https://ci.debian.net/packages/m/mariadb/
      -> https://ci.debian.net/packages/m/mariadb/unstable/amd64/52663812/#S14
      https://tests.reproducible-builds.org/debian/rb-pkg/unstable/amd64/mariadb.html
      -> https://tests.reproducible-builds.org/debian/rbuild/unstable/amd64/mariadb_11.4.3-1.rbuild.log.gz
      https://salsa.debian.org/mariadb-team/mariadb-server/-/pipelines
      -> https://salsa.debian.org/mariadb-team/mariadb-server/-/jobs/6245904

      Attachments

        Activity

          People

            danblack Daniel Black
            otto Otto Kekäläinen
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.