4:04 a.m.
Hi,
Please attach here the result of the following query from the
ovirt_engine_history db:
SELECT id, version, script, checksum, installed_by, started_at, ended_at,
state, current, comment
FROM schema_version
ORDER BY version DESC limit 10 ;
Best regards,
--
Shirly Radco
BI Senior Software Engineer
Red Hat <https://www.redhat.com/>
<https://www.redhat.com/>
---------- Forwarded message ---------
From: Albl, Oliver <Oliver.Albl(a)fabasoft.com>
Date: Sun, Jun 16, 2019 at 11:42 AM
Subject: AW: [ovirt-users] Re: Cannot access dashboard after upgrading to
4.3.4
To: sradco(a)redhat.com <sradco(a)redhat.com>
Cc: sleviim(a)redhat.com <sleviim(a)redhat.com>, users(a)ovirt.org <
users(a)ovirt.org>
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 <sradco(a)redhat.com>
*Gesendet:* Sonntag, 16. Juni 2019 10:34
*An:* Albl, Oliver <Oliver.Albl(a)fabasoft.com>
*Cc:* sleviim(a)redhat.com; users(a)ovirt.org
*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/>
[image: Das Bild wurde vom Absender entfernt.] <https://www.redhat.com/>
On Sun, Jun 16, 2019 at 11:10 AM Albl, Oliver <Oliver.Albl(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 <sleviim(a)redhat.com>
*Gesendet:* Sonntag, 16. Juni 2019 09:03
*An:* Albl, Oliver <Oliver.Albl(a)fabasoft.com>
*Cc:* users(a)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-hoste...
*Regards,*
*Shani Leviim*
On Sat, Jun 15, 2019 at 10:26 AM Albl, Oliver <Oliver.Albl(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(a)ovirt.org
To unsubscribe send an email to users-leave(a)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/JJWRQKGCIHR...
_______________________________________________
Users mailing list -- users(a)ovirt.org
To unsubscribe send an email to users-leave(a)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/BW6GWQ43ACO...
