[sqlalchemy] Re: Long running transaction issues with commit

2011-06-02 Thread Aalok Sood
Yes its all so very clear now, kind of obvious :) Thank you for taking out time to help me. Regards Aalok Sood. On Jun 2, 9:20 pm, Michael Bayer wrote: > On Jun 2, 2011, at 11:35 AM, Aalok Sood wrote: > > > > > > > > > > > Hello Michael > > > Thanks

[sqlalchemy] Re: Long running transaction issues with commit

2011-06-02 Thread Aalok Sood
however, does not comply with this logic. Can you please tell me where the loophole in my understanding of the whole thing is. Once again, Thanks a lot for your help. I really appreciate it. Regards Aalok Sood On Jun 2, 8:17 pm, Michael Bayer wrote: > The Session doesn't inter

[sqlalchemy] Long running transaction issues with commit

2011-06-02 Thread Aalok Sood
Hello Everyone My mysql server wait_timeout is set to 35. and if i run this code: # Session s made with autocommit=False mm=s.query(ss.Machine).get(1) In [9]: In [10]: for i in range(1000): : sleep(15) : print "commiting" : s.commit() : sleep(25) .