Uploaded image for project: 'MariaDB Foundation Development'
  1. MariaDB Foundation Development
  2. MDBF-389

provide timezone data files

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • N/A
    • Downloads
    • None

    Description

      Our kb on timezones for Windows does not provide a solution for 10.6+ because the MySQL timezones are incompatible (Offset is a keyword in MariaDB only).

      Because we now have a mirror service can we generate the timezones sql files here for distribution.

      Suggestion:

      A cron job that runs:

      $ docker pull docker.io/library/mariadb:10.6
      		 
      $ docker run --rm docker.io/library/mariadb:10.6 mariadb-tzinfo-to-sql /usr/share/zoneinfo > zoneinfo.sql

      The mariadb image is semi frequently updated as its ubuntu base image is also updated, hence bringing with it updated /usr/share/zoneinfo. Also as we do releases and the mariadb-tzinfo-to-sql changes we get that change automatically.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27113 Importing timezone tables does not work in recent version

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28263 mariadb-tzinfo-to-sql binlog, embedded, and performance fixes

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDBF-557 Faster timezone updates was: Remove DST support for "America/Mexico_City" timezone

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              faust Faustin Lammler
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.75d
                  0.75d