Re: Outage caused by query in IPC:MessageQueueReceive wait????

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема Re: Outage caused by query in IPC:MessageQueueReceive wait????
Дата
Msg-id 33F68D47-1D2D-4DB8-B753-BE83A3FA653E@aweber.com
обсуждение исходный текст
Ответ на Outage caused by query in IPC:MessageQueueReceive wait????  (Chris Hoover <chrish@aweber.com>)
Список pgsql-admin
Дерево обсуждения
Forgot to mention, this is on PG 16.1

Thanks,


Chris Hoover
Senior DBA
AWeber.com
Cell: (803) 528-2269
Email: chrish@aweber.com



On Jun 14, 2024, at 12:52 PM, Chris Hoover <chrish@aweber.com> wrote:

All,

We had an outage today that appears to have been caused by a query in "IPC:MessageQueueReceive” wait state blocking another query from completing a truncate.  

Is there anyway to figure out what exactly it was waiting on other than an IPC message?  I’m trying to get to the true root cause of our outage.

Thanks,


Chris Hoover
Senior DBA
AWeber.com
Cell: (803) 528-2269
Email: chrish@aweber.com




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

Предыдущее
От: Chris Hoover
Дата:
Сообщение: Outage caused by query in IPC:MessageQueueReceive wait????
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Keepalive