ACIM Personal Knowledgebase

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== vCenter 5x cleanup ======


===== Symptoms =====

After upgrading to vCenter Server Appliance 5.5 update 2, you experience these symptoms:
The vCenter Server Appliance fails or becomes unresponsive
In the /storage/db/vpostgres/pg_log file, you see large number of entries similar to:

<note warning>WARNING: there is already a transaction in progress</note>
==== Purpose ====

This issue is resolved in vCenter Server 5.5 Update 3b.
===== Cause =====

In the vCenter Server Appliance 5.5 update 2, the ODBC driver used to connect to the embedded vCenter Server database was updated to vPostgres ODBC 9.0.17.0 to correct a runtime error in previous versions of the vCenter Server Appliance. However, the current version installed has led to an increase in logging in the pg_log file.
Resolution
This issue is resolved in vCenter Server 5.5 Update 3b, available at VMware Downloads.

To work around this issue if you do not want to upgrade, modify the message level of the postgresql.conf file to error.

To modify the postgresql.conf file:
Backup the vpostgres database or create a snapshot of the virtual machine. For more information, see Backing up and restoring the vCenter Server Appliance vPostgres database (2034505).
Log in to the vCenter Server Appliance console as root.
Run this command to stop the VMware VitrualCenter Server service:

<code bash>
service vmware-vpxd stop
</code>

Run this command to stop the embedded vCenter Server database service:

<code bash>
service vmware-vpostgres stop
</code>

Run this command to backup the original postgresql.conf file:

<code bash>
cp /storage/db/vpostgres/postgresql.conf /storage/db/vpostgres/postgresql.conf.orig
</code>

Open the /storage/db/vpostgres/postgresql.conf file in a text editor and locate this line:

<note important>Note: On a default install, this line is located on line number 312.</note>

<code bash>
log_min_messages = warning
</code>

Modify the line from step 5 to:

<code bash>
#log_min_messages = warning
log_min_messages = error
</code>

Save the changes and exit the text editor. 

Remove all but the two newest log files from the /storage/db/vpostgres/pg_log file using the rm command:

For example:

<code bash>
rm /storage/db/vpostgres/pg_log/postgresql-YYYY-MM-DD_xxxxxx.log
</code>

Run this command to start the embedded vCenter Server database service:

<code bash>
service vmware-vpostgres start
</code>

Run this command to start the VMware VirtualCenter Server service:

<code bash>
service vmware-vpxd start
</code>
ACIM Personal Knowledgebase

User Tools

Site Tools

Page Tools
