MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Error 'Cannot delete or update a parent row: a foreign key constraint fails
Posted by: graylog learn
Date: April 13, 2020 01:19AM

HI Team,

As i am new to master/slave replication issue. We are facing the issue on slave server.

Could you please help to resolve this what are prechecks we have to do and how to resolve the issue.



Error 'Cannot delete or update a parent row: a foreign key constraint fails (`XXXX`.`trigger_discovery`, CONSTRAINT `c_trigger_discovery_2` FOREIGN KEY (`parent_triggerid`) REFERENCES `triggers` (`triggerid`))' on query. Default database: 'XXX'. Query: 'DELETE FROM triggers WHERE (triggerid IN ('13627','16433'

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Error 'Cannot delete or update a parent row: a foreign key constraint fails
1967
graylog learn
April 13, 2020 01:19AM
Re: Error 'Cannot delete or update a parent row: a foreign key constraint fails
1081
Peter Brawley
April 13, 2020 07:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.