vCenter Server Appliance with embedded vPostgres database crashes due to full database partition
search cancel

vCenter Server Appliance with embedded vPostgres database crashes due to full database partition

book

Article ID: 318753

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

vCenter Server Appliance with embedded vPostgres database stops running. This occurs because a disk partition on the vPostgres database contains no free space. Perform the following checks to verify that the vPostgres database is full:
 
  • Verify that the vpxd service has stopped in the vCenter Server Appliance by running this command:
      service vmware-vpxd status 
  • Verify that the vPostgres service has stopped by running this command:
      service vmware-vpostgres status 
  • Verify that the vPostgres database is full by running this command:
      df -h
 
  • In the vpxd log files, check whether you can see message similar to:
      No Space left on device 
  • In the /storage/db/vpostgres/pg_log/postgresql.log file, you see entries similar to:

    PANIC: could not write to file ... No space left on device
    ERROR: could not extend file ... No space left on device


    Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.  

For more information about log files, see Location of vCenter Server log files (1021804).


Environment

VMware vCenter Server Appliance 5.5.x
VMware vCenter Server Appliance 5.1.x

Resolution

  1. Extend the disk size for the vPostgres database.
    For more information, see Increasing the disk space in vCenter Server Appliance 5.x (2056764).
  2. To prevent full database partition, monitor the vCenter Server Appliance database disk usage and change the vCenter Server data retention settings.

    For more information, see Monitor vCenter Server Appliance database disk usage (2058187).
  3. Delete all obsolete log files from /storage/db/vpostgres/pg_log/
               To delete older log files, perform following command

             find /storage/db/vpostgres/pg_log -name postgresql\*.log -ctime +30 -print -exec rm {} \;

             This will delete all log files older than 30 days.
 

Additional Information

For translated versions of this article, see: