Hi,
I have a relatively large TG1.5 project. The controllers and model
files are split in different files due to nature of data.
At random intervals I get the following error :
Traceback (most recent call last):
File "/usr/local/TurboApps/bddb/lib/python2.6/site-packages/
CherryPy-3.2.0-py2.6.egg/cherrypy/_cprequest.py", line 642, in respond
self.hooks.run('before_handler')
File "/usr/local/TurboApps/bddb/lib/python2.6/site-packages/
CherryPy-3.2.0-py2.6.egg/cherrypy/_cprequest.py", line 97, in run
hook()
File "/usr/local/TurboApps/bddb/lib/python2.6/site-packages/
CherryPy-3.2.0-py2.6.egg/cherrypy/_cprequest.py", line 57, in __call__
return self.callback(**self.kwargs)
File "/usr/local/TurboApps/bddb/lib/python2.6/site-packages/
TurboGears-1.5b2-py2.6.egg/turbogears/visit/api.py", line 180, in
__call__
visit = _manager.visit_for_key(visit_key)
File "/usr/local/TurboApps/bddb/lib/python2.6/site-packages/
TurboGears-1.5b2-py2.6.egg/turbogears/visit/savisit.py", line 69, in
visit_for_key
visit = visit_class.lookup_visit(visit_key)
File "/usr/local/TurboApps/bddb/temp_bddb/bddb/bddb/model/base.py",
line 89, in lookup_visit
return session.query(cls).get(visit_key)
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/query.py", line 577, in get
return self._get(key, ident)
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/query.py", line 1759, in _get
return q.one()
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/query.py", line 1491, in one
ret = list(self)
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/query.py", line 1534, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/query.py", line 1539, in
_execute_and_instances
mapper=self._mapper_zero_or_none())
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/session.py", line 734, in execute
return self._connection_for_bind(engine,
close_with_result=True).execute(
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/session.py", line 699, in
_connection_for_bind
return self.transaction._connection_for_bind(engine)
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/session.py", line 298, in
_connection_for_bind
self._assert_is_active()
File "/usr/local/lib64/python2.6/site-packages/SQLAlchemy-0.6.1-
py2.6.egg/sqlalchemy/orm/session.py", line 233, in _assert_is_active
"The transaction is inactive due to a rollback in a "
InvalidRequestError: The transaction is inactive due to a rollback in
a subtransaction. Issue rollback() to cancel the transaction.
This only happens on the live version on the webserver and never on
the developing version I run locally. I did some reading on similar
cases but this seems to be associated with added data to the database.
Currently my TG App only does queries to the database, I add the data
via python scripts.
Any ideas what is happening?
--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en.
