[sqlalchemy] Re: unexpected exception - Michael Bayer - com.googlegroups.sqlalchemy

7 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: unexpected exception

From	Sent On	Attachments
Manlio Perillo	21 Feb 2007 13:00
Michael Bayer	21 Feb 2007 15:27
Manlio Perillo	22 Feb 2007 03:03
Michael Bayer	22 Feb 2007 10:04
Manlio Perillo	22 Feb 2007 10:14
Michael Bayer	22 Feb 2007 12:18
Manlio Perillo	22 Feb 2007 12:24

Subject:	[sqlalchemy] Re: unexpected exception
From:	Michael Bayer (mike...@zzzcomputing.com)
Date:	02/21/2007 03:27:13 PM
List:	com.googlegroups.sqlalchemy

its what it says...its updating the database and not finding the rows it expects, indicating some other concurrent process already deleted that row.

On Feb 21, 2007, at 4:01 PM, Manlio Perillo wrote:

In the log file of my web application (still in testing), I have found this:

2007/02/14 17:39 CET [-] Traceback (most recent call last): File "threading.py", line 422, in run self.__target(*self.__args, **self.__kwargs) File "/usr/lib/python2.4/site-packages/twisted/python/ threadpool.py", line 148, in _worker context.call(ctx, function, *args, **kwargs) File "/usr/lib/python2.4/site-packages/twisted/python/context.py", line 59, in callWithContext return self.currentContext().callWithContext(ctx, func, *args, **kw) File "/usr/lib/python2.4/site-packages/twisted/python/context.py", line 37, in callWithContext return func(*args,**kw) --- <exception caught here> --- File "/usr/lib/python2.4/site-packages/twisted/internet/ threads.py", line 25, in _putResultInDeferred result = f(*args, **kwargs) File "/home/organizzasposi/svn/nadbapi/trunk/nadbapi/engine.py", line 334, in _transaction ret = callable_(conn, *args, **kwargs) File "/home/organizzasposi/svn/nadbapi/trunk/nadbapi/engine.py", line 412, in _job sess.flush() File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/session.py", line 220, in flush self.uow.flush(self, objects) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 194, in flush flush_context.execute() File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 333, in execute head.execute(self) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 470, in execute UOWExecutor().execute(trans, self) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 795, in execute self.execute_delete_steps(trans, task) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 822, in execute_delete_steps self.execute_childtasks(trans, task, True) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 841, in execute_childtasks self.execute(trans, child, isdelete) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 795, in execute self.execute_delete_steps(trans, task) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 824, in execute_delete_steps self.delete_objects(trans, task) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 801, in delete_objects task._delete_objects(trans) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/ unitofwork.py", line 464, in _delete_objects task.mapper.delete_obj(task.todelete_objects, trans) File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/mapper.py", line 1070, in delete_obj raise exceptions.ConcurrentModificationError("Updated rowcount %d does not match number of objects updated %d" % (c.cursor.rowcount, len(delete))) sqlalchemy.exceptions.ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1

The version of SQLAlchemy is python-sqlalchemy_0.3.4-1_all

Of course this is not a bug report, I would only like to know if this is a know issue.