Re: recovery error while running any statement

2025-01-09 Thread Ron Johnson
On Thu, Jan 9, 2025 at 12:01 PM yudhi s wrote: > > On Thu, Jan 9, 2025 at 10:21 PM Adrian Klaver > wrote: > >> On 1/9/25 08:42, yudhi s wrote: >> > Hello Experts, >> > It's postgres aurora version 16. While running the ALTER command on >> any >> > object we see an error "/Only RowExclusiveLock

Re: recovery error while running any statement

2025-01-09 Thread Adrian Klaver
On 1/9/25 09:01, yudhi s wrote: On Thu, Jan 9, 2025 at 10:21 PM Adrian Klaver > wrote: On 1/9/25 08:42, yudhi s wrote: > Hello Experts, > It's postgres aurora version 16. While  running the ALTER command on any > object we see an error "

Re: recovery error while running any statement

2025-01-09 Thread yudhi s
On Thu, Jan 9, 2025 at 10:21 PM Adrian Klaver wrote: > On 1/9/25 08:42, yudhi s 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

Re: recovery error while running any statement

2025-01-09 Thread yudhi s
Yes , it's a cluster aurora global database. I am a bit new to this. Can you please explain a bit more, what must be the reason and what should we do to make it back online to serve the queries? It's a non-prod though. On Thu, Jan 9, 2025 at 10:19 PM Ron Johnson wrote: > On Thu, Jan 9, 2025 at 1

Re: recovery error while running any statement

2025-01-09 Thread Adrian Klaver
On 1/9/25 08:42, yudhi s 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 UPDA

Re: recovery error while running any statement

2025-01-09 Thread Ron Johnson
On Thu, Jan 9, 2025 at 11:42 AM yudhi s 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

recovery error while running any statement

2025-01-09 Thread yudhi s
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*' , the