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) Email Updates:
Status: Verified Impact on me:
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

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.