# Integrity constraint violation: 1452 Cannot add or update a child row

**URL:** <https://forum.mautic.org/t/integrity-constraint-violation-1452-cannot-add-or-update-a-child-row/34784>\
**Category:** Product Support\
**Created:** [January 18, 2025, 9:41am UTC](https://forum.mautic.org/t/integrity-constraint-violation-1452-cannot-add-or-update-a-child-row/34784 "2025-01-18T09:41:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sradford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/sradford/32/10465_2.png) [@sradford](https://forum.mautic.org/u/sradford)\
**Post date:** [January 18, 2025, 9:41am UTC](https://forum.mautic.org/t/integrity-constraint-violation-1452-cannot-add-or-update-a-child-row/34784/1 "2025-01-18T09:41:15Z")

</div>

**Your software**  
My Mautic version is: 5.2.1  
My PHP version is: 8.3.15  
My Database type and version is: 11.4.4

**Your problem**

My mautic\_prod-xxx.php log file is filling up with an Integrity constraint violation. Happening at least every minute (and sometimes every ~10 seconds). Any pointers on what might be causing it, or how to track down the issue?

[2025-01-18T09:27:17.966586+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException: “An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`mauticdb`.`lead_lists_leads`, CONSTRAINT `FK_F5F47C7C55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE)” at /opt/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 56 {“exception”:“[object] (Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException(code: 1452): An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`mauticdb`.`lead_lists_leads`, CONSTRAINT `FK_F5F47C7C55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE) at /opt/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:56)\n[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1452): SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`mauticdb`.`lead_lists_leads`, CONSTRAINT `FK_F5F47C7C55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE) at /opt/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`mauticdb`.`lead_lists_leads`, CONSTRAINT `FK_F5F47C7C55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE) at /opt/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)”} {“hostname”:“mautic”,“pid”:5997}

Regards