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]>
Gesendet: Sonntag, 16. Juni 2019 09:03
An: Albl, Oliver <[email protected]>
Cc: [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]
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/BW6GWQ43ACOPMXBZZKLRPF6TUTVOU7WD/

Reply via email to