"VMware Postgres service memory usage has exceeded allocated quota" warning in vCenter Server Appliance 6.0

Products

VMware vCenter Server

Issue/Introduction

Symptoms:
After installing or upgrading to the vCenter Server Appliance 6.0 using an embedded VMware Postgres database, you experience these symptoms:

Under the vCenter Server Alarms, you receive one of these warning messages:

VMware vFabric Postgres (vCenter_Server_Hostname)
vmware-vpostgres status changes from green to yellow
Under the Health Messages for the VMware Postgres service (located at Administration > System Configuration > Services), you see a message similar to:

VMware Postgres memory usage has exceeded allocated quota. Used: xxxxx MB. Quota: xxx MB
In the /etc/vmware-sca/health/vmware-postgres-health-status.xml file, you see entries similar to:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><healthStatus schemaVersion="1.0" xmlns="http://www.vmware.com/cis/cm/common/jaxb/healthstatus"><status>YELLOW</status><message messageKey="cis.vpg.health.mem_quota_exceeded" defaultMessage="VMware Postgres service memory usage has exceeded allocated quota."><param xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">1929<param xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">512</message><expiration>2015-03-19T06:02:10.000Z</expiration></healthStatus>

Environment

VMware vCenter Server Appliance 6.0.x

Resolution

This is a known issue affecting the vCenter Server Appliance 6.0.

This issue is resolved in vCenter Server Appliance 6.0 Update 1. For more information, see the vCenter Server 6.0 Update 1 Release Notes. Download the latest version at Customer Connect.

To workaround this issue with the vCenter Server Appliance:

Note: Performing these disables the VMware Postgres Monitoring agent. When you click on this, it shows the status:

Failed to request health status from URI /etc/vmware-sca/health/vmware-postgres-health-status.xml

Log in to the vCenter Server Appliance using SSH.
Run this command to enable access the Bash shell:

shell.set --enabled true
Type shell and press Enter.
Run this command to disable the periodic health checks:

sed -ie 's/health_status_worker.naptime.*/health_status_worker.naptime = 2147483647/' /storage/db/vpostgres/health_status_worker.conf
Run this command to reload the postgresql configuration::

service vmware-vpostgres reload
Run this command to restart the health status worker process:

pkill -f "postgres: bgworker: health_status_worker"
Run this command to reset the alarm from Unknown to Green:

sed -i -e 's#<status>.*</status>#<status>GREEN</status>#g' -e 's#<message.*message>#<message messageKey="cis.vpg.health.healthy" defaultMessage="VMware Postgres service is healthy."></message>#' -e "s#<expiration.*expiration>#<expiration>$(date +'%FT%T.000Z' -d '+2147483647 seconds')</expiration>#" /etc/vmware-sca/health/vmware-postgres-health-status.xml

To work around this issue with a Windows installed vCenter Server:

Connect to the vCenter Server machine.
Open the C:\ProgramData\VMware\vCenterServer\data\vpostgres\health_status_worker.conf file with a plain text editor.
Search for the line health_status_worker.naptime = 60 in the file.
Change the value to 2147483647.

For example:

health_status_worker.naptime = 2147483647
Restart the vCenter Server and vPostgres services with these commands:
- C:\Program Files\VMware\vCenter Server\bin\> service-control --stop --all
- C:\Program Files\VMware\vCenter Server\bin\> service-control --start --all
  
  Note: For more information on restarting vCenter Server services, see Stopping, starting, or restarting VMware vCenter Server 6.0 services (2109881).

Additional Information

How to stop, start, or restart vCenter Server 6.x services
vCenter Server Appliance 6.0 に警告が表示される: VMware Postgres サービスのメモリ使用量が割り当てられた量を超えました
O vCenter Server Appliance 6.0 exibe o aviso: uso da memória de serviço VMware Postgres excedeu a cota atribuída
vCenter Server Appliance 6.0 muestra la advertencia: VMware Postgres service memory usage has exceeded allocated quota
vCenter Server Appliance 6.0 显示警告： VMware Postgres 服务内存使用量已超过分配的配额