SQLAlchemy - Postgres Connection Issue while running via Flask

Question

Flask with SQLAlchemy Flask==0.10.1 SQLAlchemy==1.0.8

In production after a lot of usages (connection) we are getting this error. After that restarting the server helps, what will be the permanent solution

OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly\n\tThis probably means the server terminated abnormally\n\tbefore or while processing the request.\

Similarly, we are creating a scoped session, we are doing session.close()

I tried Null Pool which doesn't help

Any ideas on that?

Relevant finding Is it odd that my SQLAlchemy MySQL connection always ends up sleeping?

Handle mysql restart in SQLAlchemy

Why someone downvoted? I tried something on my side – Shankar Oct 15 '18 at 14:52 — Shankar, Oct 15 '18 at 14:52

score 0 · Accepted Answer · answered Oct 17 '18 at 05:48

0

We need to handle it in SQLAlchemy Dealing Disconnect

https://docs.sqlalchemy.org/en/latest/core/pooling.html#dealing-with-disconnects

answered Oct 17 '18 at 05:48

Shankar

846
8
24

SQLAlchemy - Postgres Connection Issue while running via Flask

1 Answers1