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
MDEV-27113Importing timezone tables does not work in recent version
Closed
relates to
MDEV-28263mariadb-tzinfo-to-sql binlog, embedded, and performance fixes
Closed
MDBF-557Faster timezone updates was: Remove DST support for "America/Mexico_City" timezone
Thanks danblack. This has been merged and rewritten a bit (improve logging mechanism and error handling mainly and adapt PATH for production).
A routine has been deployed on the mirror machine and zoneinfo.sql is now generated everyday in /zoneinfo/zoneinfo.zip. I need to sync now with dbart in order to decide how we can push this on osuosl and netcologne (and every mirror will pull from there).
Faustin Lammler
added a comment - Thanks danblack . This has been merged and rewritten a bit (improve logging mechanism and error handling mainly and adapt PATH for production).
A routine has been deployed on the mirror machine and zoneinfo.sql is now generated everyday in /zoneinfo/zoneinfo.zip. I need to sync now with dbart in order to decide how we can push this on osuosl and netcologne (and every mirror will pull from there).
Faustin Lammler
added a comment - - edited danblack the zoneinfo file is now replicated on the fi mirror (under our control), this is the only mirror serving the file until we put it on netcologne and osuosl with dbart.
https://mirror.mariadb.org/zoneinfo/zoneinfo.zip?mirrorlist
Next time the docker container is updated, I would like to verify that the whole process is working good. I switch the script to using podman instead of docker and I hit a nice bug in conman, so I have added another check . You can probably have a look when you have time, it's almost finished I guess:
https://gitlab.com/mariadb/sysadmin/-/blob/deploy-tzdata/ansible/zoneinfo/generate_zoneinfo.sh
Welcome to the use of podman too. (I was too, just had docker=podman alias, and a newer version that avoided the bug).
It occurred to me maybe zonedata_old.zip is a better filename for the old version.
Production scripts in home directories doesn't look great either.
I'm really happy we have a solution now.
Daniel Black
added a comment - Looks good. Thanks.
Welcome to the use of podman too. (I was too, just had docker=podman alias, and a newer version that avoided the bug).
It occurred to me maybe zonedata_old.zip is a better filename for the old version.
Production scripts in home directories doesn't look great either.
I'm really happy we have a solution now.
> It occurred to me maybe zonedata_old.zip is a better filename for the old version.
You mean zoneinfo_old.zip, should we keep it then?
It's not the case for the moment.
> Production scripts in home directories doesn't look great either.
Yep, fully agree on that, it's already on my TODO list to add a proper sync user for the mirror machine but it will have to wait a bit since it depends on other task.
Faustin Lammler
added a comment - > It occurred to me maybe zonedata_old.zip is a better filename for the old version.
You mean zoneinfo_old.zip, should we keep it then?
It's not the case for the moment.
> Production scripts in home directories doesn't look great either.
Yep, fully agree on that, it's already on my TODO list to add a proper sync user for the mirror machine but it will have to wait a bit since it depends on other task.
People
Faustin Lammler
Daniel Black
Votes:
0Vote for this issue
Watchers:
3Start watching this issue
Dates
Created:
Updated:
Resolved:
Time Tracking
Estimated:
Not Specified
Remaining:
0d
Logged:
0.75d
{"report":{"fcp":1464.9000000953674,"ttfb":300.7000000476837,"pageVisibility":"visible","entityId":109774,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"a60ad2ca-f375-4024-8c05-0686e8b6710e","navigationType":0,"readyForUser":1549.1000000238419,"redirectCount":0,"resourceLoadedEnd":2457.9000000953674,"resourceLoadedStart":311.3000000715256,"resourceTiming":[{"duration":598.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":311.3000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":311.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":909.6000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":598.3000000715256,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":311.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":311.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":909.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":606.8999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":311.8000000715256,"connectEnd":311.8000000715256,"connectStart":311.8000000715256,"domainLookupEnd":311.8000000715256,"domainLookupStart":311.8000000715256,"fetchStart":311.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":311.8000000715256,"responseEnd":918.7000000476837,"responseStart":918.7000000476837,"secureConnectionStart":311.8000000715256},{"duration":646.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":311.90000009536743,"connectEnd":311.90000009536743,"connectStart":311.90000009536743,"domainLookupEnd":311.90000009536743,"domainLookupStart":311.90000009536743,"fetchStart":311.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":311.90000009536743,"responseEnd":958.3000000715256,"responseStart":958.3000000715256,"secureConnectionStart":311.90000009536743},{"duration":650.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":312.2000000476837,"connectEnd":312.2000000476837,"connectStart":312.2000000476837,"domainLookupEnd":312.2000000476837,"domainLookupStart":312.2000000476837,"fetchStart":312.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":312.2000000476837,"responseEnd":962.4000000953674,"responseStart":962.3000000715256,"secureConnectionStart":312.2000000476837},{"duration":650.6000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":312.3000000715256,"connectEnd":312.3000000715256,"connectStart":312.3000000715256,"domainLookupEnd":312.3000000715256,"domainLookupStart":312.3000000715256,"fetchStart":312.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":312.3000000715256,"responseEnd":962.9000000953674,"responseStart":962.8000000715256,"secureConnectionStart":312.3000000715256},{"duration":650.8000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":312.5,"connectEnd":312.5,"connectStart":312.5,"domainLookupEnd":312.5,"domainLookupStart":312.5,"fetchStart":312.5,"redirectEnd":0,"redirectStart":0,"requestStart":312.5,"responseEnd":963.3000000715256,"responseStart":963.3000000715256,"secureConnectionStart":312.5},{"duration":762,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":312.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":312.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1074.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":651,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":312.8000000715256,"connectEnd":312.8000000715256,"connectStart":312.8000000715256,"domainLookupEnd":312.8000000715256,"domainLookupStart":312.8000000715256,"fetchStart":312.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":312.8000000715256,"responseEnd":963.8000000715256,"responseStart":963.8000000715256,"secureConnectionStart":312.8000000715256},{"duration":761.8000000715256,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1074.8000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":651.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":313.2000000476837,"connectEnd":313.2000000476837,"connectStart":313.2000000476837,"domainLookupEnd":313.2000000476837,"domainLookupStart":313.2000000476837,"fetchStart":313.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":313.2000000476837,"responseEnd":964.9000000953674,"responseStart":964.9000000953674,"secureConnectionStart":313.2000000476837},{"duration":2135.899999976158,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":321.2000000476837,"connectEnd":321.2000000476837,"connectStart":321.2000000476837,"domainLookupEnd":321.2000000476837,"domainLookupStart":321.2000000476837,"fetchStart":321.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":321.2000000476837,"responseEnd":2457.100000023842,"responseStart":2457.100000023842,"secureConnectionStart":321.2000000476837},{"duration":2136.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":321.2000000476837,"connectEnd":321.2000000476837,"connectStart":321.2000000476837,"domainLookupEnd":321.2000000476837,"domainLookupStart":321.2000000476837,"fetchStart":321.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":321.2000000476837,"responseEnd":2457.9000000953674,"responseStart":2457.9000000953674,"secureConnectionStart":321.2000000476837},{"duration":1170.6999999284744,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1087.8000000715256,"connectEnd":1087.8000000715256,"connectStart":1087.8000000715256,"domainLookupEnd":1087.8000000715256,"domainLookupStart":1087.8000000715256,"fetchStart":1087.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":1087.8000000715256,"responseEnd":2258.5,"responseStart":2258.5,"secureConnectionStart":1087.8000000715256},{"duration":1030.0999999046326,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1456.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1456.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2487,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":100,"responseStart":301,"responseEnd":320,"domLoading":310,"domInteractive":2489,"domContentLoadedEventStart":2489,"domContentLoadedEventEnd":2536,"domComplete":3216,"loadEventStart":3216,"loadEventEnd":3216,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2461.8000000715256},{"name":"bigPipe.sidebar-id.end","time":2462.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":2462.8000000715256},{"name":"bigPipe.activity-panel-pipe-id.end","time":2464.5},{"name":"activityTabFullyLoaded","time":2552.600000023842}],"measures":[],"correlationId":"8313fc00c1f63c","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":145,"dbReadsTimeInMs":15,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
https://gitlab.com/mariadb/sysadmin/-/merge_requests/29