MIME-Version: 1.0
References: <CACgY3QYe3mqMkODOzwx=EN4iGoddObUotLL8hGnCg==3vmxd_g@mail.gmail.com>
In-Reply-To: <CACgY3QYe3mqMkODOzwx=EN4iGoddObUotLL8hGnCg==3vmxd_g@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sun, 25 Aug 2024 10:31:02 -0400
Message-ID: <CANzqJaArn7Ubn6U_Ny9CSUpEjJ3rN5erE92g7fo_aO9cm8Fpwg@mail.gmail.com>
Subject: Re: ERROR: could not open relation with OID XXXX
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000047f8df062082dccd"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaArn7Ubn6U_Ny9CSUpEjJ3rN5erE92g7fo_aO9cm8Fpwg%40mail.gmail.com>
Precedence: bulk

--00000000000047f8df062082dccd
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, Aug 25, 2024 at 9:42=E2=80=AFAM Marcelo Zabani <mzabani@gmail.com> =
wrote:

> Hi all,
>
> I can reproduce the error in the subject from time to time when querying
> catalog tables while DDL is happening concurrently. Here's a bash script
> that reproduces it (not always, you might have to run it many times until
> you see ERROR:  could not open relation with OID XXXX):
>
[snip]

> I've seen this happen in Production without pg_sleep in the mix, too. I
> added pg_sleep to the example above only because it makes the error easie=
r
> to reproduce.
>

What version (including minor number)?


> Is there something I can do to avoid this? Is my understanding of how the
> catalog tables work wrong?
>

Just out of curiosity, *WHY* do you do this?  It's never occurred to me to
do that; maybe it's something useful that I've been overlooking.

--=20
Death to America, and butter sauce.
Iraq lobster!

--00000000000047f8df062082dccd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sun, Aug 25, 2024 at 9:42=E2=80=AFAM M=
arcelo Zabani &lt;<a href=3D"mailto:mzabani@gmail.com">mzabani@gmail.com</a=
>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi all,</div><div><br></div><=
div>I can reproduce the error in the subject from time to time when queryin=
g catalog tables while DDL is happening concurrently. Here&#39;s a bash scr=
ipt that reproduces it (not always, you might have to run it many times unt=
il you see ERROR: =C2=A0could not open relation with OID XXXX):</div></div>=
</blockquote><div>[snip]=C2=A0</div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr"><div></div><div>I&#39;ve seen this happen in Pr=
oduction without pg_sleep in the mix, too. I added pg_sleep to the example =
above only because it makes the error easier to reproduce.</div></div></blo=
ckquote><div><br></div><div>What version (including minor number)?</div><di=
v>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"ltr"><div>Is there something I can do to avoid this? Is my understanding o=
f how the catalog tables work wrong?</div></div></blockquote></div><div><br=
></div><div>Just out of curiosity, <b>WHY</b>=C2=A0do you do this?=C2=A0 It=
&#39;s never occurred to me to do that; maybe it&#39;s something useful tha=
t I&#39;ve been overlooking.</div><div><br></div><span class=3D"gmail_signa=
ture_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div =
dir=3D"ltr">Death to America, and butter sauce.<div>Iraq lobster!</div></di=
v></div></div>

--00000000000047f8df062082dccd--