#23325: InterfaceError: connection already closed in PostreSQL
-------------------------------------+-------------------------------------
Reporter: aivus | Owner:
Type: Bug | Status: new
Component: Database layer | Version: 1.6
(models, ORM) | Keywords: InterfaceError,
Severity: Normal | postgresql
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
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
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/23325>
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/048.f9dbdaa662ab45a321d01fcfd96e218a%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
