MIME-Version: 1.0
From: yudhi s <learnerdatabase99@gmail.com>
Date: Thu, 9 Jan 2025 22:12:13 +0530
Message-ID: <CAEzWdqeNp1HRJt7SkQxANB60CMhrGuJsRKtEpu-Ghb_nXUvgoQ@mail.gmail.com>
Subject: recovery error while running any statement
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ce76cb062b48a9c5"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqeNp1HRJt7SkQxANB60CMhrGuJsRKtEpu-Ghb_nXUvgoQ%40mail.gmail.com>
Precedence: bulk

--000000000000ce76cb062b48a9c5
Content-Type: text/plain; charset="UTF-8"

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 "*cannot
set transaction read-write mode during recovery*".

Want to understand , what is the cause of this error and how to fix this?

Regards
Yudhi

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

<div dir=3D"ltr">Hello Experts,<div>It&#39;s postgres aurora version 16. Wh=
ile=C2=A0 running the ALTER command on any object we see an error &quot;<i>=
Only RowExclusiveLock or less can be acquired on database objects during re=
covery</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 transaction read-write</i>&quot; and it erroring out with &quo=
t;<i>cannot set transaction read-write mode during recovery</i>&quot;.</div=
><div><br></div><div>Want to understand=C2=A0, what is the cause of this er=
ror and how to fix this?</div><div><br></div><div>Regards</div><div>Yudhi</=
div></div>

--000000000000ce76cb062b48a9c5--