Shulou(Shulou.com)06/01 Report--

The main content of this article is to explain "what to do when the vcenter postgresql space is full and cannot be started". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn what to do if the vcenter postgresql space is full and you can't start it.

Vcenter now only supports postgresql and oracle. Embed's vpostgresql is used.

One day, I suddenly found that the vcenter service could not be connected. After logging in to the server, it was found that the / storage/db space was 100% used.

Temporary recovery, that's how I deal with it.

1. Mount a larger disk, partition, and format to vcenter.

2. Then copy everything under / storage/db to the new partition cp-P-r

3. Modify / etc/fstab to mount the new partition instead of the original partition to / storage/db

4. Restart

At this time, it can start normally, and it is found that / storage/db growth is still very rapid. A few gigabytes a day, I can't stop at all.

Referring to the relevant articles, it is said that it is necessary to control the transaction level of the database log, the recording cycle, and so on.

Log in to vpostgresql

Cd / opt/vmware/vpostgres/9.0/bin

. / psql-U vc-W VDBC

This password is stored in / etc/vmware-VPX/embeddb. In the cfg file, but I didn't enter the password.

Use

SELECT relname, relpages FROM pg_class ORDER BY relpages DESC

Which table can be viewed takes up the most space?

I'm here with VPX_EVENT_ARG.

No way out

Truncate VPX_EVENT_ARG

50 gigabytes of space was released at once.

Http://www.vmware.com/cn/support/support-resources/pubs/vsphere-esxi-vcenter-server-pubs/vsphere-vcenter-server-55u2-release-notes.html#resolvedissues

This issue is mentioned in, but vmware can only provide a warning.

Http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2078305

Http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1025914

Http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1007453

Http://pubs.vmware.com/vsphere-55/index.jsp?topic=%2Fcom.vmware.vsphere.vcenterhost.doc%2FGUID-84DE30DD-E1C4-4E6D-899D-4756FE77CB15.html

The above are some related articles

But the reason for the growth of the database has not been found yet.

I suspect it has something to do with the management software such as third-party vshield vswitch integrated in vcenter.

The only way I can think of right now is

Observe the growth rate of the database, make sure there is enough space, write a script, and execute truncate-related tables regularly.

The script to clear the data is as follows

#! / bin/bash

Cd / opt/vmware/vpostgres/9.0/bin

Service vmware-vpxd stop

. / psql-U root-w-d VCDB-- command "truncate vpx_event,vpx_event_arg,vpx_entity_last_event;"

Service vmware-vpxd start

Then set it to execute the script automatically on a regular basis.

At this point, I believe that everyone has a deeper understanding of "what to do when the vcenter postgresql space is full and cannot be started". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.