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

From: Chris Hoover <chrish(at)aweber(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Outage caused by query in IPC:MessageQueueReceive wait????
Date: 2024-06-14 16:52:41
Message-ID: A2F12A32-848A-4540-A34B-0E2431ACC88A@aweber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2024-06-14 17:02:54 Re: Outage caused by query in IPC:MessageQueueReceive wait????
Previous Message Tom Lane 2024-06-14 15:28:33 Re: Keepalive