Re: [sqlalchemy] Session commit block?

2014-03-01 Thread Ni Wesley
Here is my code: from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker,scoped_session from sqlalchemy.schema import MetaData engine = create_engine(db_url, echo=engine_echo,pool_recycle=300) session = scoped_session(sessionmaker(bind=engine)) So, for code blocks that need

Re: [sqlalchemy] Session commit block?

2014-03-01 Thread Michael Bayer
On Mar 1, 2014, at 3:04 AM, Ni Wesley wrote: > File "/root/workspace/Push Server/server/pymysql/connections.py", line 829, > in _read_bytes > "Lost connection to MySQL server during query (%r)" % (e,)) > OperationalError: (OperationalError) (2013, "Lost connection to MySQL server > durin

[sqlalchemy] Session commit block?

2014-03-01 Thread Ni Wesley
Hi all, I hit a problem these day that sqlalchemy session execute hangs some time. And if one db operation hangs, all the following operations are blocked... Here is exception snippet: ERROR:tornado.application:Uncaught exception, closing connection. Traceback (most recent call last): File "/r