(mysql.info.gz) InnoDB error codes

Info Catalog

(mysql.info.gz) InnoDB Error handling

(mysql.info.gz) InnoDB Error handling

(mysql.info.gz) Operating System error codes

 
 15.16.1 `InnoDB' Error Codes
 ----------------------------
 
 The following is a non-exhaustive list of common `InnoDB'-specific
 errors that you may encounter, with information about why they occur
 and how to resolve the problem.
 
 `1005 (`ER_CANT_CREATE_TABLE')'
      Cannot create table. If the error message string 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 though
      the `.frm' file for the table exists.   InnoDB
      troubleshooting datadict.
 
 `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.
 

Info Catalog

(mysql.info.gz) InnoDB Error handling

(mysql.info.gz) InnoDB Error handling

(mysql.info.gz) Operating System error codes