#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 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/048.f9dbdaa662ab45a321d01fcfd96e218a%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
