MIME-Version: 1.0
References: <CAEzWdqeNp1HRJt7SkQxANB60CMhrGuJsRKtEpu-Ghb_nXUvgoQ@mail.gmail.com>
In-Reply-To: <CAEzWdqeNp1HRJt7SkQxANB60CMhrGuJsRKtEpu-Ghb_nXUvgoQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 9 Jan 2025 11:48:52 -0500
Message-ID: <CANzqJaAXC8cpJgOvynFWAaEyaux_0r+7=dr4gaDOrk7wMw648A@mail.gmail.com>
Subject: Re: recovery error while running any statement
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006c8963062b48c163"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAXC8cpJgOvynFWAaEyaux_0r%2B7%3Ddr4gaDOrk7wMw648A%40mail.gmail.com>
Precedence: bulk

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

On Thu, Jan 9, 2025 at 11:42=E2=80=AFAM yudhi s <learnerdatabase99@gmail.co=
m> wrote:

> Hello Experts,
> It's postgres aurora version 16. While  running the ALTER command on any
> object we see an error "*Only RowExclusiveLock or less can be acquired on
> database objects during recovery*". If I run any DML it gives an error
> stating '*cannot execute UPDATE in a read-only transaction*' , then I
> tried setting "*set transaction read-write*" and it erroring out with "*c=
annot
> set transaction read-write mode during recovery*".
>
> Want to understand , what is the cause of this error and how to fix this?
>

The cause of the error is that the instance is in recovery mode, just like
the error message says.

Is your system a cluster?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Jan 9, 2025 at 11:42=E2=80=AFAM y=
udhi s &lt;<a href=3D"mailto:learnerdatabase99@gmail.com">learnerdatabase99=
@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_contai=
ner"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hel=
lo Experts,<div>It&#39;s postgres aurora version 16. While=C2=A0 running th=
e ALTER command on any object we see an error &quot;<i>Only RowExclusiveLoc=
k or less can be acquired on database objects during recovery</i>&quot;. If=
 I run any DML it gives an error stating &#39;<i>cannot execute UPDATE in a=
 read-only transaction</i>&#39; , then I tried setting &quot;<i>set transac=
tion read-write</i>&quot; and it erroring out with &quot;<i>cannot set tran=
saction read-write mode during recovery</i>&quot;.</div><div><br></div><div=
>Want to understand=C2=A0, what is the cause of this error and how to fix t=
his?</div></div></blockquote><div><br></div><div>The cause of the error is =
that the instance is in recovery mode, just like the error message says.</d=
iv><div><br></div><div>Is your system a cluster?</div><div><br></div></div>=
<span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=
=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter=
 sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redact=
ed&gt; lobster!</div></div></div></div></div></div>

--0000000000006c8963062b48c163--