[MDEV-3757] LP:826377 - Aria DB Format: Reading specific table from dump causes Wrong bytesec Created: 2011-08-14 Updated: 2015-02-02 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | nbrnhardt (Inactive) | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
Note: I have tested this dump/bug only on WIndows 32 Bit (XP/2003). MySQL crashes with "ERROR 1034 (HY000) at line 135888: Wrong bytesec: 0- 0- 0 at 293128; Skipped" The original table where created with MySQL and converted on MariaDB 5.2.5 from MyISAM to Aria format without error. When restoring the SQL backup from file to an Intel i7 machine, I had this error 1034 since MariaDB 5.2.5. When upgrading to version 5.3.0 on the server, I created all databases freshly from SQL dump. The bug emerged then on all machines tested: When creating the same table as MyISAM, the bug does not occur. Dump, my.ini file and database dir after restoring is included in ariadbformatwrongbytesec.7z |
| Comments |
| Comment by nbrnhardt (Inactive) [ 2011-08-14 ] |
|
Re: Aria DB Format: Reading specific table from dump causes Wrong bytesec |
| Comment by nbrnhardt (Inactive) [ 2011-08-14 ] |
|
ariadbformatwrongbytesec.7z |
| Comment by Michael Widenius [ 2011-08-15 ] |
|
Re: Aria DB Format: Reading specific table from dump causes Wrong bytesec If you remove the alter table command from the dump, the data loads fine. I will push a fix to 5.2 shortly |
| Comment by Michael Widenius [ 2011-08-15 ] |
|
Re: Aria DB Format: Reading specific table from dump causes Wrong bytesec Thanks a lot for the test case ; It helped me to quickly find the bug! |
| Comment by Rasmus Johansson (Inactive) [ 2011-12-01 ] |
|
Launchpad bug id: 826377 |