Any idea about this sql query running every second

Product Support
1

Your software
My Mautic version is: 4.4.1
My PHP version is: 7.4
My Database type and version is:

Your problem
My problem is:

Our DB is eating all CPU, so I ran slow query log and see this query every second… any idea what it is

SELECT l.* FROM leads l WHERE l.email = 'undefined';
# Time: 221211 13:19:00
# User@Host: mauticuser[mauticeuser] @ localhost []
# Thread_id: 116984  Schema: ams  QC_hit: No
# Query_time: 3.508129  Lock_time: 0.000036  Rows_sent: 0  Rows_examined: 2330209
# Rows_affected: 0  Bytes_sent: 2647

These errors are showing in the log:

Steps I have tried to fix the problem:

2

Hi mikeq

Sounds like a loop in one of the cron commands. I would try to disable the cronjobs and then execute each commands on the shell and looking for strange behaviour (like never ending commands).

Greetings
Sebastian