Re: Outage caused by query in IPC:MessageQueueReceive wait????
| От | Chris Hoover |
|---|---|
| Тема | Re: Outage caused by query in IPC:MessageQueueReceive wait???? |
| Дата | |
| Msg-id | 464C0807-4299-42B4-81E8-AC8D016C3AC7@aweber.com обсуждение исходный текст |
| Ответ на | Outage caused by query in IPC:MessageQueueReceive wait???? (Chris Hoover <chrish@aweber.com>) |
| Список | pgsql-admin |
Yes, it appeared to be in a transaction. The pg_stat_activity.xact_start was before the query_start. Unfortunately, I don’t have the other queries. (I snapshot pg_stat_activity every minute, so it missed any prior queries to the blocker).
Thanks,
Chris Hoover
Senior DBA
AWeber.com
Cell: (803) 528-2269
Email: chrish@aweber.com
On Jun 14, 2024, at 2:16 PM, Ozgur Kulu <kuluozgur@gmail.com> wrote:Hi chris,Is this query in transaction block ?14 Haz 2024 Cum 20:03 tarihinde Chris Hoover <chrish@aweber.com> şunu yazdı:Forgot to mention, this is on PG 16.1On 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.
В списке pgsql-admin по дате отправления: