Search the VMware Knowledge Base (KB)
View by Article ID

Warning: "there is already a transaction in progress" in vCenter Server Appliance (2092127)

  • 21 Ratings

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:

    WARNING: there is already a transaction in progress

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:
  1. 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).
  2. Log in to the vCenter Server Appliance console as root.
  3. Run this command to stop the VMware VitrualCenter Server service:

    service vmware-vpxd stop

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

    service vmware-vpostgres stop

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

    cp /storage/db/vpostgres/postgresql.conf /storage/db/vpostgres/postgresql.conf.orig

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

    Note: On a default install, this line is located on line number 312.

    log_min_messages = warning

  7. Modify the line from step 5 to:

    #log_min_messages = warning
    log_min_messages = error


  8. Save the changes and exit the text editor.

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

    For example:

    rm /storage/db/vpostgres/pg_log/postgresql-YYYY-MM-DD_xxxxxx.log

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

    service vmware-vpostgres start

  11. Run this command to start the VMware VirtualCenter Server service:

    service vmware-vpxd start

Tags

Warning after upgrading to vCenter Server Appliance 5.5 U2

See Also

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 21 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 21 Ratings
Actions
KB: