[MDEV-14224] Running mysql_tzinfo_to_sql produces errors for leapseconds and tzdata.zi files in centos package tzdata Created: 2017-10-30  Updated: 2021-05-02  Resolved: 2017-10-31

Status: Closed
Project: MariaDB Server
Component/s: Configuration
Affects Version/s: 10.1, 5.5.56, 10.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Christopher Barry Rose Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Centos 7/RHEL 7

Issue Links:
Relates
relates to MDEV-25577 mariadb-tzinfo-to-sql generates super... Closed

 Description   

In a VMWARE virtual machine running a fresh minimal install of centos 7. Updates to current packages as of 10/30/2017. MariaDB installed from Maridb Repo. (Version 10.1.28-1) (also verified for 10.2 and version 5.5.56)

When running 

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

The following warnings are generated

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.

I have verified both files exist. Both appear to be in correct format. Both are parts of the tzdata package from the centos base repo.

 Comments   
Comment by Sergei Golubchik [ 2017-10-31 ]

Both files exist and in the correct format. But:

$  file  /usr/share/zoneinfo/*
 
/usr/share/zoneinfo/Africa:       directory
 
...
 
/usr/share/zoneinfo/Kwajalein:    timezone data, version 2, 3 gmt time flags, 3 std time flags, no leap seconds, 2 transition times, 3 abbreviation chars
 
/usr/share/zoneinfo/leapseconds:  ASCII text
 
/usr/share/zoneinfo/Libya:        timezone data, version 2, 4 gmt time flags, 4 std time flags, no leap seconds, 32 transition times, 4 abbreviation chars
 
...
 
/usr/share/zoneinfo/Turkey:       timezone data, version 2, 10 gmt time flags, 10 std time flags, no leap seconds, 129 transition times, 10 abbreviation chars
 
/usr/share/zoneinfo/tzdata.zi:    ASCII text
 
/usr/share/zoneinfo/UCT:          timezone data, version 2, 1 gmt time flag, 1 std time flag, no leap seconds, no transition times, 1 abbreviation char

They exists, but they are not timezone data. Which is exactly what mysql_tzinfo_to_sql says, "unable to load the file as time zone".

In other words — it's normal. You just have some files in the non-timezone format in your /usr/share/zoneinfo, nothing to worry about.

Comment by Christopher Barry Rose [ 2017-11-01 ]

This is odd because I never had the script carp this message before when building these servers. It just suddenly started doing this.

Generated at Thu Feb 08 08:11:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.