[sqlalchemy] Re: ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1 - Michael Bayer - com.googlegroups.sqlalchemy

12 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: ConcurrentModificati...

From	Sent On	Attachments
Arun Kumar PG	30 Jul 2007 05:13
Michael Bayer	30 Jul 2007 07:04
Arun Kumar PG	31 Jul 2007 00:40
jason kirtland	31 Jul 2007 01:19
Arun Kumar PG	31 Jul 2007 01:36
Arun Kumar PG	31 Jul 2007 01:47
King Simon-NFHD78	31 Jul 2007 01:57
Arun Kumar PG	31 Jul 2007 02:13
Michael Bayer	31 Jul 2007 07:37
Arun Kumar PG	31 Jul 2007 07:47
Michael Bayer	31 Jul 2007 08:03
Arun Kumar PG	31 Jul 2007 08:32

Subject:	[sqlalchemy] Re: ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1
From:	Michael Bayer (mike...@zzzcomputing.com)
Date:	07/30/2007 07:04:45 AM
List:	com.googlegroups.sqlalchemy

On Jul 30, 2007, at 8:13 AM, Arun Kumar PG wrote:

Guys,

I am using SA with MySQL. I am trying to update a record by making a call to session.update(obj). In response I am getting "ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1"

What are the possible reasons for this error?

the UPDATE statement issued fails to find any rows which match the expected criterion. the "concurrent" part comes from the idea that some other process has already updated the row; however if the UPDATE statement isnt formed correctly, or if the "rowcount" function on your DBAPI is busted, that will do it too.