So I noticed an issue when using the vSphere Client to connect to the VMware vCenter Server Appliance was appearing every now and again.
Call “EventHistoryCollector.SetLatestPageSize” for object “SessionID” on vCenter Server “ServerName” failed. (unfortunately didnt take a screenshot, so here’s one I found and modified).
This issue is pretty common, and is to do with the amount of events in the database not being purged, and is covered by VMware in this KB article for windows environments.
However not so commonly covered for the vCenter Appliance which uses a progress database.
After a bit of digging around, I found the following crude solution on the VMware communities board.
So open up a console to your VCSA, login in. Run the following commands
/opt/vmware/vpostgres/1.0/bin/psql -d VCDB vc TRUNCATE TABLE vpx_event CASCADE;
then to exit “\q”
If your interested in some commands for the postgres, see here, but use at your peril!
Dean
good day
i’m have a vm vcenter OS OpenSuse 11 and when i’m enter this command, return this error:
/opt/vmware/vpostgres/1.0/bin/psql -d VCDB vc TRUNCATE TABLE vpx_event CASCADE;
psql: warning: extra command-line argument “TRUNCATE” ignored
psql: warning: extra command-line argument “TABLE” ignored
psql: warning: extra command-line argument “vpx_event” ignored
psql: warning: extra command-line argument “CASCADE” ignored
psql (9.0.4)
Type “help” for help.
help please/
Hi,
you need to do seperate the lines
So first
/opt/vmware/vpostgres/1.0/bin/psql -d VCDB vc
Then
TRUNCATE TABLE vpx_event CASCADE;
Please see the picture in the post as well,
we also do a
TRUNCATE TABLE vpx_event_arg CASCADE;
Cheers for that, I’ve only come across this issue once so far, but I believe when upgrading the VCSA from 5.1 to 5.5 it fills the internal hard drive, with log files.
Slightly different to this issue, but highlights why the self contained appliance, sometimes isn’t a great thing, especially for those with little or no linux experience
Thanks! my second digging “session” found this page and it worked.
great to hear!
This had been frustrating me for a while, thank you!
glad to have helped
exit “\q”
cheers, changed within the post