You are here

Foreign Key constraint issue -in mysql slave server

Dear friends, Replication stops while updating a row in child table. I am getting 1452 error - Error 'Cannot add or update a child row: a foreign key constraint fails MySQL version in Master server is 5.0.41 MySQL version in Slave server is 5.0.90. I installed MySQL 5.1 and 5.5 tested, in both version also I am receiving the same error. Master Server - Records are available in parent table Slave Server - Records are not available in parent table, so replication stops and getting error - 'Cannot add or update a child row: a foreign key constraint fails. I checked in slave server my.cnf file, binlog_do_db is not mentioned. Kindly help me to solve the replication issue asap, Because this server is critical server.

Dear Kalasha,

We are wondering a bit that you are running your critical servers without a FromDual Support Contract for MySQL! Possibly we have to talk with your managers about it?

Please let us know asap where we can send our invoice for our FromDual support services to... You can reach us asap via contact@fromdual.com for letting us know.

Regards,
Oli

olicomment