擅长:python、mysql、java
<p>如果在烧瓶中使用sqlalchemy,当您查询</p>
<pre><code>MyModel.query.all()
</code></pre>
<p>你会犯错误,比如</p>
<pre><code> File "./lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 427, in _revalidate_connection
"Can't reconnect until invalid "
StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back
</code></pre>
<p>您只需通过</p>
<pre><code>MyModel.query.session.close()
MyModel.query.all()
</code></pre>