V11 can't suspend nor resume email queue

deatram · January 30, 2019, 6:04pm

Hello team,
There used to be an option to Suspend and Resume email queue

Now I don’t see it anymore.

Has that option been moved to somewhere else or is it a bug?
meanwhile, my I had suspended my email queue before the update which means I can’t resume it since the option isn’t available.

Installed Apps
ERPNext: v11.1.2 (master)
Frappe Framework: v11.1.2 (master)

Thanks

deatram · January 31, 2019, 3:18am

help anyone

deatram · February 5, 2019, 12:58pm

Still to find a solution.
Now running
ERPNext: v11.1.4 (master)
Frappe Framework: v11.1.4 (master)

Julian_Robbins · February 5, 2019, 3:18pm

I think you can pause individual emails still within the email queue but I appreciate this isn’t what you requested

deatram · February 6, 2019, 9:25am

My email queue is already paused before the updates, I just want to resume the entire email queue,
For now I go to individual emails in the email queue and send it from there.

As you can imagine it’s quite a hustle, because I’m not available all the time to check the email queue
Was hoping to resume the entire queue, also be able to pause it again next time when I want to
Thanks

Himanshu_Mishra · February 6, 2019, 4:46pm

Login via administrator, and go to JavaScript console. There, paste following to send all pending emails

frappe.db.get_list('Email Queue', {filters:{'status':'Not Sent'}, limit:100000000}).then(async res => {
	for(let i of res){
		console.log('Sending', i.name);
		await frappe.call('frappe.email.doctype.email_queue.email_queue.send_now', {
			name: i.name,
		});
	}
});

lcmartinez · April 7, 2019, 4:53pm

Hello, what happened with this button?

I have used it a lot in the local instances also en staging instances to avoid email sending.

Can I enable it again?

Thanks

lasalesi · July 10, 2019, 6:27am

Dear colleagues,

we have the same issue in v11: email queue is suspended after update and mails have to be triggered manually, the button is missing. Any fix in sight?

Another workaround seems to be to run this from the browser console (as System Manager):

 frappe.defaults.set_default("hold_queue", 0);

Note: the above command does not resolve the issue.

lasalesi · July 17, 2019, 8:11am

Any update on this? We still have in v10

and in v11:

and therefore no way of resuming a paused email queue…

lasalesi · July 18, 2019, 2:36pm

This is only a very nasty workaround for this issue… Create a cronjob that runs

$ bench execute frappe.email.queue.flush

so for every minute:

$ sudo crontab -e
* * * * * cd /home/frappe/frappe-bench && bench execute frappe.email.queue.flush

(can actually be used to speed up the mail sending queue ) Still looking for a proper solution…

lams · July 26, 2019, 1:22pm

Thank you!

This really helped me cos I’ve been having this issue and it’s frustrating. Hopefully we see a proper fix somewhere around

flexy2ky · July 26, 2019, 2:50pm

FYI: This has been returned in V12.

lasalesi · September 9, 2019, 6:30pm

Thanks @flexy2ky, the button is there. But in an affected system, it has no effect whatsoever… still wondering if there is no proper solution around, why does the queue hang?