Backends stunk in wait event IPC/MessageQueueInternal

Поиск
Список
Период
Сортировка
От Japin Li
Тема Backends stunk in wait event IPC/MessageQueueInternal
Дата
Msg-id MEYP282MB1669C8D88F0997354C2313C1B6CA9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: Backends stunk in wait event IPC/MessageQueueInternal  (Justin Pryzby <pryzby@telsasoft.com>)
Re: Backends stunk in wait event IPC/MessageQueueInternal  (Robert Haas <robertmhaas@gmail.com>)
Список 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!

[1] https://www.postgresql.org/message-id/flat/E9FA92C2921F31408041863B74EE4C2001A479E590%40CCPMAILDAG03.cantab.local

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



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

Предыдущее
От: "shiy.fnst@fujitsu.com"
Дата:
Сообщение: RE: Perform streaming logical transactions by background workers and parallel apply
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Backends stunk in wait event IPC/MessageQueueInternal