(pymysql.err.OperationalError) (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'

        这里记录下uwsgi部署flask web程序时，uwsgi进程活着，无法访问flask web的情况，后台使用了数据库持久层框架sqlalchemy，通过查看日志，看到日志报错如下：

(pymysql.err.OperationalError) (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")

设置pool_pre_ping=True和pool_recycle=3600

engine = create_engine(URL,
                       encoding='utf-8',
                       echo=False,
                       pool_pre_ping=True,
                       pool_recycle=3600)

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

设置autocommit=True

session = sessionmaker(bind=engine,
                       autocommit=True)()

 

 

参考：https://www.cnblogs.com/lesliexong/p/8654615.html