Your software
My Mautic version is: 5.2.2
My PHP version is: 8.2.29
My Database type and version is: MariaDB 10.11.11
Your problem
My problem is: ID Spam
These errors are showing in the log:
Around 300k per day.
root@srv1 /var/www/html/test.example.com/var/logs # wc -l mautic_prod-2025-11-18.php
64697 mautic_prod-2025-11-18.php
root@srv1 /var/www/html/test.example.com/var/logs # wc -l mautic_prod-2025-11-18^Chp
root@srv1 /var/www/html/test.example.com/var/logs # wc -l mautic_prod-2025-11-16.php
305428 mautic_prod-2025-11-16.php
root@srv1 /var/www/html/test.example.com/var/logs # wc -l mautic_prod-2025-11-15.php
357606 mautic_prod-2025-11-15.php
root@srv1 /var/www/html/test.example.com/var/logs # wc -l mautic_prod-2025-11-14.php
328108 mautic_prod-2025-11-14.php
root@srv1/var/www/html/test.example.com/var/logs#
[2025-11-18T09:35:19.322776+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\EntityNotFoundException: “Entity of type ‘Mautic\LeadBundle\Entity\Lead’ for IDs id(6058445) was not found” at /var/www/html/test.example.com/vendor/doctrine/orm/src/EntityNotFoundException.php line 33 {“exception”:“[object] (Doctrine\ORM\EntityNotFoundException(code: 0): Entity of type ‘Mautic\LeadBundle\Entity\Lead’ for IDs id(6058445) was not found at /var/www/html/test.example.com/vendor/doctrine/orm/src/EntityNotFoundException.php:33)”} {“hostname”:“test.example.com”,“pid”:3753266}
[2025-11-18T09:35:19.833640+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\EntityNotFoundException: “Entity of type ‘Mautic\LeadBundle\Entity\Lead’ for IDs id(6058445) was not found” at /var/www/html/test.example.com/vendor/doctrine/orm/src/EntityNotFoundException.php line 33 {“exception”:“[object] (Doctrine\ORM\EntityNotFoundException(code: 0): Entity of type ‘Mautic\LeadBundle\Entity\Lead’ for IDs id(6058445) was not found at /var/www/html/test.example.com/vendor/doctrine/orm/src/EntityNotFoundException.php:33)”} {“hostname”:“test.example.com”,“pid”:3753357}
[2025-11-18T09:35:19.854978+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\EntityNotFoundException: “Entity of type ‘Mautic\LeadBundle\Entity\Lead’ for IDs id(14555) was not found” at /var/www/html/test.example.com/vendor/doctrine/orm/src/EntityNotFoundException.php line 33 {“exception”:“[object] (Doctrine\ORM\EntityNotFoundException(code: 0): Entity of type ‘Mautic\LeadBundle\Entity\Lead’ for IDs id(14555) was not found at /var/www/html/test.example.com/vendor/doctrine/orm/src/EntityNotFoundException.php:33)”} {“hostname”:“test.example.com”,“pid”:3753357}
[2025-11-18T09:35:19.951937+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\EntityNotFoundException: “Entity of type ‘Mautic\LeadBundle\Entity\Lead’ for IDs id(14555) was not found” at /var/www/html/test.example.com/vendor/doctrine/orm/src/EntityNotFoundException.php line 33 {“exception”:“[object] (Doctrine\ORM\EntityNotFoundException(code: 0): Entity of type ‘Mautic\LeadBundle\Entity\Lead’ for IDs id(14555) was not found at /var/www/html/test.example.com/vendor/doctrine/orm/src/EntityNotFoundException.php:33)”} {“hostname”:“test.example.com”,“pid”:3753357}
Steps I have tried to fix the problem:
Cleanup all records from the logs that are recorded for a day we have around 50k uniq ID’s that are comming from the logs.
I created a script:
#!/bin/bash
IDFILE=“id.txt”
while read LEAD_ID; do
echo “==========================================”
echo “Deleting records for lead_id: $LEAD_ID”
echo “==========================================”
mysql -u root database <<EOF
SET @lead_idlead_id := $LEAD_ID;
DELETE FROM asset_downloads WHERE lea@lead_id_id = @lead_id;
DELETE FROM campaign_lead_event_log WH@lead_idRE lead_id = @lead_id;
DELETE FROM campaign_l@lead_idads WHERE lead_id = @lead_id;
DELETE FROM comp@lead_idnies_leads WHERE lead_id = @lead_id;
DELETE FROM dynamic@lead_idcontent_lead_data WHERE lead_id = @lead_id;
DELETE F@lead_idOM dynamic_content_stats WHERE lead_id = @@lead_idead_id;
DELETE FROM email_stats WHERE lead@lead_idid = @lead_id;
DELETE FROM focus_stats WHERE le@lead_idd_id = @lead_id;
DELETE FROM form_submissions @lead_idHERE lead_id = @lead_id;
DELETE FROM lead_categories WHE@lead_idE lead_id = @lead_id;
DELETE FROM lead_comp@lead_idnies_change_log WHERE lead_id = @lead_id;
DELETE@lead_idFROM lead_devices WHERE lead_id = @lead_id;
D@lead_idLETE FROM lead_donotcontact WHERE lead_id = @lead_@lead_idd;
DELETE FROM lead_event_log WHERE lead_id @lead_id @lead_id;
DELETE FROM lead_frequencyrules WHER@lead_id lead_id = @lead_id;
DELETE FROM lead_ips@lead_idxref WHERE lead_id = @lead_id;
DELETE FROM lead_lists@lead_idleads WHERE lead_id = @lead_id;
DELETE FROM lead_note@lead_id WHERE lead_id = @lead_id;
DELETE FROM lead_p@lead_idints_change_log WHERE lead_id = @lead_id;
D@lead_idLETE FROM lead_stages_change_log WHERE lead_@lead_idd = @lead_id;
DELETE FROM lead_tags_xref WHERE @lead_idead_id = @lead_id;
DELETE FROM lead_utmt@lead_idgs WHERE lead_id = @lead_id;
DELETE FROM message_qu@lead_idue WHERE lead_id = @lead_id;
DELETE FROM monitoring_@lead_ideads WHERE lead_id = @lead_id;
DELETE FROM page_hit@lead_id WHERE lead_id = @lead_id;
DELETE FROM @lead_idlugin_citrix_events WHERE lead_id = @lead_id;
DELETE F@lead_idOM point_lead_action_log WHERE lead_id = @lead_i@lead_id;
DELETE FROM point_lead_event_log WHERE lead_id = @@lead_idead_id;
DELETE FROM push_ids WHERE lead_id@lead_id= @lead_id;
DELETE FROM push_notification_stats WHERE lead_id = @lead_id;
DELETE FROM sms_message_stats WHERE lead_id = @lead_id;
DELETE FROM stage_lead_action_log WHERE lead_id = @lead_id;
DELETE FROM tweet_stats WHERE lead_id = @lead_id;
DELETE FROM video_hits WHERE lead_id = @lead_id;
EOF
done < “$IDFILE”
root@srv1/var/www/html#tail id.txt
8283561
8283802
8283830
8283875
8283876
8283903
8284351
8284543
8284547
8284773
the Id’s recored in id.txt is only a little part for example.