{"action":"created","issue":{"url":"https://api.github.com/repos/atech/postal/issues/235","repository_url":"https://api.github.com/repos/atech/postal","labels_url":"https://api.github.com/repos/atech/postal/issues/235/labels{/name}","comments_url":"https://api.github.com/repos/atech/postal/issues/235/comments","events_url":"https://api.github.com/repos/atech/postal/issues/235/events","html_url":"https://github.com/atech/postal/issues/235","id":236711342,"number":235,"title":"Messages stalled","user":{"login":"elfeffe","id":4717507,"avatar_url":"https://avatars2.githubusercontent.com/u/4717507?v=3","gravatar_id":"","url":"https://api.github.com/users/elfeffe","html_url":"https://github.com/elfeffe","followers_url":"https://api.github.com/users/elfeffe/followers","following_url":"https://api.github.com/users/elfeffe/following{/other_user}","gists_url":"https://api.github.com/users/elfeffe/gists{/gist_id}","starred_url":"https://api.github.com/users/elfeffe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elfeffe/subscriptions","organizations_url":"https://api.github.com/users/elfeffe/orgs","repos_url":"https://api.github.com/users/elfeffe/repos","events_url":"https://api.github.com/users/elfeffe/events{/privacy}","received_events_url":"https://api.github.com/users/elfeffe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2017-06-18T09:44:50Z","updated_at":"2017-06-18T15:08:35Z","closed_at":null,"body":"I have sent yesterday a newsletter to 15K people. Some of them had messages from Yahoo that says they temporarily refuse my emails, and that I have to try again in 4hs. That is a normal Anti-SPAM technique. Is not bad at all.\r\n\r\nThe problem is that the emails became stalled, with no option to force to send them or to stop trying (I can not send a email with a Saturday offer, on Sunday).\r\n\r\nToday, I'm sending a new email, and all my emails are stalled together with the ones from yesterday.\r\nThere is no option to force them to go, or it is?\r\n\r\nI restarted Postal, and nothing happens. I got some emails being sent when I wrote `postal auto-upgrade`, then It  sent some emails, but not even a 10%.\r\n\r\nI had some errors like this one, in worker.log\r\n\r\n`ActiveRecord::ConnectionTimeoutError: could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use`\r\n\r\nIt begun to working with a 2 CPU server, and now I changed it for a 4 CPU one. After that it begun to send, I don't know if when I rebooted it fixed, or what, but now is working. The server reboots when has to change from 2 CPU to 4 CPU.\r\n\r\nThe problem is that we need a window of time to send the emails, we can not send them 3 days after the promo. \r\nIs there any way to adjust the retry time? I mean, retry only after 4 hours. In that way we can retry maximum 3 times and it is 12hs.\r\n\r\nAnd, is there any way to force sending? They are there, with a pending status, and we can't do nothing. Is a bit maddening.\r\n\r\nThank you in advance for your great software and your support (this is not my first issue)."},"comment":{"url":"https://api.github.com/repos/atech/postal/issues/comments/309283139","html_url":"https://github.com/atech/postal/issues/235#issuecomment-309283139","issue_url":"https://api.github.com/repos/atech/postal/issues/235","id":309283139,"user":{"login":"adamcooke","id":4765,"avatar_url":"https://avatars3.githubusercontent.com/u/4765?v=3","gravatar_id":"","url":"https://api.github.com/users/adamcooke","html_url":"https://github.com/adamcooke","followers_url":"https://api.github.com/users/adamcooke/followers","following_url":"https://api.github.com/users/adamcooke/following{/other_user}","gists_url":"https://api.github.com/users/adamcooke/gists{/gist_id}","starred_url":"https://api.github.com/users/adamcooke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adamcooke/subscriptions","organizations_url":"https://api.github.com/users/adamcooke/orgs","repos_url":"https://api.github.com/users/adamcooke/repos","events_url":"https://api.github.com/users/adamcooke/events{/privacy}","received_events_url":"https://api.github.com/users/adamcooke/received_events","type":"User","site_admin":false},"created_at":"2017-06-18T15:08:35Z","updated_at":"2017-06-18T15:08:35Z","body":"40 threads?  Have you updated your database pool size?\r\n\r\nCheck `main_db.pool_size` and make sure it is higher than the maximum number of threads on your worker."}}
{"actor":{"display_login":"adamcooke"}}