VPX_TEXT_ARRAY table growth causes the vCenter Server database to run out of space

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• VPX_TEXT_ARRAY table increases over time
• The VMware VirtualCenter Server service fails
• This issue occurs when the vCenter Server database is full
• Purging old data from the database used by the vCenter Server does not resolve the issue
• Shrinking the data from the database does not resolve the issue
• Shrinking the transaction logs does not help in reducing the database size

Environment

VMware vCenter Server 6.5.x

Cause

The VPX_TEXT_ARRAY table growth is due to latent snapshot data.  This is due to a failed hostsync which will fail to update VC and as a result latent data will be left in the VPX_TEXT_ARRAY table eventually culminating in the table growth.

Resolution

This issue is resolved in vSphere 6.5 U3 available at VMware Download.

Additional Information

https://kb.vmware.com/s/article/2005333