7.5.13 Error Handling

The error handling in InnoDB is not always the same as specified in the SQL standard. According to SQL-99, any error during an SQL statement should cause the rollback of that statement. InnoDB sometimes rolls back only part of the statement, or the whole transaction. The following list specifies the error handling of InnoDB.

• If you run out of file space in the tablespace, you will get the MySQL 'Table is full' error and InnoDB rolls back the SQL statement.
• A transaction deadlock or a timeout in a lock wait make InnoDB to roll back the whole transaction.
• A duplicate key error only rolls back the insert of that particular row, even in a statement like INSERT INTO ... SELECT .... This will probably change so that the SQL statement will be rolled back if you have not specified the IGNORE option in your statement.
• A 'row too long' error rolls back the SQL statement.
• Other errors are mostly detected by the MySQL layer of code, and they roll back the corresponding SQL statement.

User Comments

It would be nice to comment here that although
InnoDB tables have no max number of keys per
table, you are still limited to 32 indexes when using
InnoDB tables in MySQL.

Add your own comment.