Held messages #239

elfeffe · 2017-06-20T10:36:20Z

I think there is no sense to held messages for one month, the world can end in one month.
Is there any way to auto clean held messages?

iammattmartin · 2017-06-20T16:04:03Z

This is more user preference than a wide logic.

Some would argue it is better to have the message sent than not at all. We have broadband customers who decide to host their own mail server and due to fault/outage/power/whatever, their service could be broken and a repair could take time - I know for them, they'd not want to lose email.

elfeffe · 2017-06-20T16:15:50Z

I understand.
But at least any interface (or setting) to handle it will be great.
We can't delete held messages.

elfeffe · 2017-06-22T14:14:14Z

Yes, the problem is that we have more than 500 held messages :)

ravimantri · 2017-07-05T22:02:08Z

Issue I've about 100K emails stuck with status "held". So the main thing is how can I delete all emails or force all to deliver?

adamcooke · 2017-07-06T09:42:49Z

If you have a lot of held outgoing messages, you can use the console to put them all back into your message queue and have them resend.

postal console

Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

adamcooke · 2017-07-06T10:00:03Z

I've added two issues to assist with these issues. #257 and #256

ravimantri · 2017-07-13T12:08:26Z

@catphish @adamcooke, It' very urgent! How can I delete the held list (100K) all at once?

Looking for your help. Thanks

vady112 · 2017-07-19T13:47:21Z

NoMethodError: undefined method `message_db' for nil:NilClass
	from (irb):1
	from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console.rb:65:in `start'
	from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console_helper.rb:9:in `start'
	from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:78:in `console'
	from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:49:in `run_command!'
	from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands.rb:18:in `<top (required)>'
	from bin/rails:4:in `require'
	from bin/rails:4:in `<main>'
irb(main):002:0>

Getting this error what am I doing wrong?

adamcooke · 2017-07-19T14:02:11Z

You've entered the server name and/or organization name incorrectly.

vady1 · 2017-07-24T10:37:28Z

Thank you for reply. From where will I get server name?

ravimantri · 2017-07-27T08:40:01Z

Dear @adamcooke by running "Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }". Ihad changed the Server Name.

I get "NoMethodError: undefined method `message_db' for nil:NilClass"

What to do? My all emails are stuck in held, nothing processing.

Thanks

adamcooke · 2017-07-27T08:40:27Z

You've entered the server name and/or organization name incorrectly.

ravimantri · 2017-07-27T08:41:37Z

Thanks for your prompt reply. I actually used:

Server['gupta-publications/smtp-1'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

adamcooke · 2017-07-27T08:43:02Z

You can get the correct org & server names from the URL in the web interface. I'd suggest that gupta-publications/smtp-1 is wrong.

ravimantri · 2017-07-27T08:44:14Z

This is the Postal Interface I access: https://postal.domain.com/org/gupta-publications/servers/smtp-1

What to do?

adamcooke · 2017-07-27T09:01:33Z

You can try to get the server

server = Organization.find_by_permalink('org-name').servers.find_by_permalink('smtp-1')
server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { \|m\| m.add_to_message_queue(:manual => true) }

ravimantri · 2017-07-27T09:05:48Z

irb(main):004:0> server = Organization.find_by_permalink('gupta-publications').servers.find_by_permalink('smtp-1')
=> #<Server id: 1, organization_id: 1, uuid: "673f939a-b43b-4b7d-87a6-6a572cda6034", name: "SMTP - 1", mode: "Live", ip_pool_id: nil, created_at: "2017-07-26 14:35:51", updated_at: "2017-07-27 08:42:53", permalink: "smtp-1", send_limit: 100, deleted_at: nil, message_retention_days: 2, raw_message_retention_days: 1, raw_message_retention_size: 512, allow_sender: false, token: "uato7r", send_limit_approaching_at: nil, send_limit_approaching_notified_at: nil, send_limit_exceeded_at: nil, send_limit_exceeded_notified_at: nil, spam_threshold: #BigDecimal:7cb1310,'0.5E1',9(18), spam_failure_threshold: #BigDecimal:7cb11d0,'0.2E2',9(18), postmaster_address: nil, suspended_at: nil, outbound_spam_threshold: nil, domains_not_to_click_track: nil, suspension_reason: nil, log_smtp_data: false>

irb(main):005:0> server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }
SyntaxError: (irb):5: syntax error, unexpected $undefined
...:scope => 'outgoing'}).each { |m| m.add_to_message_queue(:...
... ^
from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console.rb:65:in start' from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console_helper.rb:9:in start'
from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:78:in console' from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:49:in run_command!'
from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands.rb:18:in <top (required)>' from bin/rails:4:in require'
from bin/rails:4:in `

'

ravimantri · 2017-07-27T12:36:47Z

@adamcooke, anymore suggestions? Thanks

chocochrispi · 2017-10-10T11:41:47Z

It worked for me, thanks!

influenist · 2018-01-18T23:36:46Z

Any option to delete the held queue by console? I see here only options to re-add them to the queue.

Thanks!

PureMSP · 2018-03-28T17:40:34Z

Doesn't work for me neither.!

NoMethodError: undefined method `servers' for nil:NilClass
        from (irb):1
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console.rb:65:in `start'
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/console_helper.rb:9:in `start'
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:78:in `console'
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands/commands_tasks.rb:49:in `run_command!'
        from /opt/postal/vendor/bundle/ruby/2.3.0/gems/railties-5.0.2/lib/rails/commands.rb:18:in `<top (required)>'
        from bin/rails:4:in `require'
        from bin/rails:4:in `<main>'

No matter what I try!

adamcooke · 2018-03-28T17:55:30Z

You're getting the organization name wrong if you're getting that error.

hadifarnoud · 2018-06-20T14:23:58Z

what if I want to cancel them all @adamcooke ? can you post the query for that too?

Humblr · 2018-12-16T12:26:56Z

Can we do the same for Hard Failed and bounced emails?
Got a few thousand that hard failed as our IP got blocked for a few days.

njolin · 2019-04-16T20:29:54Z

@adamcooke can you shed some light on how to delete the held messages using the console please? Thanks!

lovelyns · 2019-05-22T07:09:41Z

If you have a lot of held outgoing messages, you can use the console to put them all back into your message queue and have them resend.
postal console
Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

Hello @adamcooke
please how do i get message_db ?

lovelyns · 2019-05-22T07:13:31Z

If you have a lot of held outgoing messages, you can use the console to put them all back into your message queue and have them resend.
postal console
Server['org-name/server-name'].message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }
Hello @adamcooke
please how do i get message_db ?

I am getting the below error @adamcooke please help
NoMethodError: undefined method `message_db' for nil:NilClass

willpower232 · 2019-05-22T08:25:04Z

This is answered above

You've entered the server name and/or organization name incorrectly.

lovelyns · 2019-05-22T13:43:30Z

Thanks @willpower232

Am I still on track?

I got the below result;

=> #<Server id: 1, organization_id: 1, uuid: "25d927cc-d369-413a-bd80-5468c20db4b1", name: "Mail Server 1", mode: "Live", ip_pool_id: nil, created_at: "2019-04-17 13:16:51", updated_at: "2019-05-10 13:49:45", permalink: "mail-server-1", send_limit: nil, deleted_at: nil, message_retention_days: 60, raw_message_retention_days: 30, raw_message_retention_size: 2048, allow_sender: true, token: "vchvvr", send_limit_approaching_at: nil, send_limit_approaching_notified_at: nil, send_limit_exceeded_at: nil, send_limit_exceeded_notified_at: nil, spam_threshold: #BigDecimal:6e4ea20,'0.5E1',9(18), spam_failure_threshold: #BigDecimal:6e4e908,'0.2E2',9(18), postmaster_address: nil, suspended_at: nil, outbound_spam_threshold: nil, domains_not_to_click_track: nil, suspension_reason: nil, log_smtp_data: true>
irb(main):002:0> server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

lovelyns · 2019-05-23T08:26:56Z

It worked for me, thanks!

Hi @chocochrispi
Could you please guide me on how you were able to get this done if my org name is matter and my server name is mail-server-10 ?

chocochrispi · 2019-05-23T08:46:23Z

It worked for me, thanks!

Hi @chocochrispi
Could you please guide me on how you were able to get this done if my org name is matter and my server name is mail-server-10 ?

server = Organization.find_by_permalink('matter').servers.find_by_permalink('mail-server-10')
server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

lovelyns · 2019-05-23T13:12:18Z

It worked for me, thanks!

Hi @chocochrispi
Could you please guide me on how you were able to get this done if my org name is matter and my server name is mail-server-10 ?

server = Organization.find_by_permalink('matter').servers.find_by_permalink('mail-server-10')
server.message_db.messages(:where => {:held => 1, :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

Thanks a million @chocochrispi it works

udiffy · 2023-05-19T13:07:46Z

Not work for version 2.1.4
How move all bounced messages to Queue from postal console?

pjv · 2024-03-04T13:48:47Z

Here’s how to re-send all the hard fails:

postal console

Server['organization/server’].message_db.messages(:where => {:status => 'HardFail', :scope => 'outgoing'}).each { |m| m.add_to_message_queue(:manual => true) }

NOTE: you have to know what your organization and server are.

iammattmartin mentioned this issue Jul 5, 2017

How to bulk force messages that are stuck in queue to release now? #252

Closed

adamcooke closed this as completed Jul 6, 2017

influenist mentioned this issue Jan 18, 2018

Remove Held messages, not release or re-add them to queue #469

Closed

willpower232 mentioned this issue Jan 22, 2021

Mass resend of emails #1286

Closed

bigon mentioned this issue Apr 28, 2022

Retry mails that were held when address is removed from the suppression list #1973

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Held messages #239

Held messages #239

elfeffe commented Jun 20, 2017

iammattmartin commented Jun 20, 2017

elfeffe commented Jun 20, 2017

elfeffe commented Jun 22, 2017 via email •

edited

ravimantri commented Jul 5, 2017

adamcooke commented Jul 6, 2017 •

edited

adamcooke commented Jul 6, 2017

ravimantri commented Jul 13, 2017

vady112 commented Jul 19, 2017 •

edited

adamcooke commented Jul 19, 2017

vady1 commented Jul 24, 2017 •

edited

ravimantri commented Jul 27, 2017 •

edited

adamcooke commented Jul 27, 2017

ravimantri commented Jul 27, 2017

adamcooke commented Jul 27, 2017

ravimantri commented Jul 27, 2017 •

edited

adamcooke commented Jul 27, 2017 •

edited

ravimantri commented Jul 27, 2017

ravimantri commented Jul 27, 2017

chocochrispi commented Oct 10, 2017 •

edited

influenist commented Jan 18, 2018

PureMSP commented Mar 28, 2018

adamcooke commented Mar 28, 2018

hadifarnoud commented Jun 20, 2018

Humblr commented Dec 16, 2018

njolin commented Apr 16, 2019

lovelyns commented May 22, 2019

lovelyns commented May 22, 2019

willpower232 commented May 22, 2019

lovelyns commented May 22, 2019

lovelyns commented May 23, 2019

chocochrispi commented May 23, 2019 •

edited

lovelyns commented May 23, 2019

udiffy commented May 19, 2023

pjv commented Mar 4, 2024

Held messages #239

Held messages #239

Comments

elfeffe commented Jun 20, 2017

iammattmartin commented Jun 20, 2017

elfeffe commented Jun 20, 2017

elfeffe commented Jun 22, 2017 via email • edited

ravimantri commented Jul 5, 2017

adamcooke commented Jul 6, 2017 • edited

adamcooke commented Jul 6, 2017

ravimantri commented Jul 13, 2017

vady112 commented Jul 19, 2017 • edited

adamcooke commented Jul 19, 2017

vady1 commented Jul 24, 2017 • edited

ravimantri commented Jul 27, 2017 • edited

adamcooke commented Jul 27, 2017

ravimantri commented Jul 27, 2017

adamcooke commented Jul 27, 2017

ravimantri commented Jul 27, 2017 • edited

adamcooke commented Jul 27, 2017 • edited

ravimantri commented Jul 27, 2017

ravimantri commented Jul 27, 2017

chocochrispi commented Oct 10, 2017 • edited

influenist commented Jan 18, 2018

PureMSP commented Mar 28, 2018

adamcooke commented Mar 28, 2018

hadifarnoud commented Jun 20, 2018

Humblr commented Dec 16, 2018

njolin commented Apr 16, 2019

lovelyns commented May 22, 2019

lovelyns commented May 22, 2019

willpower232 commented May 22, 2019

lovelyns commented May 22, 2019

lovelyns commented May 23, 2019

chocochrispi commented May 23, 2019 • edited

lovelyns commented May 23, 2019

udiffy commented May 19, 2023

pjv commented Mar 4, 2024

elfeffe commented Jun 22, 2017 via email •

edited

adamcooke commented Jul 6, 2017 •

edited

vady112 commented Jul 19, 2017 •

edited

vady1 commented Jul 24, 2017 •

edited

ravimantri commented Jul 27, 2017 •

edited

ravimantri commented Jul 27, 2017 •

edited

adamcooke commented Jul 27, 2017 •

edited

chocochrispi commented Oct 10, 2017 •

edited

chocochrispi commented May 23, 2019 •

edited