错误日志
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
原因分析
由于空间不足,误操作删除了postgres表空间数据文件。
处理
truncate table VPX_EVENT_ARG_88;
总结
处理vCenter空间不足问题还是要小心些,否则容易将vCenter搞崩溃,恢复起来还是比较麻烦。
参考
https://kb.vmware.com/s/article/2095699
https://www.settlersoman.com/how-to-reclaim-space-on-storageseat-in-vcenter-appliance-5-5-or-6-x/