From: | Japin Li <japinli(at)hotmail(dot)com> |
---|---|
To: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Backends stunk in wait event IPC/MessageQueueInternal |
Date: | 2022-05-13 10:16:23 |
Message-ID: | MEYP282MB1669C8D88F0997354C2313C1B6CA9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi, hackers
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.
The process cannot be terminated by pg_terminate_backend(), although
it returns true.
Here is the call stack comes from pstack:
485073: /opt/local/pgsql/14/bin/postgres
fffffb7fef216f4a ioctl (d, d001, fffffb7fffdfa0e0)
00000000008b8ec2 WaitEventSetWait () + 112
00000000008b920f WaitLatch () + 6f
00000000008bf434 shm_mq_wait_internal () + 64
00000000008bff74 shm_mq_receive () + 2b4
000000000079fdc8 TupleQueueReaderNext () + 28
000000000077d8ca gather_merge_readnext () + 13a
000000000077db25 ExecGatherMerge () + 215
0000000000790675 ExecNextLoop () + 175
0000000000790675 ExecNextLoop () + 175
000000000076267d standard_ExecutorRun () + fd
fffffb7fe3965fbd pgss_executorRun () + fd
00000000008df99b PortalRunSelect () + 1cb
00000000008e0dcf PortalRun () + 17f
00000000008ddacd PostgresMain () + 100d
0000000000857f62 ServerLoop () + cd2
0000000000858cee main () + 453
00000000005ab777 _start_crt () + 87
00000000005ab6d8 _start () + 18
Any suggestions? Thanks in advance!
--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2022-05-13 11:41:19 | Re: Backends stunk in wait event IPC/MessageQueueInternal |
Previous Message | shiy.fnst@fujitsu.com | 2022-05-13 09:57:15 | RE: Perform streaming logical transactions by background workers and parallel apply |