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
13215	Random OperationalError when using FastCGI prefork + PostgreSQL	Henrique C. Alves	jbronn	"To reproduce:

1. Setup a Django project with FCGI in prefork mode

python manage.py runfcgi method=prefork

2. Use psycopg2 as the database handler

3. Setup an async FCGI web server to use your daemon (Cherokee, Lighttpd, Nginx)

Randomly, some requests will result in the following traceback:

{{{
File ""/usr/lib/python2.6/site-packages/django/core/handlers/base.py"", line 86, in get_response
   response = callback(request, *callback_args, **callback_kwargs)

 File ""/usr/lib/python2.6/site-packages/django/contrib/admin/sites.py"", line 140, in root
   if not self.has_permission(request):

 File ""/usr/lib/python2.6/site-packages/django/contrib/admin/sites.py"", line 99, in has_permission
   return request.user.is_authenticated() and request.user.is_staff

 File ""/usr/lib/python2.6/site-packages/django/contrib/auth/middleware.py"", line 5, in __get__
   request._cached_user = get_user(request)

 File ""/usr/lib/python2.6/site-packages/django/contrib/auth/__init__.py"", line 83, in get_user
   user_id = request.session[SESSION_KEY]

 File ""/usr/lib/python2.6/site-packages/django/contrib/sessions/backends/base.py"", line 46, in __getitem__
   return self._session[key]

 File ""/usr/lib/python2.6/site-packages/django/contrib/sessions/backends/base.py"", line 172, in _get_session
   self._session_cache = self.load()

 File ""/usr/lib/python2.6/site-packages/django/contrib/sessions/backends/db.py"", line 16, in load
   expire_date__gt=datetime.datetime.now()

 File ""/usr/lib/python2.6/site-packages/django/db/models/manager.py"", line 93, in get
   return self.get_query_set().get(*args, **kwargs)

 File ""/usr/lib/python2.6/site-packages/django/db/models/query.py"", line 304, in get
   num = len(clone)

 File ""/usr/lib/python2.6/site-packages/django/db/models/query.py"", line 160, in __len__
   self._result_cache = list(self.iterator())

 File ""/usr/lib/python2.6/site-packages/django/db/models/query.py"", line 275, in iterator
   for row in self.query.results_iter():

 File ""/usr/lib/python2.6/site-packages/django/db/models/sql/query.py"", line 206, in results_iter
   for rows in self.execute_sql(MULTI):

 File ""/usr/lib/python2.6/site-packages/django/db/models/sql/query.py"", line 1734, in execute_sql
   cursor.execute(sql, params)

OperationalError: server closed the connection unexpectedly
       This probably means the server terminated abnormally
       before or while processing the request.
}}}


The bug doesn't appear to happend when using threaded mode, but it's hard to tell as it's completly random.

For the record, had this issue with: Django 1.1, Cherokee 0.44.19, python-2.6, PostgreSQL-8.3

Another report with the same issue, but different setup: http://stackoverflow.com/questions/393637/"		closed	Core (Other)	1.1		fixed			Accepted	0	0	0	0	0	0