Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1sIAKW-00DbHq-Jm
	for pgsql-admin@arkaria.postgresql.org; Fri, 14 Jun 2024 17:03:12 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1sIAKT-003lnn-SY
	for pgsql-admin@arkaria.postgresql.org; Fri, 14 Jun 2024 17:03:10 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <chrish@aweber.com>)
	id 1sIAKT-003lnB-Gb
	for pgsql-admin@lists.postgresql.org; Fri, 14 Jun 2024 17:03:10 +0000
Received: from mail-qk1-x72d.google.com ([2607:f8b0:4864:20::72d])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <chrish@aweber.com>)
	id 1sIAKR-001JGR-Si
	for pgsql-admin@lists.postgresql.org; Fri, 14 Jun 2024 17:03:09 +0000
Received: by mail-qk1-x72d.google.com with SMTP id
 af79cd13be357-797a7f9b552so153652285a.0
        for <pgsql-admin@lists.postgresql.org>;
 Fri, 14 Jun 2024 10:03:07 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=aweber.com; s=2018090500; t=1718384586; x=1718989386;
 darn=lists.postgresql.org;
        h=message-id:in-reply-to:to:references:date:subject:mime-version:from
         :from:to:cc:subject:date:message-id:reply-to;
        bh=Zjzpn/oJzYQWe8CywOeF/f0wOXIRXEj8/azLPqyCYL4=;
        b=Vz/GNY65mPIGYAtc7XGBapZ4KhfEksVt1Y+NXObenoYwnlNMPFFpaDTgdbgLaYNX9w
         0ErAdiONT6wsOuxDTuaaO9vSIU+DzjG6UyGZ/1+Xkhq1GadywSIDLzOcBI3gBoChB2eh
         JdMSFxcB2932ybbS8tbjKeZ1Q/ES3pZIDRL2UEUvB0d+y+CyHDGWG5fjX3Hyt5cPhgN/
         ruW+toEafhe6461i4z2z/khXI7TMcPoLzE4lQ1pbelwPbWFRXnIkYPiBUWmUVBj77YH8
         FdaML658xeb6/IFUD9Lma2KVmkVpazGF2SF93a8e08o/+CWAJlYSUxGk9/FgT4HlBjpN
         2r9w==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1718384586; x=1718989386;
        h=message-id:in-reply-to:to:references:date:subject:mime-version:from
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=Zjzpn/oJzYQWe8CywOeF/f0wOXIRXEj8/azLPqyCYL4=;
        b=Uy2w/UCxpdQnQDFg9KWY5WhjHpwkzGGNp+uVflPnNfD8vAivhyenFlWupHnMJTwY4E
         rnv/zp8Q/S2DzrTK+fN21ivqzgmOC68R4Q2CIiuCG+g2d0euX4lUXsFW/FCapsxqJJyp
         kNxXrScLXPfUPXDlA3wuxLZfcMZSIDJGmmPRT4y/19euwx3rM7hJBompQsv3u7znr0JZ
         UxF7dOrigjnNHc93pJuBw2H8AXUizdu82/axxPbgVE1olyhpWJeBJuv3iT47Zd04BdqL
         Gqic0snJ8Zd7awBudAObQ5pK9e6eqGd4D+23KQMO6bXebjezVfMMZU6kfuAkxntVGJoc
         tSXw==
X-Gm-Message-State: AOJu0Yx9blfhm57XCgv+Y5s3d7mL/6neWugBcK33EEnuCM8ScyNBQ69e
	zwdZM+UH2ZfQUfJ/ZWGeGt9+++c1gHEDoRZTbc/AN97QqYkmXkmGmCTRoaA6JJvuHnu43NhP55b
	NKfo=
X-Google-Smtp-Source: 
 AGHT+IE2rapCvSue+KSQWjxLBaSsz2qJptrnmbkItXojnS7mQyr/eLFfLwULsNcHSWsyUM/fekQhqg==
X-Received: by 2002:a05:620a:45a7:b0:797:e7dd:96f with SMTP id
 af79cd13be357-798d258ddaamr364918485a.57.1718384585618;
        Fri, 14 Jun 2024 10:03:05 -0700 (PDT)
Received: from smtpclient.apple ([172.59.218.20])
        by smtp.gmail.com with ESMTPSA id
 af79cd13be357-798aacb697csm162082385a.21.2024.06.14.10.03.04
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128);
        Fri, 14 Jun 2024 10:03:05 -0700 (PDT)
From: Chris Hoover <chrish@aweber.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_E4606A0C-23AA-4CFE-A812-653C3D615776"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\))
Subject: Re: Outage caused by query in IPC:MessageQueueReceive wait????
Date: Fri, 14 Jun 2024 13:02:54 -0400
References: <A2F12A32-848A-4540-A34B-0E2431ACC88A@aweber.com>
To: pgsql-admin@lists.postgresql.org
In-Reply-To: <A2F12A32-848A-4540-A34B-0E2431ACC88A@aweber.com>
Message-Id: <33F68D47-1D2D-4DB8-B753-BE83A3FA653E@aweber.com>
X-Mailer: Apple Mail (2.3774.500.171.1.1)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/33F68D47-1D2D-4DB8-B753-BE83A3FA653E%40aweber.com>
Precedence: bulk


--Apple-Mail=_E4606A0C-23AA-4CFE-A812-653C3D615776
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

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=E2=80=AFPM, Chris Hoover <chrish@aweber.com> =
wrote:
>=20
> All,
>=20
> We had an outage today that appears to have been caused by a query in =
"IPC:MessageQueueReceive=E2=80=9D wait state blocking another query from =
completing a truncate. =20
>=20
> Is there anyway to figure out what exactly it was waiting on other =
than an IPC message?  I=E2=80=99m trying to get to the true root cause =
of our outage.
>=20
> Thanks,
>=20
>=20
> Chris Hoover
> Senior DBA
> AWeber.com
> Cell: (803) 528-2269
> Email: chrish@aweber.com
>=20
>=20
>=20


--Apple-Mail=_E4606A0C-23AA-4CFE-A812-653C3D615776
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;">Forgot to =
mention, this is on PG 16.1<div><br =
id=3D"lineBreakAtBeginningOfMessage"><div>
<div>Thanks,</div><div><br></div><div><br></div><div>Chris =
Hoover</div><div>Senior DBA</div><div>AWeber.com</div><div>Cell: (803) =
528-2269</div><div>Email: chrish@aweber.com</div><div><br></div><br =
class=3D"Apple-interchange-newline">

</div>
<div><br><blockquote type=3D"cite"><div>On Jun 14, 2024, at 12:52=E2=80=AF=
PM, Chris Hoover &lt;chrish@aweber.com&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div><meta http-equiv=3D"content-type"=
 content=3D"text/html; charset=3Dutf-8"><div style=3D"overflow-wrap: =
break-word; -webkit-nbsp-mode: space; line-break: =
after-white-space;">All,<div><br></div><div><font>We had an outage today =
that appears to have been caused by a query in "<span =
style=3D"font-family: Slack-Lato, Slack-Fractions, appleLogo, =
sans-serif; font-variant-ligatures: common-ligatures; orphans: 2; =
widows: 2; background-color: rgb(255, 255, 255); =
text-decoration-thickness: initial; text-decoration-style: initial; =
text-decoration-color: initial;">IPC:MessageQueueReceive=E2=80=9D wait =
state blocking another query from completing a truncate. =
&nbsp;</span></font></div><div><span style=3D"font-family: Slack-Lato, =
Slack-Fractions, appleLogo, sans-serif; font-variant-ligatures: =
common-ligatures; orphans: 2; widows: 2; background-color: rgb(255, 255, =
255); text-decoration-thickness: initial; text-decoration-style: =
initial; text-decoration-color: =
initial;"><font><br></font></span></div><div><span style=3D"font-family: =
Slack-Lato, Slack-Fractions, appleLogo, sans-serif; =
font-variant-ligatures: common-ligatures; orphans: 2; widows: 2; =
background-color: rgb(255, 255, 255); text-decoration-thickness: =
initial; text-decoration-style: initial; text-decoration-color: =
initial;"><font>Is there anyway to figure out what exactly it was =
waiting on other than an IPC message? &nbsp;I=E2=80=99m trying to get to =
the true root cause of our outage.</font></span></div><div><div =
style=3D"orphans: 2; widows: 2;"><font color=3D"#37383a" =
face=3D"Slack-Lato, Slack-Fractions, appleLogo, sans-serif"><span =
style=3D"caret-color: rgb(55, 56, 58); font-size: 15px; =
background-color: rgb(255, 255, 255);"><br></span></font></div><div>
<div>Thanks,</div><div><br></div><div><br></div><div>Chris =
Hoover</div><div>Senior DBA</div><div>AWeber.com</div><div>Cell: (803) =
528-2269</div><div>Email: chrish@aweber.com</div><div><br></div><br =
class=3D"Apple-interchange-newline">

</div>

<br></div></div></div></blockquote></div><br></div></body></html>=

--Apple-Mail=_E4606A0C-23AA-4CFE-A812-653C3D615776--