(sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back

https://blog.csdn.net/weixin_37947156/article/details/76049666
##1
在mysql超过wait_timeout后，连接会挂掉，服务就会报错 OperationalError: (_mysql_exceptions.OperationalError) (2006, ‘MySQL server has gone away’) ，

##2.因为连接断开后，事务没有回滚，残留的锁导致后续的查询报错.
由于也sqlalchemy关闭了autocommit，隐式使用了事务，还会有错误StatementError: (sqlalchemy.exc.InvalidRequestError) Can’t reconnect until invalid transaction is rolled back
##项目使用web框架，使用sqlalchemy作为orm框架.

连接时加autocommit=true
app.config[“SQLALCHEMY_DATABASE_URI”] = “mysql+pymysql://root:asimov@localhost/newMovie?charset=utf8&autocommit=true’)”