Postgres Pro
Downloads
Home   >   mailing lists

Outage caused by query in IPC:MessageQueueReceive wait???? - Mailing list pgsql-admin

From Chris Hoover
Subject Outage caused by query in IPC:MessageQueueReceive wait????
Date
Msg-id A2F12A32-848A-4540-A34B-0E2431ACC88A@aweber.com
Whole thread Raw
Responses Re: Outage caused by query in IPC:MessageQueueReceive wait????
List pgsql-admin
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Keepalive
Next
From: Chris Hoover
Date:
Subject: Re: Outage caused by query in IPC:MessageQueueReceive wait????