Pending-sending, waiting eternally .....

Jota

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 !
 
Jota said:
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 !
Click to expand...
# 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
 
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.
 
# try recreating the campaign (even in another customer/group account) and see if it goes
Click to expand...

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
Click to expand...

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
Click to expand...

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 ?
 
Jota said:
What you mean with "DS" ?
Click to expand...
Delivery Server

Jota said:
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 ?
Click to expand...
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:
Jota said:
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.
Click to expand...
Glad it works for you now :)
 
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
 
Jota said:
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
Click to expand...
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.
 
You must log in or register to reply here.
Back
Top