Hi all,
I upgraded our installation from 4.2.8 to 4.3.4 and I am unable to access the dashboard
in UI as there is only "Loading data..." displayed. There are postgres processes
running on the engine taking 100% cpu. One is running for more than 14 hours:
SELECT name, AVG(total) AS total, AVG(used) AS used, MAX(previous_used) AS previous_used,
MAX(previous_total) AS previous_total, MAX(vm_disk_
usage_percent) AS usage_percent FROM (SELECT history_datetime, vms.vm_name AS name,
SUM(vm_disk_size_mb) AS total, SUM(vm_disk_actual_size_mb) AS used,
COALESCE(MAX(previous_actual_size), 0)
AS previous_used, COALESCE(MAX(previous_total_size), 0) AS previous_total, CASE WHEN
MAX(vm_disk_size_mb) = 0 THEN 0 ELSE (CAST(MAX(vm_disk_actual_size_mb) AS DECIMAL)/
MAX(vm_disk_size_mb) *
100) END AS vm_disk_usage_percent FROM v4_2_statistics_vms_disks_resources_usage_samples
samples INNER JOIN v4_2_latest_configuration_vms_devices devices ON devices.device_id =
vm_disk_id IN
NER JOIN v4_2_latest_configuration_vms vms ON vms.vm_id = devices.vm_id INNER JOIN
v4_2_latest_configuration_vms_disks disks ON disks.vm_disk_id = samples.vm_disk_id LEFT
OUTER JOIN (SELECT v
m_name, AVG(previous_actual_size) AS previous_actual_size, AVG(previous_total_size) AS
previous_total_size FROM (SELEC
13783 | 2019-06-15 08:41:52.349769+02 | active | SELECT name, AVG(total) AS total,
AVG(used) AS used, MAX(previous_used) AS previous_used, MAX(previous_total) AS
previous_total, MAX(vm_disk_
usage_percent) AS usage_percent FROM (SELECT history_datetime, vms.vm_name AS name,
SUM(vm_disk_size_mb) AS total, SUM(vm_disk_actual_size_mb) AS used,
COALESCE(MAX(previous_actual_size), 0)
AS previous_used, COALESCE(MAX(previous_total_size), 0) AS previous_total, CASE WHEN
MAX(vm_disk_size_mb) = 0 THEN 0 ELSE (CAST(MAX(vm_disk_actual_size_mb) AS DECIMAL)/
MAX(vm_disk_size_mb) *
100) END AS vm_disk_usage_percent FROM v4_2_statistics_vms_disks_resources_usage_samples
samples INNER JOIN v4_2_latest_configuration_vms_devices devices ON devices.device_id =
vm_disk_id IN
NER JOIN v4_2_latest_configuration_vms vms ON vms.vm_id = devices.vm_id INNER JOIN
v4_2_latest_configuration_vms_disks disks ON disks.vm_disk_id = samples.vm_disk_id LEFT
OUTER JOIN (SELECT v
m_name, AVG(previous_actual_size) AS previous_actual_size, AVG(previous_total_size) AS
previous_total_size FROM (SELEC...
oVirt Engine is configured with 128 GB memory and 24 cores.
Please advice how to adress this.
Thank you and all the best,
Oliver