Error when send email to segments greater than 300 thousand with cron jobs

General Discussion
1

Hello!

I have a segment with 300 thousand people.

When I try to send a segment email (automatically trough cron job) to these people my Mautic crash ( error bellow).

When I try to send the same email, to the same segment but toruhg the “send” button everything runs.

Anyone more have a similar problem?

mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT ch.lead_id, fr.frequency_number, fr.frequency_time FROM ma_email_stats ch LEFT JOIN ma_lead_frequencyrules fr ON ch.lead_id = fr.lead_id WHERE (fr.channel = ? or fr.channel is null) AND ((ch.date_sent >= case fr.frequency_time when 'MONTH' then DATE_SUB(NOW(),INTERVAL 1 MONTH) when 'DAY' then DATE_SUB(NOW(),INTERVAL 1 DAY) when 'WEEK' then DATE_SUB(NOW(),INTERVAL 1 WEEK) end)) AND (ch.lead_id IN (424, 670, 716, 728, 788, 790, 949, 963, 1018, 1151, 1159, 1760....

2

What are you frequency settings for email channel?

Configuration - Email settings - Default Frequency Rule

3

I currently have in email configuration the frequency in 2 a day, but the error continues, NOTE only occurs when there are many contacts in the segment

4

I have the same problem, did you manage to find a solution?

5

I have this problem as well. did you find a solution?