MySQL Bugs: #8128: Crash in crash recovery of table containing VARCHAR

Bug #8128	Crash in crash recovery of table containing VARCHAR
Submitted:	25 Jan 2005 12:05	Modified:	26 Jan 2005 14:15
Reporter:	Marko Mäkelä
Status:	Can't repeat
Category:	Server: InnoDB	Severity:	S1 (Critical)
Version:	5.0.3-bk	OS:	Any (all)
Assigned to:	Marko Mäkelä	Target Version:

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

Description:
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.

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.