-
1005 (ER_CANT_CREATE_TABLE)
Cannot create table. If the error message refers to
errno
150, table creation failed because
a foreign key constraint was not correctly formed.
-
1016 (ER_CANT_OPEN_FILE)
Cannot find the InnoDB
table from the
InnoDB
data files, although the
.frm
file for the table exists. See
Section 14.2.17.1, “Troubleshooting InnoDB
Data Dictionary Operations”.
-
1114 (ER_RECORD_FILE_FULL)
InnoDB
has run out of free space in the
tablespace. You should reconfigure the tablespace to add a
new data file.
-
1205 (ER_LOCK_WAIT_TIMEOUT)
Lock wait timeout expired. Transaction was rolled back.
-
1213 (ER_LOCK_DEADLOCK)
Transaction deadlock. You should rerun the transaction.
-
1216 (ER_NO_REFERENCED_ROW)
You are trying to add a row but there is no parent row, and
a foreign key constraint fails. You should add the parent
row first.
-
1217 (ER_ROW_IS_REFERENCED)
You are trying to delete a parent row that has children, and
a foreign key constraint fails. You should delete the
children first.