including pid's for `There are XX other sessions using the database`

Поиск
Список
Период
Сортировка
От Zhihong Yu
Тема including pid's for `There are XX other sessions using the database`
Дата
Msg-id CALNJ-vS9Wc_KEOBR9mwFU=kuW_exup0Jagv6HFeD-fM9GWHJzA@mail.gmail.com
обсуждение исходный текст
Ответы Re: including pid's for `There are XX other sessions using the database`  ("Euler Taveira" <euler@eulerto.com>)
Список pgsql-hackers
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Doc patch
Следующее
От: mahendrakar s
Дата:
Сообщение: Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory