(mysql.info) innodb-error-codes

(mysql.info) innodb-error-handling

(mysql.info) operating-system-error-codes

 
 14.2.15.1 `InnoDB' Error Codes
 ..............................
 
 The following is a non-exhaustive list of common `InnoDB'-specific
 errors that you may encounter, with information about why each occurs
 and how to resolve the problem.
 
    * `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 
      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) innodb-error-handling

(mysql.info) operating-system-error-codes

automatically generated byinfo2html