vCenter: ERROR: could not open file "xxx": No such file or directory;

created at 08-17-2021 views: 3

error log

2021-08-16T04:19:01.884Z error vpxd[7F4798BA3700] [Originator@6876 sub=Default] [VdbStatement] SQL execution failed: insert into VPX_EVENT_ARG_88 (EVENT_ID, ARG_ID, ARG_TYPE, ARG_DATA, OBJ_TYPE,OBJ_NAME, VM_ID, HOST_ID, COMPUTERESOURCE_ID, DATASTORE_ID, NETWORK_ID,NETWORK_TYPE, DATACENTER_ID, RESOURCEPOOL_ID, DVS_ID,FOLDER_ID, ALARM_ID, SCHEDULEDTASK_ID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2021-08-16T04:19:01.884Z error vpxd[7F4798BA3700] [Originator@6876 sub=Default] [VdbStatement] Execution elapsed time: 0 ms
2021-08-16T04:19:01.884Z error vpxd[7F4798BA3700] [Originator@6876 sub=Default] [VdbStatement] Statement diagnostic data from driver is 58P01:0:7:ERROR: could not open file "pg_tblspc/16398/PG_9.4_201409291/16385/19763": No such file or directory;
--> Error while executing the query

reason

Due to lack of space, the postgres tablespace data file was deleted by mistake.

solution

truncate table VPX_EVENT_ARG_88;

summary

You must be careful when dealing with the lack of space in vCenter, otherwise it will easily crash vCenter and it will be troublesome to restore.

created at:08-17-2021
edited at: 08-17-2021: