Re: Very odd issue with foreign key constraint failure

[Vesselin Kenashkov]

P.S. we have similar case with an INSERT query too. While the case there is more complex we still suspect error in the storage engine under heavy write load.

P.P.S. actually SHOW ENGINE INNODB STATUS gives different story for the last foreign key error:
REPLACE
INTO guzaba_object_permissions
(
class_id, object_id, object_version, role_id, action_id
)
VALUES
(
0, 0, 0, 0, 0
)
Which means there is a bug in the PHP PDO driver not mysql. It seems there is a case when PDO doesnt properly bind the values.
While it seems the case as long mysql/innodb is concerned is closed I would be glad if someone had this issue before and can share his/hers experience.

Thank you



Edited 1 time(s). Last edit at 10/03/2013 10:03AM by Vesselin Kenashkov.