Details
Minor
Description
Data import ending with fatal error:
ERROR 1406 (22001) at line 39365: Data too long for column 'Abbreviation' at row 1
mikhail@p5k:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot mysql Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh87' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh88' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh89' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh87' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh88' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh89' as time zone. Skipping it. ERROR 1406 (22001) at line 39365: Data too long for column 'Abbreviation' at row 1
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: Couldn't import zoneinfo to MariaDB on Debian squeeze
I found this burgeport via searchnig "Data too long for column 'Abbreviation' at row 1"
I set the | sql_mode | STRICT_TRANS_TABLES
I am using Ubuntu 10.04 / MySQL version 5.1.41-3ubuntu12.7-log
Launchpad bug id: 780108
Reproducible on all versions of MySQL / MariaDB and exists in MySQL bugbase as http://bugs.mysql.com/bug.php?id=20545
It's important that the server is running with STRICT_ALL_TABLES.
Here is the offending line:
INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
(@time_zone_id, 0, 0, 0, 'Local time zone must be set--see zic manual page')
Abbreviation is CHAR(8).
Re: Couldn't import zoneinfo to MariaDB on Debian squeeze
Which version of MariaDB was this? Where did you get the version of MariaDB from?