#852: psycopg.ProgrammingError exceptions leave the connection to the DB in an
unusable state
---------------------------------------+------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: adrian
Type: defect | Status: closed
Priority: normal | Milestone:
Component: Database wrapper | Version:
Severity: normal | Resolution: wontfix
Keywords: |
---------------------------------------+------------------------------------
Comment (by [EMAIL PROTECTED]):
I think this is due to TIMESTAMP WITH TIME ZONE field (used in the
django_session table where the cookie information is stored). I believe
this is more of a psycopg2 problem (verified both on Windows XP SP2/Py2.4
and Win2k3/Py2.4) than django's.
Traceback follows:
{{{
#!python
Traceback (most recent call last):
File "C:\Python24\lib\site-packages\django\core\servers\basehttp.py",
line 272, in run
self.result = application(self.environ, self.start_response)
File "C:\Python24\lib\site-packages\django\core\servers\basehttp.py",
line 614, in __call__
return self.application(environ, start_response)
File "C:\Python24\lib\site-packages\django\core\handlers\wsgi.py", line
193, in __call__
response = middleware_method(request, response)
File "C:\Python24\lib\site-
packages\django\contrib\sessions\middleware.py", line 89, in
process_response
datetime.datetime.now() +
datetime.timedelta(seconds=settings.SESSION_COOKIE_AGE))
File "C:\Python24\lib\site-packages\django\contrib\sessions\models.py",
line 29, in save
s.save()
File "C:\Python24\lib\site-packages\django\db\models\base.py", line 166,
in save
cursor = connection.cursor()
File "C:\Python24\lib\site-
packages\django\db\backends\postgresql_psycopg2\base.py", line 48, in
cursor
cursor.execute("SET TIME ZONE %s", [settings.TIME_ZONE])
ProgrammingError: current transaction is aborted, commands ignored until
end of transaction block
}}}
--
Ticket URL: <http://code.djangoproject.com/ticket/852#comment:>
Django <http://code.djangoproject.org/>
The web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Django
updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
