[MDEV-749] LP:780108 - Couldn't import zoneinfo to MariaDB on Debian squeeze Created: 2011-05-09  Updated: 2019-04-29

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.1, 5.5.30, 5.1.67, 5.2.14, 5.3.12
Fix Version/s: 10.2

Type: Bug Priority: Minor
Reporter: NT Man (Inactive) Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: Launchpad, beginner-friendly, upstream-fixed

Attachments: XML File LPexportBug780108.xml    
Issue Links:
Relates
relates to MDEV-6236 [PATCH] mysql_tzinfo_to_sql may produ... Closed

 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



 Comments   
Comment by Colin Charles [ 2011-11-13 ]

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?

Comment by Rasmus Johansson (Inactive) [ 2012-04-27 ]

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

Comment by Rasmus Johansson (Inactive) [ 2012-04-27 ]

Launchpad bug id: 780108

Comment by Elena Stepanova [ 2013-03-29 ]

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).

Comment by Alexander Barkov [ 2013-11-15 ]

See also http://bugs.mysql.com/bug.php?id=68861

Generated at Thu Feb 08 06:31:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.