Hi all,

I have created a newsletter and I want to send it to around 2200 subscribers.

Before launching my newsletter I sent a test to my mail address and I delivered the newsletter without problem.

The problem that I face is:

When I send the newsletter to all the subscribers in the first CRON run it sends properly the first batch (around 300 mails but i have set to send 1000 each time). Afterwards I wait the next CRON run to send the remaining batches but nothing happens. I checked in the database in the simplenews_mail_spool table and the remaining emails have status with value 3. Does anyone know what the value 3 mean? Because in the status column only 3 values are appropriate (0,1,2). I was expecting the remaining emails to have value 1 which means pending but as I said they have status value 3. As a temporary solution I changed the status in the emails from 3 to 1 manually and I ran CRON manually. It managed to send again a batch of around 400 mails but again the status of the remaining emails in the simplenews_mail_spool became 3. I repeated the same procedure (changing the status value from 3 to 1) several times and I managed to send around 1600.

Now I have around 600 emails in the spool and when I try the same procedure nothing happens. It seems that simplenews doesn't run at all when CRON runs but it changes the status in the simplenews_mail_spool from 1 to 3 without sending any of them.

Anyone who has faced similar problem? I checked around the internet but I didn't find anything why the status takes the value of 3.

Some notes:

1) All my manually CRON runs were every 1hour minimum.
2) I installed the ultimate cron module to see if anything strange happens when simplenews is launched but the only message that i receive is that simplenews launched manually without any further information.
3) Last but not least, when I change now the value from 3 to 1 and then run CRON manually it seems that CRON "freezes". It loads for few (1,2 )secs and then appears a white page. I check in the reports but doesn't seem that simplenews run at all but on the other hand the status in database changing again from 1 to 3 without sending any email.

Thanks in advance!

Comments

garyg’s picture

I have this problem also.

" It seems that simplenews doesn't run at all when CRON runs but it changes the status in the simplenews_mail_spool from 1 to 3 without sending any of them."

Anybody?

miro_dietiker’s picture

Issue tags: -simplenews_mail_spool status : 3

Simplenews acquires a chunk of recipients in simplenews_get_spool() with a lock and sets them to SIMPLENEWS_SPOOL_IN_PROGRESS (value 3).

This is called by simplenews_mail_spool(), the manager the then generates the mails in question and sends them to the recipients.

In case things lock, it needs a full day to expire the lock acquisition and then a next try happens.

The protection against execution time overrun only checks every 100 mails. So it seems this is not triggered for you.

rob3000’s picture

@miro_dietiker is there a way that we can change the lock to expire earlier than a day?