Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
MDBF-557 generates zones info files that are linked from https://mariadb.com/kb/en/time-zones/#mysql-time-zone-tables for Windows users on our mirrors - https://mirror.mariadb.org/zoneinfo/.
The same problem of out of date timezones occurs on Docker Official Images that base images have tzdata info packages that are out of date.
|
ubi keeps up to date |
$ podman run -ti --user root mariadb:lts-ubi rpm -qa tzdata
|
tzdata-2025a-1.el9.noarch
|
|
all ubuntu lts versions are on 2024b |
$ podman run -i --user root mariadb:lts dpkg -l tzdata
|
Desired=Unknown/Install/Remove/Purge/Hold
|
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
|
||/ Name Version Architecture Description
|
+++-==============-======================-============-=======================================
|
ii tzdata 2024b-0ubuntu0.24.04.1 all time zone and daylight-saving time data
|
|
|
$ podman run -i --user root mariadb:10.5 dpkg -l tzdata
|
Desired=Unknown/Install/Remove/Purge/Hold
|
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
|
||/ Name Version Architecture Description
|
+++-==============-====================-============-=======================================
|
ii tzdata 2024b-0ubuntu0.20.04 all time zone and daylight-saving time data
|
|
|
$ podman run -i --user root mariadb:10.11 dpkg -l tzdata
|
Desired=Unknown/Install/Remove/Purge/Hold
|
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
|
||/ Name Version Architecture Description
|
+++-==============-====================-============-=======================================
|
ii tzdata 2024b-0ubuntu0.22.04 all time zone and daylight-saving time data
|
The zoneinfo.zip files used by windows aren't usable because:
- Currently no unzip in container images, and although minor, prefer not to add it.
- Docker Official Images require URL that is versioned for sources in their build, that can be verified by checksum https://github.com/docker-library/official-images/?tab=readme-ov-file#image-build. So preferably this would map to a 2024b version perhaps extended by the package version that generated it. A GPG might be overboard for this, but "Less Secure Alternate" of a checksum is possible.
I think the final container should contain a compressed file of tzinfo as for historical reasons the tz initialization has been optional. Having these files on the archive machine would provide some historical reference on why its there.
gz, xz and zstd are supported inside the container, so whatever compresses best on the file.