36 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: concurent modification
FromSent OnAttachments
imgrey22 Nov 2007 11:28 
Sanjay22 Nov 2007 23:43 
imgrey23 Nov 2007 00:58 
Michael Bayer23 Nov 2007 08:03 
imgrey27 Nov 2007 11:39 
King Simon-NFHD7828 Nov 2007 01:33 
Michael Bayer28 Nov 2007 07:20 
imgrey28 Nov 2007 07:38 
Michael Bayer28 Nov 2007 08:37 
imgrey28 Nov 2007 09:03 
Michael Bayer28 Nov 2007 10:40 
imgrey28 Nov 2007 12:29 
Michael Bayer28 Nov 2007 14:07 
imgrey30 Nov 2007 06:36 
Michael Bayer30 Nov 2007 07:15 
imgrey30 Nov 2007 10:44 
Michael Bayer30 Nov 2007 11:06 
imgrey30 Nov 2007 12:06 
Michael Bayer30 Nov 2007 13:13 
imgrey30 Nov 2007 15:21 
Michael Bayer30 Nov 2007 22:01 
imgrey01 Dec 2007 16:24 
Michael Bayer01 Dec 2007 16:37 
Michael Bayer02 Dec 2007 10:22 
imgrey03 Dec 2007 15:32 
Michael Bayer03 Dec 2007 16:50 
imgrey06 Dec 2007 05:57 
Michael Bayer06 Dec 2007 08:50 
imgrey10 Dec 2007 16:45 
imgrey11 Dec 2007 13:43 
Michael Bayer11 Dec 2007 13:55 
imgrey11 Dec 2007 14:53 
Michael Bayer11 Dec 2007 15:14 
imgrey14 Dec 2007 18:24 
Michael Bayer14 Dec 2007 20:01 
imgrey20 Dec 2007 23:35 
Subject:[sqlalchemy] Re: concurent modification
From:imgrey (img@gmail.com)
Date:11/23/2007 12:58:59 AM
List:com.googlegroups.sqlalchemy

I was thinking to change isolation level in fact.

But first, I don't know how to do this with sqlalchemy, second, with default isolation level commits should work properly weather or not something were inserted or updated during commit and third, I was using nested transaction like this :

transaction = session.begin() nested = session.begin_nested() try: ..insert.. #trying to insert values to column that have UNIQUE constraint except: ..update.. nested.commit() transaction.commit()

so, I'm not sure that done everything right.

btw, there's a daemon, and have no user to watch on it.

On 23 нояб, 09:43, Sanjay <skpa@gmail.com> wrote:

I think all one can do is just forget and start over again, when concurrent modifications error occurs. That means, catchig the exception and just showing some failure message to the user is all one can do.