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
9437	OperationalError under fastcgi when maxrequests=1 is set	Matt Bartolome	Matt Bartolome	"I'm trying to run django (with a contrib.gis model) under fastcgi with the maxrequests=1 parameter so I don't have to restart the process to see code changes: 
{{{
$ python manage.py runfcgi --settings=myproject.settings method=prefork pidfile=/var/run/myproject.pid host=127.0.0.1 port=7778 maxrequests=1
}}}

I'm using nginx on the front end with postgresql_psycopg2. When I remove the GIS contrib portion from my model (and use the regular django.db.models) I no longer get the error. 

My '''models.py''' (it does not seem to matter if I have a geometry field in the model or not):

{{{
from django.contrib.gis.db import models
from django.conf import settings
from django.contrib.sites.models import Site
from django.core.files import File

class Drawing(models.Model):
    title = models.CharField(max_length=255)
    slug = models.SlugField()
    date = models.DateTimeField()
    created = models.DateTimeField(auto_now=True)

    objects = models.GeoManager()

    def get_absolute_url(self):
        domain = Site.objects.get(id=settings.SITE_ID).domain
        return ""%s/drawings/%s/"" % (domain,self.slug)

    def __unicode__(self):
        return self.title
}}}

'''Traceback:'''
{{{
File ""/usr/local/lib/python2.5/site-packages/django/core/handlers/base.py"" in get_response
  77.                     request.path_info)
File ""/usr/local/lib/python2.5/site-packages/django/core/urlresolvers.py"" in resolve
  181.                     sub_match = pattern.resolve(new_path)
File ""/usr/local/lib/python2.5/site-packages/django/core/urlresolvers.py"" in resolve
  179.             for pattern in self.urlconf_module.urlpatterns:
File ""/usr/local/lib/python2.5/site-packages/django/core/urlresolvers.py"" in _get_urlconf_module
  198.             self._urlconf_module = __import__(self.urlconf_name, {}, {}, [''])
File ""/home/mbartolome/projects/gis/spec/urls.py"" in <module>
  6. from gis.tilecache import views as t_views
File ""/home/mbartolome/projects/gis/tilecache/views.py"" in <module>
  4. from gis.cwagrid.models import CWAGrid
File ""/home/mbartolome/projects/gis/cwagrid/models.py"" in <module>
  6. class CWAGrid(models.Model):
File ""/home/mbartolome/projects/gis/cwagrid/models.py"" in CWAGrid
  9.     geom = models.MultiPolygonField(srid=2230, db_column='the_geom')
File ""/usr/local/lib/python2.5/site-packages/django/contrib/gis/db/models/fields/__init__.py"" in __init__
  45.         self._unit, self._unit_name, self._spheroid = get_srid_info(srid)
File ""/usr/local/lib/python2.5/site-packages/django/contrib/gis/models.py"" in get_srid_info
  261.         cur.execute(stmt)
File ""/usr/local/lib/python2.5/site-packages/django/db/backends/util.py"" in execute
  19.             return self.cursor.execute(sql, params)

Exception Type: OperationalError at /spec/
Exception Value: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
}}}
"		closed	GIS	dev		fixed	gis geodjango		Accepted	1	0	0	0	0	0