Running send_queued_mail every 60s on Heroku - opens a new db connection every time - maxing out my connections

[ldm616]

Does send_queued_mail close it's db connection when done? Doesn't seem to be. Perhaps it is how I am calling it via a scheduler so it runs every 60s. That file below as an fyi

---

import os
os.environ['DJANGO_SETTINGS_MODULE'] = 'anonqaproject.settings'
import logging
logging.basicConfig()
from apscheduler.scheduler import Scheduler
from post_office import utils
sched = Scheduler()

@sched.interval_schedule(minutes=1)
def timed_job():
utils.send_queued_mail()

sched.start()
while True:

pass

[selwin]

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

python manage.py send_queued_mail

[ldm616]

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

[selwin]

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 notifications@github.com wrote:

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

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

[ldm616]

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 notifications@github.comwrote:

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 notifications@github.com 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
.

[ldm616]

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()

...