Bug #17917 SELECT from compressed MyISAM table crashes MySQL server
Submitted: 4 Mar 2006 15:00 Modified: 25 Apr 2006 15:45
Reporter: Victoria Reznichenko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.1.18 OS:Linux (linux)
Assigned to: Sergey Vojtovich CPU Architecture:Any

[4 Mar 2006 15:00] Victoria Reznichenko
Description:
The following query crashes compressed(with myisampack) MyISAM tables:
select * from tciderog limit 60000000, 1;

with uncompressed table this query works just fine.

How to repeat:
1. Create table
2. Populated it with dummy data
3. Compress it with myisampack and recreated indexes with myisamchk -rq
4. Run: select * from tciderog limit 60000000, 1;

Suggested fix:
[4 Mar 2006 15:01] MySQL Verification Team
mysqld.trace

Attachment: mysqld.trace (application/octet-stream, text), 8.24 KiB.

[4 Mar 2006 15:01] MySQL Verification Team
mysqld.trace is attached.
[8 Mar 2006 12:14] MySQL Verification Team
I was not able to reproduce server crash on 64-bit box.
[11 Apr 2006 14:37] 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/4801
[12 Apr 2006 11:32] 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/4850
[13 Apr 2006 9:24] 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/4907
[13 Apr 2006 9:37] 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/4908
[24 Apr 2006 18:19] Sergey Vojtovich
Fixed int 4.1.19, 5.0.21, 5.1.10.
[25 Apr 2006 15:45] MC Brown
Noted in 4.1.19, 5.0.21, 5.1.10 changelogs: 

Executing <literal>SELECT</literal> on a large table that had been compressed within <command>myisampack</command> could cause a crash. (Bug #17917)