vCenter 6.7 vcsa vpxd service wont start due to /storage/seat disk full

Reference:

vCenter 6.7 vcsa vpxd service wont start due to /storage/seat disk full

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

https://communities.vmware.com/thread/560901

=====================

“/storage/seat” full will make the vpxd cannot start

You can find the Error in the vpxd.log

# cat vpxd.log | grep "Error" 
2019-10-03T15:40:18.849-07:00 error vpxd[04944] [Originator@6876 sub=vpxdVdb] Shutting down the VC as there is not enough free space for the Database(used: 95%; threshold: 95%).

Connect to the VCDB by running following command:

/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres

After logging into the pgdb I started running the following command

truncate table vpx_event_1 cascade;

after running it for about 10 tables I could see space cleanup to 90%

The quick way to cleanup all the events tables.

DO
$$
DECLARE
    rec   record;
BEGIN
   FOR rec IN
      SELECT *
      FROM   pg_tables
      WHERE tablename ~ '^vpx_event_[0-9].*'
      ORDER  BY tablename
   LOOP
      EXECUTE 'TRUNCATE TABLE '
        || quote_ident(rec.schemaname) || '.'
        || quote_ident(rec.tablename) || ' CASCADE';
   END LOOP;
END$$;

And one for vpx_event_arg

DO
$$
DECLARE
    rec   record;
BEGIN
   FOR rec IN
      SELECT *
      FROM   pg_tables
      WHERE tablename ~ '^vpx_event_arg_[0-9].*'
      ORDER  BY tablename
   LOOP
      EXECUTE 'TRUNCATE TABLE '
        || quote_ident(rec.schemaname) || '.'
        || quote_ident(rec.tablename) || ' CASCADE';
   END LOOP;
END$$;

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com 標誌

您的留言將使用 WordPress.com 帳號。 登出 /  變更 )

Google photo

您的留言將使用 Google 帳號。 登出 /  變更 )

Twitter picture

您的留言將使用 Twitter 帳號。 登出 /  變更 )

Facebook照片

您的留言將使用 Facebook 帳號。 登出 /  變更 )

連結到 %s

在WordPress.com寫網誌.

向上 ↑

%d 位部落客按了讚: