# Cannot delete or update a parent row: a foreign key constraint fails

**URL:** <https://forums.percona.com/t/cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails/16748>\
**Category:** Other MySQL® Questions\
**Tags:** mysql, percona\
**Created:** [July 26, 2022, 5:47am UTC](https://forums.percona.com/t/cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails/16748 "2022-07-26T05:47:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![liuwenfeng](https://avatars.discourse-cdn.com/v4/letter/l/a587f6/32.png) [@liuwenfeng](https://forums.percona.com/u/liuwenfeng)\
**Post date:** [July 26, 2022, 5:47am UTC](https://forums.percona.com/t/cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails/16748/1 "2022-07-26T05:47:35Z")

</div>

How do we solve this problem?

SET FOREIGN\_KEY\_CHECKS = 0; — invalid

 ![QQ截图20220726134921](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/4/4393a3673ef24253607858e7e71fe2bf9395aa41.jpeg)

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 26, 2022, 12:31pm UTC](https://forums.percona.com/t/cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails/16748/2 "2022-07-26T12:31:58Z")

</div>

Please don’t use screenshots. Copy/paste from terminal and use the formatting tools. Looking at tiny screenshots and attempting to ascertain the problem is difficult.

I don’t see this in your screenshot: `pt-archiver --skip-foreign-key-checks`  
[https://www.percona.com/doc/percona-toolkit/3.0/pt-archiver.html#cmdoption-pt-archiver-skip-foreign-key-checks](https://www.percona.com/doc/percona-toolkit/3.0/pt-archiver.html#cmdoption-pt-archiver-skip-foreign-key-checks)  
[https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar\_foreign\_key\_checks](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_foreign_key_checks)

---

<div class="post-metadata">

**Author:** ![liuwenfeng](https://avatars.discourse-cdn.com/v4/letter/l/a587f6/32.png) [@liuwenfeng](https://forums.percona.com/u/liuwenfeng)\
**Post date:** [July 27, 2022, 1:26am UTC](https://forums.percona.com/t/cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails/16748/3 "2022-07-27T01:26:07Z")

</div>

> [@matthewb](#):
>
> –skip-foreign-key-checks

Thank you. I’ll try.