Bug #40805 | Cannot restore table | ||
---|---|---|---|
Submitted: | 17 Nov 2008 21:07 | Modified: | 29 Jan 2009 20:58 |
Reporter: | Mikulas Kovarcik | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Charsets | Severity: | S1 (Critical) |
Version: | 6.0 bzr | OS: | Any (Linux, MS Windows) |
Assigned to: | Alexander Barkov | CPU Architecture: | Any |
Tags: | Backup, regression, restore |
[17 Nov 2008 21:07]
Mikulas Kovarcik
[18 Nov 2008 19:56]
Mikulas Kovarcik
complete backup
Attachment: Sokol 20081117 2043.zip (application/zip, text), 184.70 KiB.
[19 Nov 2008 8:26]
Sveta Smirnova
Thank you for the report. Please indicate accurate version of MySQL Administrator you use, error from MySQL server and its configuration file.
[19 Nov 2008 16:37]
Mikulas Kovarcik
MySQL Administrator 1.2.14 - latest, but it appeared in former versions also.
[19 Nov 2008 16:41]
Mikulas Kovarcik
I am not able to send you an error msg. bcs. I must kill process mysqld every time. Processor occupancy is 100%, and mysqld takes 99%. It looks like neverending loop.
[21 Nov 2008 8:54]
Sveta Smirnova
Thank you for the feedback. Problem is players table. Simplified test case: DROP TABLE IF EXISTS `players`; CREATE TABLE `players` ( `ID` smallint(5) unsigned zerofill NOT NULL AUTO_INCREMENT, `Post` enum('','B','O','Z','U') COLLATE latin2_czech_cs DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=135 DEFAULT CHARSET=latin2; INSERT INTO `players` (`ID`,`Post`) VALUES (00041,''); Workaround: don't use collation latin2_czech_cs for column Post.
[21 Nov 2008 8:55]
Sveta Smirnova
Bug description: INSERT into ENUM with collation latin2_czech_cs hangs.
[21 Nov 2008 9:15]
Sveta Smirnova
Bug is not repeatable with with versions 4.1, 5.0, 5.1
[28 Nov 2008 12:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/60155 2752 Alexander Barkov 2008-11-28 Bug#40805 Cannot restore table Problem: my_strnncoll_czech() hung when comparing two empty strings. Fix: - Wrong piece of code in cype-czech.c:NEXT_CMP_VALUE was fixed. - Related comment was added into ctype-czech.c. - Test case was added.
[24 Dec 2008 7:59]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/62284 2822 Alexander Barkov 2008-12-24 Bug#40805 Cannot restore table Problem: my_strnncoll_czech() hung when comparing two empty strings. Fix: - Wrong piece of code in cype-czech.c:NEXT_CMP_VALUE was fixed. - Related comment was added into ctype-czech.c. - Test case was added. The fix does not change the collation order, index rebuild is not needed when upgrade.
[24 Dec 2008 8:01]
Alexander Barkov
Pushed into 6.0.9-bugteam
[20 Jan 2009 19:00]
Bugs System
Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version source revid:azundris@mysql.com-20081230114916-c290n83z25wkt6e4) (merge vers: 6.0.9-alpha) (pib:6)
[29 Jan 2009 20:58]
Paul DuBois
Noted in 6.0.10 changelog. Comparison of empty strings for the latin2_czech_cs character set could hang.