Re: Backends stunk in wait event IPC/MessageQueueInternal

Поиск
Список
Период
Сортировка
От Japin Li
Тема Re: Backends stunk in wait event IPC/MessageQueueInternal
Дата
Msg-id MEYP282MB166970528785F7FD13F9BC58B6CA9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: Backends stunk in wait event IPC/MessageQueueInternal  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
On Fri, 13 May 2022 at 19:41, Justin Pryzby <pryzby@telsasoft.com> wrote:
> On Fri, May 13, 2022 at 06:16:23PM +0800, Japin Li wrote:
>> I had an incident on my Postgres 14 that queries hung in wait event
>> IPC / MessageQueueInternal, MessageQueueReceive.  It likes [1],
>> however, it doesn't have any discussions.
>
> If the process is still running, or if the problem recurs, I suggest to create
> a corefile with gcore, aka gdb generate-core-file.  Then, we can look at the
> backtrace at our leisure, even if the cluster needed to be restarted right
> away.
>

Thanks for your advice, I will try it later.

> What minor version of postgres is this, and what OS ?

PostgreSQL 14.2 and Solaris.

--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Maxim Orlov
Дата:
Сообщение: Re: Add 64-bit XIDs into PostgreSQL 15
Следующее
От: Maxim Orlov
Дата:
Сообщение: Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)