From: | Chris Hoover <chrish(at)aweber(dot)com> |
---|---|
To: | Ozgur Kulu <kuluozgur(at)gmail(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Outage caused by query in IPC:MessageQueueReceive wait???? |
Date: | 2024-06-14 18:19:06 |
Message-ID: | 464C0807-4299-42B4-81E8-AC8D016C3AC7@aweber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)aweber(dot)com
> On Jun 14, 2024, at 2:16 PM, Ozgur Kulu <kuluozgur(at)gmail(dot)com> wrote:
>
> Hi chris,
>
> Is this query in transaction block ?
>
> 14 Haz 2024 Cum 20:03 tarihinde Chris Hoover <chrish(at)aweber(dot)com <mailto:chrish(at)aweber(dot)com>> şunu yazdı:
>> Forgot to mention, this is on PG 16.1
>>
>> Thanks,
>>
>>
>> Chris Hoover
>> Senior DBA
>> AWeber.com
>> Cell: (803) 528-2269
>> Email: chrish(at)aweber(dot)com <mailto:chrish(at)aweber(dot)com>
>>
>>
>>
>>> On Jun 14, 2024, at 12:52 PM, Chris Hoover <chrish(at)aweber(dot)com <mailto:chrish(at)aweber(dot)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(at)aweber(dot)com <mailto:chrish(at)aweber(dot)com>
>>>
>>>
>>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Hoover | 2024-06-14 19:47:22 | Re: Outage caused by query in IPC:MessageQueueReceive wait???? |
Previous Message | Laurenz Albe | 2024-06-14 17:47:11 | Re: Keepalive |