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?
