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) ....: mm.name=u'new name' ....: print "commiting2" ....: s.commit() Even though the second sleep is only for 25 seconds, I see an error while commiting which says 'Mysql server has gone away' The SQLAlchemy documentation says that a new transaction is begun on a commit(). If that is the case, I should not see the above error. Maybe its an issue with commiting w/o any changes to the loaded instances. Can anyone throw some light on this. Any help would be much appreciated. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.