Bug #115019 Warnings for time zone files that can't be loaded

• Submitted: 15 May 18:03
• Modified: 23 Oct 8:49
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 8.4.0
• OS: Any
• CPU Architecture: Any
• Tags: Contribution

[15 May 18:03] Daniël van Eeden

Description:
When starting a the mysql:8.4.0 container the output has this:

Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.

The issues is that these files are expected to be in the zoneinfo directory and it is expected for these to fail to load. This makes it easier to miss an actual important warning for a file that should be loaded.

How to repeat:
Run mysql:8.4.0 container and check the output for warnings.

Suggested fix:
Have a list of files that should be skipped or ignored.

[15 May 18:43] Daniël van Eeden

Patch from https://github.com/mysql/mysql-server/pull/542

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: 0001-mysql_tzinfo_to_sql-suppress-expected-warnings.patch (text/x-patch), 1.42 KiB.

[16 May 5:59] MySQL Verification Team

Hello Daniël,

Thank you for the report and feedback.

regards,
Umesh

[23 Oct 8:49] Daniël van Eeden

Any update on this?