MySQL Foreign Key Constraint Failure

When deleting a row from a table, MySQL might give a foreign key constraint failure. To find out what is the problem one can execute the following command:

SHOW INNODB STATUS;