Bug #36816 mysql crashed multiple times

• Submitted: 20 May 2008 12:24
• Modified: 24 Jun 2008 16:59
• Reporter: kris dba
• Status: Can't repeat
• Category: MySQL Server: InnoDB storage engine
• Severity: S1 (Critical)
• Version: 5.0.51
• OS: Linux
• Assigned to: Heikki Tuuri
• CPU Architecture: Any
• Tags: got singal11, InnoDB: Assertion failure in thread, space object doesnot exist

[20 May 2008 12:24] kris dba

Description:
Hi,
we are using mysql5.0.51a-log on redhat linux..
we mainly use Innodb storage engine and have some big tables.
we have 20GB memory and innodb_buffer_cache is set to 12GB.
mysql crashed 4 times and performed crash recovery very quickly.
but there was no backtrace genereated to debug the issue.
issue occured though we dropped the schema involved.

How to repeat:
NA

[20 May 2008 16:43] Heikki Tuuri

Some .ibd files do not match the data dictionary in ibdata1. It complains that the .ibd file has a different space id stamped to it than what is in the data dictionary. And an .ibd file has a wrong size, as InnoDB is trying to access it off the bounds.

If the data in those tables is not valuable, you can resolve the problem by DROPping the corresponding tables and deleting the offending .ibd files, if there still are some after the DROP.

How did you end up in this situation? Disk broke? OS crash? You moved .ibd files around?

Regards,

Heikki

[20 May 2008 21:24] MySQL Verification Team

Setting to feedback for Heikki's last question.

[25 May 2008 7:12] kris dba

Hi,
Is there any update on this.
can anyone please update me on this.

[23 Jun 2008 17:35] Heikki Tuuri

Kris,

How did you end up in this situation? Disk broke? OS crash? You moved .ibd files around?

Regards,

Heikki

[24 Jun 2008 16:59] Heikki Tuuri

Putting to status 'Can't repeat' until we get more similar reports.