I have a very similar configuration and I get the exact same error. Have you open a ticket? Thanks.
On Wednesday, December 18, 2013 2:23:57 AM UTC-8, Pavel Lurye wrote: > > Hi, > CONN_MAX_AGE=None. > Of course, restarting will fix the problem, but that's not what I'm > expecting from django. > I think this is django bug, but I want to be sure. > > вторник, 17 декабря 2013 г., 18:59:46 UTC+4 пользователь Prashanth B > написал: >> >> I suspect restarting your Web server will fix it as you'll get fresh >> connections. What is your CONN_MAX_AGE? >> On Dec 17, 2013 4:57 AM, "Pavel Lurye" <[email protected]> wrote: >> >>> Hi, >>> does anyone have used django1.6 persistent connections with postgresql? >>> I've done a simple test and I'm not sure, that django behaves correctly. >>> Django can't recover after DB restart, and all further db requests lead >>> to server error: >>> --------------- >>> Traceback (most recent call last): >>> File >>> "/venv/local/lib/python2.7/site-packages/django/core/handlers/wsgi.py", >>> line 194, in __call__ >>> signals.request_started.send(sender=self.__class__) >>> File >>> "/venv/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py", >>> line 185, in send >>> response = receiver(signal=self, sender=sender, **named) >>> File "/venv/local/lib/python2.7/site-packages/django/db/__init__.py", >>> line 95, in close_old_connections >>> conn.close_if_unusable_or_obsolete() >>> File >>> "/venv/local/lib/python2.7/site-packages/django/db/backends/__init__.py", >>> line 466, in close_if_unusable_or_obsolete >>> if self.is_usable(): >>> File >>> "/venv/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", >>> >>> line 196, in is_usable >>> self.connection.cursor().execute("SELECT 1") >>> psycopg2.InterfaceError: connection already closed >>> --------------- >>> >>> So, InterfaceError is not catched by django in >>> postgresql_psycopg2.DatabaseWrapper.is_usable. >>> >>> My test environment is: >>> Ubuntu 13.10 >>> postgresql 9.1 >>> >>> Django==1.6.1 >>> psycopg2==2.5.1 >>> uWSGI==1.9.21.1 >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django users" 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]. >>> Visit this group at http://groups.google.com/group/django-users. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/77922966-a48e-4284-badd-e93f052fff54%40googlegroups.com >>> . >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> -- You received this message because you are subscribed to the Google Groups "Django users" 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]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c037361c-498d-438c-9bbc-13f0a8ebd8e5%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
