Bug #48848 myisamchk doing sort recover in certain cases resets data pointer to small size
| Submitted: | 17 Nov 2009 20:00 | Modified: | 3 Feb 2012 16:29 |
|---|---|---|---|
| Reporter: | Harrison Fisk | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: MyISAM storage engine | Severity: | S2 (Serious) |
| Version: | 5.1.40, 5.5.13 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | disable keys, MyISAMchk, sort recover | ||
[17 Nov 2009 20:00]
Harrison Fisk
[17 Nov 2009 20:13]
Harrison Fisk
Oops, typo in the test case. The alter table shouldn't be commented out naturally: use test drop table if exists t1; # having a non-unique key on g is essential create table t1 (i int auto_increment primary key, g int not null, key(g)); insert into t1 values (null, 1 ); insert into t1 select null, g+i from t1; insert into t1 select null, g+i from t1; insert into t1 select null, g+i from t1; insert into t1 select null, g+i from t1; insert into t1 select null, g+i from t1; insert into t1 select null, g+i from t1; insert into t1 select null, g+i from t1; insert into t1 select null, g+i from t1; insert into t1 select null, g+i from t1; alter table t1 disable keys; show table status like 't1'\G flush tables; myisamchk -n t1 show table status like 't1'\G
[29 Jun 2011 3:12]
Shane Bester
still affects 5.5.13. Just remember to add a ENGINE=myisam to the create table when testing 5.5
[3 Feb 2012 16:29]
Paul DuBois
Noted in 5.1.62, 5.5.21, 5.6.5 changelogs. Using myisamchk with the sort recover method to repair a table having fixed-width row format could cause the row pointer size to be reduced, effectively resulting in a smaller maximum data file size.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.