Bug #29207 | archive table reported as corrupt by check table | ||
---|---|---|---|
Submitted: | 19 Jun 2007 12:16 | Modified: | 7 Jul 2007 18:52 |
Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Archive storage engine | Severity: | S1 (Critical) |
Version: | 5.0.44BK | OS: | Any |
Assigned to: | Sergey Vojtovich | CPU Architecture: | Any |
Tags: | archive, corruption |
[19 Jun 2007 12:16]
Shane Bester
[19 Jun 2007 12:18]
MySQL Verification Team
the above insert statements must be one line each!! cut'n'paste might not work.
[19 Jun 2007 12:19]
MySQL Verification Team
testcase in a file so bugs system doesn't wrap it.
Attachment: bug29207_testcase.txt (text/plain), 476 bytes.
[19 Jun 2007 12:20]
MySQL Verification Team
can cause server to overallocate memory. upping the severity. 070619 14:18:11 [ERROR] mysqld-debug: Out of memory at line 51, '.\sql_string.cpp' 070619 14:18:11 [ERROR] mysqld-debug: needed -1515870808 byte (2713962k), memory in use: 9206422 bytes (8991k)
[19 Jun 2007 12:36]
MySQL Verification Team
another testcase
Attachment: bug29207_testcase_2.txt (text/plain), 511 bytes.
[19 Jun 2007 12:45]
MySQL Verification Team
---------- better testcase ---------- drop table if exists t1; create table t1(a longblob)engine=archive; insert into t1 set a=repeat('a',0); insert into t1 set a=repeat('a',1); check table t1 extended;
[27 Jun 2007 9:17]
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/29683 ChangeSet@1.2493, 2007-06-27 13:19:34+05:00, svoj@mysql.com +3 -0 BUG#29207 - archive table reported as corrupt by check table (P1) CHECK TABLE against ARCHIVE table may falsely report table corruption, or cause server crash. Fixed by using proper buffer for CHECK TABLE. Affects both 5.0 and 5.1.
[27 Jun 2007 16:22]
Brian Aker
This looks fine... but I am thinking the code was originally this way, and was later changed for some reason... but looks good.
[27 Jun 2007 16:22]
Brian Aker
This looks fine... but I am thinking the code was originally this way, and was later changed for some reason... but looks good.
[28 Jun 2007 10:02]
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/29835 ChangeSet@1.2522, 2007-06-28 14:04:20+05:00, svoj@mysql.com +1 -0 BUG#29207 - archive table reported as corrupt by check table After merge fix.
[7 Jul 2007 16:34]
Bugs System
Pushed into 5.1.21-beta
[7 Jul 2007 16:36]
Bugs System
Pushed into 5.0.46
[7 Jul 2007 18:52]
Paul DuBois
Noted in 5.0.46, 5.1.21 changelogs. CHECK TABLE for ARCHIVE tables could falsely report table corruption or cause a server crash.