>> I have a PostgreSQL 10.12 server running on an Ubuntu 18.04 Server. Since >> today, I am suddenly getting errors when querying data from a Python script >> running on the same machine, and in some edge cases also in pgAdmin 4. >> >> In about 50% of the cases, my Python script will fail to return any data >> because the DB server closed the connection. I am using psycopg2 and it is >> giving me the following error: >> >> psycopg2.errors.AdminShutdown: terminating connection due to administrator >> command >> server closed the connection unexpectedly >> This probably means the server terminated abnormally >> before or while processing the request. >>
On Thu, 9 Apr 2020 at 00:15, Hamid Akhtar <hamid.akhtar@gmail.com> wrote: > > Unfortunately, there isn't enough information here for anybody to reproduce the issue. > Perhaps you can start by validating your own environment for any changes since the > database server was running fine for almost a month before you started seeing this > issue. > > For anybody to be of any help, they'll need complete steps to reproduce this issue, > and a core dump that carries enough debugging information to track the problem.
Weirdly enough, we have received a handful of bug reports in the last 24 hours about unexpected disconnections:
