Symptoms
- VM Directory Import is successful
- Virtual Machines are imported but Hosts appear to have failed.
- vHost Inspector tab does either disappears if it previously was there or does not show up.
Solution
Summary
vHost Inspector tab disappears post upgrade with vm directory already configured.
An issue occurs where the hoststats tables in the back end do not complete their configuration.
Fix
Logon to the database appliance, that can be either on the HUB or Remote Database depending on the deployment type and execute the following commands as root to rebuild those tables.
This is a new bug compared to: https://www.liquidware.com/support/articles/360042559172-Stratusphere-6-1-4-VM-Directory-Import-Success-but-Host-not-Imported
- If you ran the command and received a ROLLBACK error follow these steps:
-
Run the following to rebuild the tables:
Putty in as friend / sspassword
Switch to root using this command: su -
Then run the command: echo " begin; select partman.create_parent('tnt_audit.hoststats', 'end_date', 'partman', 'daily'); commit;"| sudo su - postgres -c 'psql portal'
- If you see another rollback, ie:
ERROR: trigger "hoststats_part_trig" for relation "hoststats" already exists
CONTEXT: SQL statement "CREATE TRIGGER hoststats_part_trig BEFORE INSERT ON tnt_audit.hoststats FOR EACH ROW EXECUTE PROCEDURE tnt_audit.hoststats_part_trig_func()"
PL/pgSQL function create_trigger(text) line 43 at EXECUTE
SQL statement "SELECT partman.create_trigger(p_parent_table)"
PL/pgSQL function partman.create_parent(text,text,text,text,text[],integer,text,text,boolean,text,text,text[],boolean,text,boolean,boolean) line 735 at PERFORM
DETAIL:
HINT:
CONTEXT: PL/pgSQL function partman.create_parent(text,text,text,text,text[],integer,text,text,boolean,text,text,text[],boolean,text,boolean,boolean) line 770 at RAISE
ROLLBACK
portal=#
Run the following as it appears it is partially setup and check if the tables exist:
sudo echo "begin; drop trigger if exists hoststats_part_trig on tnt_audit.hoststats; select partman.create_parent('tnt_audit.hoststats', 'end_date', 'partman', 'daily'); commit;"| sudo su - postgres -c 'psql portal'
portal=# begin; drop trigger if exists hoststats_part_trig on tnt_audit.hoststats; select partman.create_parent('tnt_audit.hoststats', 'end_date', 'partman', 'daily'); commit; BEGIN DROP TRIGGER create_parent --------------- t (1 row)
COMMIT portal=#
sudo echo "\d tnt_audit.hoststats;"| sudo su - postgres -c 'psql portal'
tnt_audit.hoststats
tnt_audit.hoststats_end_time_idx
tnt_audit.hoststats_p2020_10_23
tnt_audit.hoststats_p2020_10_23_end_date_idx
tnt_audit.hoststats_p2020_10_23_pkey
tnt_audit.hoststats_p2020_10_23_start_date_idx
tnt_audit.hoststats_p2020_10_23_vmhost_id_idx
tnt_audit.hoststats_p2020_10_24
tnt_audit.hoststats_p2020_10_24_end_date_idx
tnt_audit.hoststats_p2020_10_24_pkey
tnt_audit.hoststats_p2020_10_24_start_date_idx
tnt_audit.hoststats_p2020_10_24_vmhost_id_idx
tnt_audit.hoststats_p2020_10_25
tnt_audit.hoststats_p2020_10_25_end_date_idx
tnt_audit.hoststats_p2020_10_25_pkey
tnt_audit.hoststats_p2020_10_25_start_date_idx
tnt_audit.hoststats_p2020_10_25_vmhost_id_idx
tnt_audit.hoststats_p2020_10_26
tnt_audit.hoststats_p2020_10_26_end_date_idx
tnt_audit.hoststats_p2020_10_26_pkey
tnt_audit.hoststats_p2020_10_26_start_date_idx
tnt_audit.hoststats_p2020_10_26_vmhost_id_idx
tnt_audit.hoststats_p2020_10_27
tnt_audit.hoststats_p2020_10_27_end_date_idx
tnt_audit.hoststats_p2020_10_27_pkey
tnt_audit.hoststats_p2020_10_27_start_date_idx
tnt_audit.hoststats_p2020_10_27_vmhost_id_idx
tnt_audit.hoststats_p2020_10_28
Product: Stratusphere FIT/UX
Product Version: 6.1.5
Expires on: 365 days from publish date
Updated: October 29 2020