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

[liuwenfeng]

How do we solve this problem?

SET FOREIGN_KEY_CHECKS = 0; — invalid

[matthewb]

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://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_foreign_key_checks

[liuwenfeng]

@matthewb

–skip-foreign-key-checks

Thank you. I’ll try.