rollback() your Session when an exception is raised.
On May 7, 2009, at 3:29 AM, reetesh nigam wrote:
>
> Hi All,
> I am using sqlalchemy 0.4.4 +mysql 4.1 + TG 1.0.4b3.
> Some time i am getting the following error :
>
>
> =
> =
> =
> =
> =
> =
> =
> =
> =
> =
> =
> =
> ======================================================================
> InvalidRequestError: The transaction is inactive due to a rollback in
> a subtransaction and should be closed,
>
> File "c:\python25\lib\site-packages\cherrypy-2.2.1-py2.5.egg\cherrypy
> \_cphttptools.py", line 105, in _run
> self.main()
> File "c:\python25\lib\site-packages\cherrypy-2.2.1-py2.5.egg\cherrypy
> \_cphttptools.py", line 254, in main
> body = page_handler(*virtual_path, **self.params)
> File "<string>", line 3, in doCrossDomainCommunication
> File "c:\python25\lib\site-packages\TurboGears-1.0.4b3-py2.5.egg
> \turbogears\controllers.py", line 344, in expose
> *args, **kw)
> File "<string>", line 5, in run_with_transaction
> File "c:\python25\lib\site-packages\TurboGears-1.0.4b3-py2.5.egg
> \turbogears\database.py", line 403, in sa_rwt
> req.sa_transaction = make_sa_transaction(session)
> File "c:\python25\lib\site-packages\TurboGears-1.0.4b3-py2.5.egg
> \turbogears\database.py", line 455, in make_sa_transaction
> session.begin()
> File "c:\python25\lib\site-packages\SQLAlchemy-0.4.4-py2.5.egg
> \sqlalchemy\orm\scoping.py", line 98, in do
> return getattr(self.registry(), name)(*args, **kwargs)
> File "c:\python25\lib\site-packages\SQLAlchemy-0.4.4-py2.5.egg
> \sqlalchemy\orm\session.py", line 489, in begin
> self.transaction = self.transaction._begin(**kwargs)
> File "c:\python25\lib\site-packages\SQLAlchemy-0.4.4-py2.5.egg
> \sqlalchemy\orm\session.py", line 171, in _begin
> self._assert_is_active()
> File "c:\python25\lib\site-packages\SQLAlchemy-0.4.4-py2.5.egg
> \sqlalchemy\orm\session.py", line 159, in _assert_is_active
> raise exceptions.InvalidRequestError("The transaction is inactive
> due to a rollback in a subtransaction and should be closed")
> InvalidRequestError: The transaction is inactive due to a rollback in
> a subtransaction and should be closed
>
> =
> =
> =
> =
> =
> =
> =
> =
> =
> =
> =
> =
> ======================================================================
>
>
> Can any one help meto slove this problem.
>
> Thanks and Regards
>
> Reetesh Nigam
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
