Postgres Pro
Downloads
Home   >   mailing lists

including pid's for `There are XX other sessions using the database` - Mailing list pgsql-hackers

From Zhihong Yu
Subject including pid's for `There are XX other sessions using the database`
Date
Msg-id CALNJ-vS9Wc_KEOBR9mwFU=kuW_exup0Jagv6HFeD-fM9GWHJzA@mail.gmail.com
Whole thread Raw
Responses Re: including pid's for `There are XX other sessions using the database`
List pgsql-hackers
Tree view
Hi,
Currently errdetail_busy_db() only shows the number of other sessions using the database but doesn't give any detail about them.
For one of the customers,pg_stat_activity is showing lower number of connections compared to the number revealed in the error message.

Looking at CountOtherDBBackends(), it seems proc->pid is available when nbackends is incremented.

I want to poll the community on whether including proc->pid's in the error message would be useful for troubleshooting.

Thanks

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Doc patch
Next
From: mahendrakar s
Date:
Subject: Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory