"InnoDB: Serious error! InnoDB is trying to free page though it is already marked as free in the tablespace! Assertion failure in thread in file fsp0fsp.c line mysqld got signal 11" in MySQL Error Log (Doc ID 1330371.1)

Last updated on DECEMBER 28, 2016

Applies to:

MySQL Server - Version 5.1 and later
Information in this document applies to any platform.
Checked for relevance on 07-Feb-2013

Symptoms

MySQL fails to restart with working InnoDB storage engine and you see errors like this in the MySQL error log file:


InnoDB: Serious error! InnoDB is trying to free page 11200
InnoDB: though it is already marked as free in the tablespace!
InnoDB: Assertion failure in thread 16363778 in file fsp0fsp.c line 2981
mysqld got signal 11 ;


The page number and thread number will be different. The line in the fsp0fsp.c source code file may also be different but the file will be the same.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms