From: | Japin Li <japinli(at)hotmail(dot)com> |
---|---|
To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Backends stunk in wait event IPC/MessageQueueInternal |
Date: | 2022-05-13 13:13:59 |
Message-ID: | MEYP282MB166970528785F7FD13F9BC58B6CA9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 13 May 2022 at 19:41, Justin Pryzby <pryzby(at)telsasoft(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Maxim Orlov | 2022-05-13 13:21:29 | Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) |
Previous Message | Maxim Orlov | 2022-05-13 13:11:08 | Re: Add 64-bit XIDs into PostgreSQL 15 |