Hi,
rebooted oVirt engine VM (no hosted engine), same result. DHW packages are: ovirt-engine-dwh.noarch 4.3.0-1.el7 @ovirt-4.3 ovirt-engine-dwh-setup.noarch 4.3.0-1.el7 @ovirt-4.3 After reboot the following two queries start running again (they were running for more than 24 hours before this reboot): 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 us age_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 INNER JOIN v4_2_latest_configuration_vms vms ON vms.vm_id = devices.vm_id INNER JO IN v4_2_latest_configuration_vms_disks disks ON disks.vm_disk_id = samples.vm_disk_id LEFT OUTER JOIN (SELECT vm_name, AVG(previous_actual_size) AS previous_actual_size, AVG(previous_total_size) AS previous_tota l_size FROM (SELEC All the best, Oliver Von: Shirly Radco <[email protected]> Gesendet: Sonntag, 16. Juni 2019 10:34 An: Albl, Oliver <[email protected]> Cc: [email protected]; [email protected] Betreff: Re: [ovirt-users] Re: Cannot access dashboard after upgrading to 4.3.4 Hi, Please try to restart postgres an ovirt-engine-dwhd. It looks that this is a 4.2 query. What version are the dwh packages? Best, -- Shirly Radco BI Senior Software Engineer Red Hat<https://www.redhat.com/> <https://www.redhat.com/> On Sun, Jun 16, 2019 at 11:10 AM Albl, Oliver <[email protected]<mailto:[email protected]>> wrote: Hi, I am not using hosted engine but a dedicated installation. The upgrade was performed with following steps: yum install http://resources.ovirt.org/pub/yum-repo/ovirt-release43.rpm yum update "ovirt-*-setup*" engine-setup yum update All the best, Oliver Von: Shani Leviim <[email protected]<mailto:[email protected]>> Gesendet: Sonntag, 16. Juni 2019 09:03 An: Albl, Oliver <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]> Betreff: Re: [ovirt-users] Cannot access dashboard after upgrading to 4.3.4 Hi, Did you run 'engine-setup' and 'yum update' after upgrading ovirt? Taken from here as a reference: https://ovirt.org/documentation/self-hosted/chap-upgrading_the_self-hosted_engine.html Regards, Shani Leviim On Sat, Jun 15, 2019 at 10:26 AM Albl, Oliver <[email protected]<mailto:[email protected]>> wrote: 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 _______________________________________________ Users mailing list -- [email protected]<mailto:[email protected]> To unsubscribe send an email to [email protected]<mailto:[email protected]> Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/[email protected]/message/JJWRQKGCIHRG765YJCEG5CV6BJTFPFAO/ _______________________________________________ Users mailing list -- [email protected]<mailto:[email protected]> To unsubscribe send an email to [email protected]<mailto:[email protected]> Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/[email protected]/message/BW6GWQ43ACOPMXBZZKLRPF6TUTVOU7WD/
_______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/[email protected]/message/WPG2NVFKUUE42GWV6KPWWJB3VTZSOUO4/
