From: Chris Hoover <chrish@aweber.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Outage caused by query in IPC:MessageQueueReceive wait????
Date: Fri, 14 Jun 2024 13:02:54 -0400
Message-ID: <33F68D47-1D2D-4DB8-B753-BE83A3FA653E@aweber.com> (raw)
In-Reply-To: <A2F12A32-848A-4540-A34B-0E2431ACC88A@aweber.com>
References: <A2F12A32-848A-4540-A34B-0E2431ACC88A@aweber.com>
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
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: chrish@aweber.com, pgsql-admin@lists.postgresql.org
Subject: Re: Outage caused by query in IPC:MessageQueueReceive wait????
In-Reply-To: <33F68D47-1D2D-4DB8-B753-BE83A3FA653E@aweber.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox