flask-sqlalchemy session time out after 1 day

[MaximilianKromer]

restart server restarts session

[MaximilianKromer]

Error: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2006, "MySQL server has gone away (TimeoutError(110, 'Connection timed out'))")

Search result:

• https://github.com/dpgaspar/Flask-AppBuilder/issues/1038 // Check flask-sqlalchemy SQLALCHEMY_POOL_PRE_PING config option.

leads to looking for 'SQLALCHEMY_POOL_PRE_PING':

• https://stackoverflow.com/questions/6471549/avoiding-mysql-server-has-gone-away-on-infrequently-used-python-flask-server // app.config['SQLALCHEMY_ENGINE_OPTIONS'] = {'pool_size' : 100, 'pool_recycle' : 280}
• further information: https://docs.sqlalchemy.org/en/13/core/pooling.html

[MaximilianKromer]

Fix: add app.config['SQLALCHEMY_ENGINE_OPTIONS'] = {'pool_size' : 100, 'pool_recycle' : 280}` to app configuration

[MaximilianKromer]

Configuration for pythonanywhere.com:

• https://help.pythonanywhere.com/pages/UsingSQLAlchemywithMySQL