[sqlalchemy] Re: OperationalError: (OperationalError) cannot commit transaction - SQL statements in progress - Michael Bayer - com.googlegroups.sqlalchemy

2 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: OperationalError: (O...

From	Sent On	Attachments
Manlio Perillo	16 Jul 2008 02:12
Michael Bayer	16 Jul 2008 10:02

Subject:	[sqlalchemy] Re: OperationalError: (OperationalError) cannot commit transaction - SQL statements in progress
From:	Michael Bayer (mike...@zzzcomputing.com)
Date:	07/16/2008 10:02:10 AM
List:	com.googlegroups.sqlalchemy

On Jul 16, 2008, at 5:13 AM, Manlio Perillo wrote:

Hi.

I'm having problems with the exception in subject, with pysqlite (on Debian Lenny).

Unfortunately, I'm unable to reproduce the problem, but basically it is an update statement in a transaction.

If there is only one row in the table, all is ok; but if there are more then one rows, I get this exception.

If I catch the exception and execute the transaction again, it finally succeed.

mmm, im drawing a blank on this one. the error often indicates concurrent access on the cursor, or continuing on a cursor where an exception was raised and some issue was not resolved. try to get more detail out of it, perhaps check that your installed version of pysqlite is up to date.