Mysql Connection Not Available When Use Sqlalchemy(mysql) And Flask

I'm getting this error sometime (sometime is ok, sometime is wrong): sqlalchemy.exc.OperationalError: (OperationalError) MySQL Connection not available. while using session.query

Solution 1:

Make sure the value of ‘pool_recycle option’ is less than your MYSQLs wait_timeout value when using SQLAlchemy ‘create_engine’ function.

engine = create_engine("mysql://username:password@localhost/myDatabase", pool_recycle=3600)

Try to use scoped_session to make your session:

from sqlalchemy.orm import scoped_session, sessionmaker
session = scoped_session(sessionmaker(autocommit=False, autoflush=False, bind=engine))

and close/remove your session after retrieving your data.

session.query(Foo).all()
session.close()