Re: server closed the connection unexpectedly - bug report - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: server closed the connection unexpectedly - bug report
Date
Msg-id CAKFQuwajrdD53dMwnFsh2vePpzsx1wvsXKDnoZGFqN1P_j-LZQ@mail.gmail.com
Whole thread Raw
In response to Re: server closed the connection unexpectedly - bug report  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses RE: server closed the connection unexpectedly - bug report  (Jiří Ledvinka <ledvinkaj@sci.muni.cz>)
List pgsql-bugs
On Sat, Jun 25, 2022 at 2:11 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Saturday, June 25, 2022, Jiří Ledvinka <ledvinkaj@sci.muni.cz> wrote:

Hello everyone. I have problem with opening DB in pgAdmin. But the DB works normally. See Screenshots and logs.

After update from version 11.10 to 11.16 it didn’t help. pgAdmin also the newest, and other version work either. I cant upgrade to higher version because the SW using this DB isn’t compatible with higher version. Do you thing the solution is to make dump, remove the DB and import DB from the dump.SQL? But there is also TimeScaleDB addon.


Check logs and try just using psql to connect.


So what was process 12228?  Any log messages related to it?  Last server up was 5 minutes before the logs you are showing here.

If indeed it is an attempt by pgAdmin to connect and issue that set of SQL commands causing an access violation does the same violation occur if you emulate it but using psql?

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: server closed the connection unexpectedly - bug report
Next
From: Dave Cramer
Date:
Subject: Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.