Pending-sending, waiting eternally .....

Jota

Member
Well, I get this problem just in some cases with one domain. Let's call it domain1.com

When I try to send campaigns, with domain1.com, I get stuck with "Pending-sending" typical error.

Otherwise, with user domain2.com it works perfectly.

Is not a cron issue, I already checked, also, I check from console here:

Code:
[root@srv4 /]# /usr/local/bin/php -q /home/mailwizz/public_html/apps/console/console.php send-campaigns --verbose
[2017-11-07 18:36:52] - Loading 5 campaigns, starting with offset 0...
[2017-11-07 18:36:52] - No campaign found, stopping.
[2017-11-07 18:36:52] - This cycle completed in 0.02 seconds and used 2 MB of memory!
[2017-11-07 18:36:52] - CPU usage in last minute: 0.96, in last 5 minutes: 0.89, in last 15 minutes: 0.73!
But I still see the "Pending-sending". Sometimes it's been sent after hours, or just never .....

Also, while waiting campaign for being sent, same domain has a forum using same SMTP account working perfectly and instantly. Also I test SMTP account from local client and some WP sites, all works like a charm.

What may be happening ? I'm so confused ! spent so many hours in to this !

I'm going nuts !

PLz help !
 

frm.mwz

Well-Known Member
Well, I get this problem just in some cases with one domain. Let's call it domain1.com

When I try to send campaigns, with domain1.com, I get stuck with "Pending-sending" typical error.

Otherwise, with user domain2.com it works perfectly.

Is not a cron issue, I already checked, also, I check from console here:

Code:
[root@srv4 /]# /usr/local/bin/php -q /home/mailwizz/public_html/apps/console/console.php send-campaigns --verbose
[2017-11-07 18:36:52] - Loading 5 campaigns, starting with offset 0...
[2017-11-07 18:36:52] - No campaign found, stopping.
[2017-11-07 18:36:52] - This cycle completed in 0.02 seconds and used 2 MB of memory!
[2017-11-07 18:36:52] - CPU usage in last minute: 0.96, in last 5 minutes: 0.89, in last 15 minutes: 0.73!
But I still see the "Pending-sending". Sometimes it's been sent after hours, or just never .....

Also, while waiting campaign for being sent, same domain has a forum using same SMTP account working perfectly and instantly. Also I test SMTP account from local client and some WP sites, all works like a charm.

What may be happening ? I'm so confused ! spent so many hours in to this !

I'm going nuts !

PLz help !
# try recreating the campaign (even in another customer/group account) and see if it goes
# see if sending domain and DS locked to customer without sufficient quota/rights
# perhaps your database has some rare inconsistency, then repair it in phpMyAdmin
 

twisted1919

Administrator
Staff member
And maybe the scheduled time is not the correct one, try to set it in the past, like one day ago and see how that works.
 

Jota

Member
# try recreating the campaign (even in another customer/group account) and see if it goes
I did, sent another campaign using client2 and campaign was sent instantly and successfully.

Code:
[root@l1 /]# /usr/local/bin/php -q /home/mailwizz/public_html/apps/console/console.php send-campaigns --verbose
[2017-11-07 19:56:49] - Loading 5 campaigns, starting with offset 0...
[2017-11-07 19:56:49] - Found 1 campaigns and now starting processing them...
[2017-11-07 19:56:49] - Campaign Worker #0 looking into the campaign with ID: 13
[2017-11-07 19:56:49] - This campaign belongs to ****** ****(uid: xy1270gbk5a27).
[2017-11-07 19:56:49] - Changing the campaign status into PROCESSING!
[2017-11-07 19:56:49] - Looking for subscribers for campaign with uid wl838n2k20c3b...(This is subscribers worker #0)
[2017-11-07 19:56:49] - This subscribers worker(#0) will process 1 subscribers for this campaign...
[2017-11-07 19:56:49] - Running subscribers cleanup...
[2017-11-07 19:56:49] - Checking subscribers count after cleanup: 1
[2017-11-07 19:56:49] - Sorting the subscribers...
[2017-11-07 19:56:49] - Entering the foreach processing loop for all 1 subscribers...

[2017-11-07 19:56:49] - web-****@mail-tester.com - 1/1
[2017-11-07 19:56:49] - Checking if we can send to domain of web-****@mail-tester.com...
[2017-11-07 19:56:49] - Checking if web-****@mail-tester.com is blacklisted...
[2017-11-07 19:56:49] - Checking if the server is over quota...
[2017-11-07 19:56:49] - Preparing the entire email...
[2017-11-07 19:56:49] - Using delivery server: talk.secondmailer.com (ID: 2).
[2017-11-07 19:56:50] - Sending response is: OK
[2017-11-07 19:56:50] - Sending OK.
[2017-11-07 19:56:50] - Done for web-****@mail-tester.com, logging delivery...

[2017-11-07 19:56:50] - Done processing 1 subscribers!
[2017-11-07 19:56:50] - Campaign has been marked as sent!
[2017-11-07 19:56:50] - This cycle completed in 1.27 seconds and used 8 MB of memory!
[2017-11-07 19:56:50] - CPU usage in last minute: 0.43, in last 5 minutes: 0.70, in last 15 minutes: 0.84!
# see if sending domain and DS locked to customer without sufficient quota/rights
I didn't apply any limits anywhere, all -1 or just unlimited. What you mean with "DS" ?

I'm also using a new clean MailWizz system installed on a different directory, same problems than my main mailwizz install full of accounts and tests.

# perhaps your database has some rare inconsistency, then repair it in phpMyAdmin
Well, since I'm testing on 2 different installs, do you really think is the same SQL error happening simultaneously on 2 different installs and DBs ?
 

frm.mwz

Well-Known Member
What you mean with "DS" ?
Delivery Server

Well, since I'm testing on 2 different installs, do you really think is the same SQL error happening simultaneously on 2 different installs and DBs ?
No. But I did not see this info about a second install in your first post.
Only afterward it was revealed by you, see here:
I'm also using a new clean MailWizz system installed on a different directory, same problems than my main mailwizz install full of accounts and tests.
Glad it works for you now :)
 

Jota

Member
Okay, so what's wrong ? Client1 was sending the default campaign on its local time, 4h of difference (GMT -3), but local system time is GMT+1. How to avoid this ? Shall I setup all customers using local server time instead of client's time to avoid this problem ?

Thanks
 

frm.mwz

Well-Known Member
Okay, so what's wrong ? Client1 was sending the default campaign on its local time, 4h of difference (GMT -3), but local system time is GMT+1. How to avoid this ? Shall I setup all customers using local server time instead of client's time to avoid this problem ?

Thanks
It should work fine if you put the server time (hwclock/date/OS) to UTC, and the user/customer time as it is for them locally. That's how it works for me at least.
 
Top