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

Products

• VMware vCenter Server

Issue/Introduction

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

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

Environment

VMware vCenter Server Appliance 6.0.x
VMware vCenter Server Appliance 5.5.x

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

Additional Information

Backing up and restoring the vCenter Server Appliance 5.x vPostgres database
vCenter Server Appliance 5.5 Update 2 へのアップグレード後に、pg_log ファイルに次のエラーが報告される： WARNING: there is already a transaction in progress
vCenter Server Appliance 出现警告: 已存在进行中的事务