Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 510696 - [mysql overlay] mysql_install_db: Loading zoneinfo will fails with ERROR 1406 (22001) at line 39883: Data too long for column 'Abbreviation' at row 1
Summary: [mysql overlay] mysql_install_db: Loading zoneinfo will fails with ERROR 1406...
Status: RESOLVED OBSOLETE
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-18 23:54 UTC by Thomas Deutschmann (RETIRED)
Modified: 2021-02-12 00:13 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Deutschmann (RETIRED) gentoo-dev 2014-05-18 23:54:05 UTC
Hi,

"emerge --config percona-server" outputs

[...]
 * Setting root password ...                                                                                     [ ok ]
 * Loading "zoneinfo", this step may require a few seconds ... ...
Warning: Using a password on the command line interface can be insecure.
ERROR 1406 (22001) at line 39883: Data too long for column 'Abbreviation' at row 1                               [ ok ]
 * Failed to load zoneinfo!
 * Stopping the server ...
 * Done

Maybe you only see this error with STRICT SQL modes...


Reproducible: Always
Comment 1 Thomas Deutschmann (RETIRED) gentoo-dev 2014-05-18 23:57:27 UTC
http://bugs.mysql.com/bug.php?id=68861
Comment 2 Brian Evans (RETIRED) gentoo-dev 2014-05-19 01:41:57 UTC
The real culprit is http://bugs.mysql.com/bug.php?id=20545 when STRICT_ALL_TABLES is set before 'emerge --config' is run
Comment 3 Thomas Deutschmann (RETIRED) gentoo-dev 2014-05-19 11:44:53 UTC
I would suggest to replace the "Local time zone must be set--see zic manual page" string with "FACTORY" in mysql-v2.eclass.

This way we would end with a "valid" value... it is better than the truncated "Local ti" value, because when you search for "FACTORY timezone" you will find the information that this is a dummy TZ and you have to set a TZ...
Comment 4 Thomas Deutschmann (RETIRED) gentoo-dev 2015-09-26 04:52:03 UTC
Can we make a progress in this bug? For more than 1 year it isn't possible to create a new mysqld out-of-the box on Gentoo due to this problem. At least this workaround (rm /usr/share/zoneinfo/Factory; emerge --config ..; emerge -1 sys-libs/timezone-data) should be documented somewhere... 

A more convenient way for the eclass seems to be to use /usr/bin/mysql_tzinfo_to_sql to generate the SQL file and sed out the invalid timezones and finally import timezones from the generated file.
Comment 5 Brian Evans (RETIRED) gentoo-dev 2015-09-27 13:03:21 UTC
(In reply to Thomas D. from comment #4)
> Can we make a progress in this bug? For more than 1 year it isn't possible
> to create a new mysqld out-of-the box on Gentoo due to this problem. At
> least this workaround (rm /usr/share/zoneinfo/Factory; emerge --config ..;
> emerge -1 sys-libs/timezone-data) should be documented somewhere... 
> 
> A more convenient way for the eclass seems to be to use
> /usr/bin/mysql_tzinfo_to_sql to generate the SQL file and sed out the
> invalid timezones and finally import timezones from the generated file.

I personally don't think there is a need to sed for one user who sets sql_mode=STRICT before system configuration.

I'll look into emptying the sql_mode instead for just the init