Bug #73659 [RDS 5616] bugfix: when crash on create table , the server may fail to restart

• Submitted: 20 Aug 2014 16:01
• Modified: 24 Feb 2015 9:38
• Reporter: xiaobin lin (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.6
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: crash, CREATE TABLE, fil_validate_single_table_tablespace

[20 Aug 2014 16:01] xiaobin lin

Description:

When create an InnoDB table, If crash happen just after the .ibd is created, the restart followed can will exit(1). This means the server can not service automatically. Unless remove the .frm and .ibd files  or set innodb_force_recovery > 0

How to repeat:
As in the testcase in the patch file.

Suggested fix:
As in the patch file.

[20 Aug 2014 16:02] xiaobin lin

testcase insied acquires the server compiled in debug mode

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: 56_restart_fail_when_crash_on_create.diff (application/octet-stream, text), 3.46 KiB.