Django python-rq -- DatabaseError SSL error: decryption failed or bad record mac

django postgresql heroku python-rq
fangsterr picture fangsterr · Jul 8, 2013 · Viewed 7.1k times · Source

I'm using the django-redis and django_rq frameworks to support both redis caching and redis background task processing for my Django application on Heroku. It's worked smoothly in the past, however now I keep getting a DatabaseError SSL error: decryption failed or bad record mac every time one of my jobs get run.

I read that this error occurs commonly with Postgres in the https://devcenter.heroku.com/articles/postgres-logs-errors article, but it hasn't really been giving me anything useful for my python setup.

Answer

fangsterr picture fangsterr · Jul 8, 2013

The problem is solved by closing the DB connection at the beginning of each job.

For example,

@job
some_job():
    from django.db import connection
    connection.close()
    some_more_code()

Related questions

heroku, postgreSQL, django, comments, tastypie: No operator matches the given name and argument type(s). You might need to add explicit type casts

I have a simple query on django's built in comments model and getting the error below with heroku's postgreSQL database: DatabaseError: operator does not exist: integer = text LINE 1: ... INNER JOIN "django_comments" ON ("pi ns_pin"."id" = "django_... ^ HINT: No …

Read More
Error: could not determine PostgreSQL version from '10.3' - Django on Heroku

I tried to push from local env to Heroku master. No new requirements from the previous commit. However, I received an Error which saying the system could not determine PostgreSQL version from "10.3". Here is my requirements list: amqp==1.4.9 anyjson==0.3.3 appdirs==1.4.3 …

Read More
Trouble getting Django set up on Heroku using South - keep getting ProgrammingError: relation does not exist

This is what I've been doing: Locally - where I've got a brand new postgres database, and two models.py files from two different apps: python manage.py syncdb python manage.py schemamigration api --initial python manage.py schemamigration extapi …

Read More