DatabaseError: ORA-03127: no new operations allowed until the active operation ends

[Paolo Corti]

Hi
I had to migrate a GeoDjango project based on a Postgres/PostGIS
backend to a Oracle/Oracle Spatial backend.

I could sync the database without problems and now I can successfully
read and create new data from the shell, but as soon as I try to
access my Django web application I am getting in this error:

Traceback (most recent call last):
File "/home/pcorti/virtualenv/forest_env/lib/python2.6/site-packages/
django/core/servers/basehttp.py", line 283, in run
self.result = application(self.environ, self.start_response)
File "/home/pcorti/virtualenv/forest_env/lib/python2.6/site-packages/
django/contrib/staticfiles/handlers.py", line 68, in __call__
return self.application(environ, start_response)
File "/home/pcorti/virtualenv/forest_env/lib/python2.6/site-packages/
django/core/handlers/wsgi.py", line 275, in __call__
signals.request_finished.send(sender=self.__class__)
File "/home/pcorti/virtualenv/forest_env/lib/python2.6/site-packages/
django/dispatch/dispatcher.py", line 172, in send
response = receiver(signal=self, sender=sender, **named)
File "/home/pcorti/virtualenv/forest_env/lib/python2.6/site-packages/
django/db/__init__.py", line 85, in close_connection
conn.close()
File "/home/pcorti/virtualenv/forest_env/lib/python2.6/site-packages/
django/db/backends/__init__.py", line 244, in close
self.connection.close()

DatabaseError: ORA-03127: no new operations allowed until the active
operation end

I am having the same behavior both with Django 1.2.5 and 1.3 RC
any ideas?
thanks

--
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @paolo_corti

[Paolo Corti]

I have solved this by downgrading the cx_Oracle library from 5.1 to
5.0.1
I am using Oracle 11.2
Now works well both on Django 1.2.5 and 1.3 RC with Python 2.6
best regards
P

[Ian]

On Mar 22, 5:38 am, Paolo Corti <pco...@gmail.com> wrote:

> I have solved this by downgrading the cx_Oracle library from 5.1 to
> 5.0.1
> I am using Oracle 11.2
> Now works well both on Django 1.2.5 and 1.3 RC with Python 2.6
> best regards
> P

Thanks for letting us know. I haven't yet tried cx_Oracle 5.1 myself,
so I suppose I'll have to install it and see if this reproduces.