#22060: Error with Postgresql persistent connections after DB fail/restart
-------------------------------------+-------------------------------------
Reporter: Connor23 | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.6
(models, ORM) | Keywords: persistent, connection,
Severity: Normal | psycopg2, postgresql, pool, db,
Triage Stage: Unreviewed | database, error, fail
Easy pickings: 0 | Has patch: 0
| UI/UX: 0
-------------------------------------+-------------------------------------
Hi,
When using persistent connections with PostgreSQL if the DB fails or is
restarted Django will return the following error:
{{{
2014-02-15 14:33:07 [24868] [ERROR] Error handling request
Traceback (most recent call last):
File "/srv/webapps/myapp/local/lib/python2.7/site-
packages/gunicorn/workers/sync.py", line 131, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/srv/webapps/myapp/local/lib/python2.7/site-
packages/django/core/handlers/wsgi.py", line 194, in __call__
signals.request_started.send(sender=self.__class__)
File "/srv/webapps/myapp/local/lib/python2.7/site-
packages/django/dispatch/dispatcher.py", line 185, in send
response = receiver(signal=self, sender=sender, **named)
File "/srv/webapps/myapp/local/lib/python2.7/site-
packages/django/db/__init__.py", line 94, in close_old_connections
conn.close_if_unusable_or_obsolete()
File "/srv/webapps/myapp/local/lib/python2.7/site-
packages/django/db/backends/__init__.py", line 462, in
close_if_unusable_or_obsolete
if self.is_usable():
File "/srv/webapps/myapp/local/lib/python2.7/site-
packages/django/db/backends/postgresql_psycopg2/base.py", line 192, in
is_usable
self.connection.cursor().execute("SELECT 1")
InterfaceError: connection already closed
}}}
Not sure if this is Django related or psycopg2 related.
Here are few details about my configuration:
Django==1.6.2
gunicorn==18.0
psycopg2==2.5.2
CONN_MAX_AGE is set to 600
Is this a bug? Any ideas?
--
Ticket URL: <https://code.djangoproject.com/ticket/22060>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/051.55624b5aec5afa449b0325ca99bf96f3%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.
