SDDC Manager UI is inaccessible. Error: 502 Bad Gateway (PostgreSQL Service Down)

Products

• VMware SDDC Manager / VCF Installer

Issue/Introduction

• The SDDC Manager UI is inaccessible, returning a "502 Bad Gateway" error
  
  
• /var/log/vmware/vcf/operationsmanager/operationsmanager.log on SDDC manager throws below error,
  
  SQL Error: 0, SQLState: 08006
[o.h.e.jdbc.spi.SqlExceptionHelper, om-exec-2] An I/O error occurred while sending to the backend.
[c.v.v.p.v.u.ValidateCredentialsTranslationTaskExecutor, om-exec-1] Exception occurred during validate credentials translation task : Error creating bean with name 'liquibase': Singleton bean creation not allowed while singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation!)
org. springframework.beans. factory. BeanCreationNotAllowedException: Error creating bean with name 'liquibase': Singleton bean creation not allowed while singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation! )

Environment

VCF 5.x

Cause

SDDC manager was shutdown during a task in 'In-progress' state. While powering on SDDC manager's postgresSQL service will not starting automatically.

Resolution

To resolve the issue,

1. Start the PostgreSQL service,
   
   systemctl start postgres
   
   
2. Verify the service is active and running,
   
   systemctl status postgres
   
   
3. Restart all SDDC Manager services to ensure fresh initialization and database connection establishment,
   
   /opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh
   
   
4. Verify SDDC Manager UI accessibility.