Bug #8128 Crash in crash recovery of table containing VARCHAR
Submitted: 25 Jan 2005 11:05 Modified: 26 Jan 2005 13:15
Reporter: Marko Mäkelä Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.0.3-bk OS:Any (all)
Assigned to: Marko Mäkelä CPU Architecture:Any

[25 Jan 2005 11:05] Marko Mäkelä
There is something wrong with MLOG_COMP_REC_INSERT entries in the redo log that affects the crash recovery of tables containing VARCHAR columns.

How to repeat:
create table ibtest16 (B VARCHAR(200) NOT NULL) TYPE = INNODB

followed by

insert into ibtest16 (B) values(...)
replace into ibtest16 (B) values (...)
update ibtest16 set B = ...

and restart mysqld.

Suggested fix:
Ensure that the dummy index information is written and restored properly.
[26 Jan 2005 13:15] Marko Mäkelä
This bug was probably caused by a typo in the fix of Bug #7973. There may still be other crash recovery bugs in the new compact InnoDB table format of MySQL 5.0.3.