#15802: Django stops functioning when the database (PostgreSQL) closes the
connection
-------------------------------------+-------------------------------------
Reporter: Rick.van.Hattem@… | Owner: aaugustin
Type: Bug | Status: assigned
Component: Database layer | Version: 1.6
(models, ORM) |
Severity: Normal | Resolution:
Keywords: database, postgres, | Triage Stage: Accepted
postgresql, connection, closed |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by baumer1122):
* version: 1.3 => 1.6
Comment:
I'm seeing this in a Django 1.6.8 project served via uWSGI 2.0.9. The
exception is:
{{{
Traceback (most recent call last):
File "/srv/myproject/local/lib/python2.7/site-
packages/django/core/handlers/wsgi.py", line 194, in __call__
signals.request_started.send(sender=self.__class__)
File "/srv/myproject/local/lib/python2.7/site-
packages/django/dispatch/dispatcher.py", line 185, in send
response = receiver(signal=self, sender=sender, **named)
File "/srv/myproject/local/lib/python2.7/site-
packages/django/db/__init__.py", line 91, in close_old_connections
conn.abort()
File "/srv/myproject/local/lib/python2.7/site-
packages/django/db/backends/__init__.py", line 381, in abort
self.rollback()
File "/srv/myproject/local/lib/python2.7/site-
packages/django/db/backends/__init__.py", line 180, in rollback
self._rollback()
File "/srv/myproject/local/lib/python2.7/site-
packages/django/db/backends/__init__.py", line 144, in _rollback
return self.connection.rollback()
File "/srv/myproject/local/lib/python2.7/site-
packages/django/db/utils.py", line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/srv/myproject/local/lib/python2.7/site-
packages/django/db/backends/__init__.py", line 144, in _rollback
return self.connection.rollback()
django.db.utils.InterfaceError: connection already closed
}}}
I can reliably replicate it by running `ab` against the app and doing a
postgresql restart in the middle of it. All future requests fail until the
uWSGI process is restarted. I tried changing the `lazy-apps` option in
uWSGI, but the issue persists.
--
Ticket URL: <https://code.djangoproject.com/ticket/15802#comment:36>
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/081.e0ed130b3632b798e992aa18f6018fd4%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
