Re: Backends stunk in wait event IPC/MessageQueueInternal - Mailing list pgsql-hackers

From Japin Li
Subject Re: Backends stunk in wait event IPC/MessageQueueInternal
Date
Msg-id MEYP282MB166970528785F7FD13F9BC58B6CA9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Backends stunk in wait event IPC/MessageQueueInternal  (Justin Pryzby <pryzby@telsasoft.com>)
List 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 by date:

Previous
From: Maxim Orlov
Date:
Subject: Re: Add 64-bit XIDs into PostgreSQL 15
Next
From: Maxim Orlov
Date:
Subject: Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)