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 11:05	Modified:	26 Jan 2005 13:15
Reporter:	Marko Mäkelä	Email Updates:
Status:	Can't repeat	Impact on me:	None
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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.