[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)

[sqlalchemy] Re: Long running transaction issues with commit

2011-06-02 Thread Aalok Sood
. 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 mike...@zzzcomputing.com wrote: The Session doesn't interact with the database until statements

[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 mike...@zzzcomputing.com wrote: On Jun 2, 2011, at 11:35 AM, Aalok Sood wrote: Hello Michael Thanks a lot for your quick response. I