Running send_queued_mail every 60s on Heroku - opens a new db connection every time - maxing out my connections about django-post_office HOT 5 CLOSED

You should cron send_queued_mail management command instead of calling send_queued_mail directly.

python manage.py send_queued_mail

from django-post_office.

Normally I would, but Heroku doesn't support cron jobs.

from django-post_office.

This may not be the most up to date of instructions, but you can try something like this: http://guidovanoorschot.nl/adding-cron-jobs-to-a-django-project-with-heroku-scheduler/

Sent from my phone

On Jan 30, 2014, at 10:04 PM, ldm616 [email protected] wrote:

Normally I would, but Heroku doesn't support cron jobs.

—
Reply to this email directly or view it on GitHub.

from django-post_office.

Thanks. Scheduler works - but the max frequency is once every 5 mins. I
need once every minute.

My pseudo cron job on Heroku using apscheduler works, but it seems to open
a new database connection each time it runs and starts to max out my
connections. I've tried using a database pooler, but that doesn't help.

On Thu, Jan 30, 2014 at 6:22 AM, Selwin Ong [email protected]:

This may not be the most up to date of instructions, but you can try
something like this:
http://guidovanoorschot.nl/adding-cron-jobs-to-a-django-project-with-heroku-scheduler/

Sent from my phone

On Jan 30, 2014, at 10:04 PM, ldm616 [email protected] wrote:

Normally I would, but Heroku doesn't support cron jobs.

Reply to this email directly or view it on GitHub.

Reply to this email directly or view it on GitHubhttps://github.com//issues/45#issuecomment-33691461
.

from django-post_office.

SOLVED.

I read somewhere that Django doesn't close db connections after running management commands. I tweaked my pseudo cron job as follows to explicitly close the db connection after send_queued_mail runs.

...
from django.core.management import call_command
from django import db

@sched.interval_schedule(minutes=1)
def timed_job():
    call_command('send_queued_mail')
    db.close_connection()

...

from django-post_office.