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 <oliver.a...@fabasoft.com> 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 <slev...@redhat.com> > *Gesendet:* Sonntag, 16. Juni 2019 09:03 > *An:* Albl, Oliver <oliver.a...@fabasoft.com> > *Cc:* users@ovirt.org > *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 <oliver.a...@fabasoft.com> > 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 -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > 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/users@ovirt.org/message/JJWRQKGCIHRG765YJCEG5CV6BJTFPFAO/ > > _______________________________________________ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > 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/users@ovirt.org/message/BW6GWQ43ACOPMXBZZKLRPF6TUTVOU7WD/ >
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org 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/users@ovirt.org/message/NALAK53EX3CG2TS2VALWTGBBUBV6UM6P/