[sqlalchemy] ConcurrentModificationError: Deleted rowcount 0 ... but only on mysql?

2010-08-21 Thread Ergo
ConcurrentModificationError: Deleted rowcount 0 does not match number of objects deleted... I create my schema from models using create_all() - now , the problem is i get this error only using mysql or mysql+oursql. It happens every time in one place of my code. But when i uses postgresql

Re: [sqlalchemy] ConcurrentModificationError: Deleted rowcount 0 ... but only on mysql?

2010-08-21 Thread Michael Bayer
On Aug 21, 2010, at 7:45 AM, Ergo wrote: ConcurrentModificationError: Deleted rowcount 0 does not match number of objects deleted... for clarity, this error has been renamed to StaleDataError.Here is the docstring coming up in 0.6.4: * A flush may have attempted to update or delete

[sqlalchemy] ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1

2010-05-19 Thread jose soares
Hi all, Someone knows what this error mean? ... File /home/ve/sfera/release/sicer/BASE/model/anagraficaAlta/unita_aziendale.py, line 154, in aggiorna_capi_bovini x.flush() File /home/ve/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/ext/assignmapper.py, line 20, in

[sqlalchemy] ConcurrentModificationError

2009-12-02 Thread Dave Paola
I'm getting this: ConcurrentModificationError: updated rowcount 0 does not match number of objects updated 1 when I try to commit a simple deletion. I'm using Sqlite locally but the error also occurs on a Postgres database in a live environment with only ONE user connected. I saw this post from

Re: [sqlalchemy] ConcurrentModificationError

2009-12-02 Thread Michael Bayer
On Dec 2, 2009, at 5:46 PM, Dave Paola wrote: I'm getting this: ConcurrentModificationError: updated rowcount 0 does not match number of objects updated 1 when I try to commit a simple deletion. I'm using Sqlite locally but the error also occurs on a Postgres database in a live

Re: [sqlalchemy] ConcurrentModificationError

2009-12-02 Thread Dave Paola
Indeed, I do have TaskTags mapped to it's own class. However, I never explicitly delete any TaskTag object, only create them. In any case, what would the preferred way to add a new tag to a task (a new entry in the association table)? I was using the ORM to just create a new instance of TaskTag

Re: [sqlalchemy] ConcurrentModificationError

2009-12-02 Thread Conor
Dave Paola wrote: Indeed, I do have TaskTags mapped to it's own class. However, I never explicitly delete any TaskTag object, only create them. In any case, what would the preferred way to add a new tag to a task (a new entry in the association table)? I was using the ORM to just create a

[sqlalchemy] ConcurrentModificationError exception

2009-11-11 Thread Mike Conley
I am getting this error on a session.flush(). sqlalchemy.orm.exc.ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1 and can't figure out where to start looking. The database is sqlite, there are no other users connected to the database, and only one

[sqlalchemy] ConcurrentModificationError with transactional sessions

2008-04-14 Thread Tim Lesher
When I execute this piece of code using a transactional, autoflushing session against SQLite, I get a ConcurrentModificationError on the final select: -- from sqlalchemy import * from sqlalchemy.orm import * eng = create_engine('sqlite://') sm = sessionmaker(autoflush=True,

[sqlalchemy] ConcurrentModificationError without concurrent modification?

2007-10-01 Thread Dan Eloff
ConcurrentModificationError: Deleted rowcount 3 does not match number of objects deleted 1 raised by this code: with Session() as session: dl = session.merge(dl) session.delete(dl) There are no other sessions alive, so how can that possibly be a concurrent

[sqlalchemy] ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1

2007-07-30 Thread Arun Kumar PG
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? -- Cheers, - A