Hello!
We're running an application under gunicorn that stores the session a
postgresql database (it saves > 2 Mb info so memcached is not an
option) and sometimes it's not able to save the sessions. We have
added logs in the session and in the database and we see that
sometimes the session middleware makes a rollback and does not save
the session in the database. We don't have any error log
We have log sid and transactions activaded (log_line_prefix = '%t %c %x ' )
Here you can see log for sid 4d109548.3bb3, with transaction 401214 rolled back:
-------------
[...]
2010-12-21 12:53:45 CET 4d109548.3bb3 0 LOG: duration: 0.041 ms
statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2010-12-21 12:53:45 CET 4d109548.3bb3 0 LOG: duration: 0.019 ms
statement: SAVEPOINT s67396208_x1
2010-12-21 12:53:45 CET 4d109548.3bb3 0 LOG: duration: 0.267 ms
statement: SELECT (1) AS "a" FROM "django_session" WHERE
"django_session"."session_key" = E'0928108749f2
8807a6501839e801912a' LIMIT 1
2010-12-21 12:53:45 CET 4d109548.3bb3 401214 LOG: duration: 2.381 ms
statement: UPDATE "django_session" SET "session_data" =
E'gAJ9cQEoVQtkaXNwb19yZXBseXECXXEDKGN3ZWJfY
jJjLnNlcnZpY2UKRGlzcG9SZXN1bHQKcQQp
gXEFfXEGKFUEbGFuZ3EHVQNFU1BxCFUGX2hvdGVscQljZGphbmdvLmRiLm1vZGVscy5iYXNlCm1v
[... session data ...]
Y2RiNTU2YmYxMjNlOTNmYTNmYjlhYmIyYmM5YQ==
', "expire_date" = E'2011-01-04 12:53:45.409949' WHERE
"django_session"."session_key" = E'0928108749f28807a6501839e801912a'
2010-12-21 12:53:45 CET 4d109548.3bb3 0 LOG: duration: 0.052 ms
statement: ROLLBACK
[...]
---------------
Usually everything rules like a charm, but from time to time we have
this kind of issue. We have also updated to the last psycopg2, just in
case, but without luck.
Any ideas would be greatly appreciated
Best regards,
--
Antoni Aloy López
Blog: http://trespams.com
Site: http://apsl.net
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
