Validate if all vcfapostgres pods are in 'Replica' state with no 'leader' in VCF Automation postgres cluster.
Running kubectl exec -n prelude vcfapostgres-0 -- patronictl list would list all vcfapostgres pods in Replica role.
VCF Automation 9.x
This is a rare condition and Broadcom Engineering team is yet to determine possible cause.
Resolution involves interacting with DB cluster, for further assistance on this situation contact Broadcom Support team.
Creating and managing Broadcom support request (SR) cases