id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
23325	InterfaceError: connection already closed in PostgreSQL	Ilya Antipenko		"I have 1.6.5 django with psycopg 2.5.3.
This exception happened when connection was closed by postgres.

Related issue #21553
{{{
2014-08-19 13:32:46.414848 - ERROR:apscheduler.executors.default:Job ""expire_key_notify (trigger: interval[0:01:00], next run at: 2014-08-19 13:33:46 EEST)"" raised an exception
2014-08-19 13:32:46.414934 - Traceback (most recent call last):
2014-08-19 13:32:46.415001 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/apscheduler/executors/base.py"", line 108, in run_job
2014-08-19 13:32:46.415056 -     retval = job.func(*job.args, **job.kwargs)
2014-08-19 13:32:46.415105 -   File ""./test/test_app/workflow/monitor.py"", line 508, in expire_key_notify
2014-08-19 13:32:46.415151 -     for event in Event.objects.filter(done=False, event_after__lte=TimeManager.get_time()).all():
2014-08-19 13:32:46.415199 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/models/query.py"", line 96, in __iter__
2014-08-19 13:32:46.415245 -     self._fetch_all()
2014-08-19 13:32:46.415293 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/models/query.py"", line 854, in _fetch_all
2014-08-19 13:32:46.415338 -     self._result_cache = list(self.iterator())
2014-08-19 13:32:46.415385 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/models/query.py"", line 220, in iterator
2014-08-19 13:32:46.415431 -     for row in compiler.results_iter():
2014-08-19 13:32:46.415524 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py"", line 713, in results_iter
2014-08-19 13:32:46.415574 -     for rows in self.execute_sql(MULTI):
2014-08-19 13:32:46.415620 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py"", line 785, in execute_sql
2014-08-19 13:32:46.415667 -     cursor = self.connection.cursor()
2014-08-19 13:32:46.415711 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/backends/__init__.py"", line 160, in cursor
2014-08-19 13:32:46.415757 -     cursor = self.make_debug_cursor(self._cursor())
2014-08-19 13:32:46.415802 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/backends/__init__.py"", line 134, in _cursor
2014-08-19 13:32:46.415848 -     return self.create_cursor()
2014-08-19 13:32:46.415896 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/utils.py"", line 99, in __exit__
2014-08-19 13:32:46.415943 -     six.reraise(dj_exc_type, dj_exc_value, traceback)
2014-08-19 13:32:46.415992 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/backends/__init__.py"", line 134, in _cursor
2014-08-19 13:32:46.416078 -     return self.create_cursor()
2014-08-19 13:32:46.416127 -   File ""/home/user/projects/virtualenvs/test-system2/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py"", line 137, in create_cursor
2014-08-19 13:32:46.416176 -     cursor = self.connection.cursor()
2014-08-19 13:32:46.416227 - InterfaceError: connection already closed
}}}

Additional, I have other exception when postgres server was restarted 

{{{
ERROR:apscheduler.executors.default:Job ""sync_db_with_queue (trigger: interval[0:02:00], next run at: 2014-08-20 16:20:18 EEST)"" raised an exception
Traceback (most recent call last):
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/apscheduler/executors/base.py"", line 108, in run_job
    retval = job.func(*job.args, **job.kwargs)
  File ""/home/user/projects/test-system/test/test_app/workflow/monitor.py"", line 369, in sync_db_with_queue
    for task in JobProcessReceipt.objects.filter(status=JobProcessReceipt.enum_receipt_status.queue, create_ts__lt=int(time.time()-30)):
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/models/query.py"", line 96, in __iter__
    self._fetch_all()
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/models/query.py"", line 857, in _fetch_all
    self._result_cache = list(self.iterator())
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/models/query.py"", line 220, in iterator
    for row in compiler.results_iter():
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py"", line 713, in results_iter
    for rows in self.execute_sql(MULTI):
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py"", line 786, in execute_sql
    cursor.execute(sql, params)
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/backends/util.py"", line 69, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/backends/util.py"", line 53, in execute
    return self.cursor.execute(sql, params)
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/utils.py"", line 99, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File ""/home/user/projects/.test-system/local/lib/python2.7/site-packages/django/db/backends/util.py"", line 53, in execute
    return self.cursor.execute(sql, params)
OperationalError: terminating connection due to administrator command
SSL connection has been closed unexpectedly
}}}"	Bug	closed	Database layer (models, ORM)	1.6	Normal	duplicate	InterfaceError, postgresql		Unreviewed	0	0	0	0	0	0