OperationalError under fastcgi when maxrequests=1 is set

Sorry, the error actually happens deeper in the chain. From the traceback you can see it is triggered through a model you import through a view in urls.py.

urls.py

from django.conf.urls.defaults import *
from django.contrib import admin
admin.autodiscover()

from gis.tilecache import views as t_views
from gis.spec import views

urlpatterns = patterns('',
    (r'^$', views.index),
)

The models.py causing the error:

from django.contrib.gis.db import models

class CWAGrid(models.Model):
    id = models.AutoField(primary_key=True,db_column='gid')
    indexnum = models.IntegerField(db_column='indexnum')
    geom = models.MultiPolygonField(srid=2230, db_column='the_geom')
    objects = models.GeoManager()

    def  __unicode__(self):
        return str(self.indexnum)
    class Meta:
        db_table = 'cwagrid'

Without the geometry field I get no such error.

Seems like the OperationalError? occurs when any model is instantiating a new cursor and executing a statement.

Lines 252:262 of django.contrib.gis.db.models (which is what I've been focusing on here for this case)

        from django.db import connection
        cur = connection.cursor()
        qn = connection.ops.quote_name
        stmt = 'SELECT %(table)s.%(wkt_col)s FROM %(table)s WHERE (%(table)s.%(srid_col)s = %(s\
rid)s)'
        stmt = stmt % {'table' : qn(SpatialRefSys._meta.db_table),
                       'wkt_col' : qn(SpatialRefSys.wkt_col()),
                       'srid_col' : qn('srid'),
                       'srid' : srid,
                       }
        cur.execute(stmt)

When the close_connection signal handler in django.db is commented out the error disappears.

# Register an event that closes the database connection
# when a Django request is finished.
def close_connection(**kwargs):
    connection.close()
signals.request_finished.connect(close_connection)

I'm not sure where to look to find out how the connection gets established under fastcgi if maxrequests=1. I know when the process starts django.db.init.py is called which establishes a connection but after that I'm clueless as signals.request_finished is fired and closes it. I'm still looking...

gis contrib models.py add connection.close() in get_srid_info

Milestone post-1.0 deleted

(In [10254]) Fixed #9437 -- Now close database connection within get_srid_info. Thanks, mattxbart.