Hi Tommy,
There was a bug in the way we calculate hosts CPU: we didn't consider the count_threads_as_cores option in the calculation.
The count_threads_as_cores column is available only from ovirt-engine 4.4.6.7 version, and ovirt-dwh 4.4.7. Patches: ovirt-engine ovirt-dwh So you have to update the version to 4.4.7.
I will also add a note in the Blog.

You can try to implement the patches I shared manually by changing the relevant files in engine and dwh and run engine-setup.
*Important note: do not change the minimal version part in dwh ovirt-engine-dwh.spec.in file.

Feel free to contact me if you have more questions.

Best,
Aviv  

On Fri, Sep 17, 2021 at 7:08 AM Tommy Sway <sz_cuitao@163.com> wrote:
So, 4.3 cannot resolve it ?

Thanks.



-----Original Message-----
From: users-bounces@ovirt.org <users-bounces@ovirt.org> On Behalf Of Kiran Rajendra
Sent: Thursday, September 16, 2021 4:54 PM
To: users@ovirt.org
Subject: [ovirt-users] Re: oVirt 4.3 DWH with Grafana

Hi Tommy,

In OLVM/oVirt 4.3, Column count_threads_as_cores is not present in table cluster_configuration

ovirt_engine_history=# \d cluster_configuration
                                            Table "public.cluster_configuration"
              Column              |           Type           | Collation | Nullable |                Default
----------------------------------+--------------------------+-----------+----------+----------------------------------------
 history_id                       | integer                  |           | not null | nextval('configuration_seq'::regclass)
 cluster_id                       | uuid                     |           | not null |
 cluster_name                     | character varying(40)    |           | not null |
 cluster_description              | character varying(4000)  |           |          |
 datacenter_id                    | uuid                     |           |          |
 cpu_name                         | character varying(255)   |           |          |
 compatibility_version            | character varying(40)    |           | not null | '2.2'::character varying
 datacenter_configuration_version | integer                  |           |          |
 create_date                      | timestamp with time zone |           |          |
 update_date                      | timestamp with time zone |           |          |
 delete_date                      | timestamp with time zone |           |          |
Indexes:
    "cluster_configuration_pkey" PRIMARY KEY, btree (history_id)
    "cluster_configuration_cluster_id_idx" btree (cluster_id)
    "cluster_configuration_datacenter_id_idx" btree (datacenter_id)


It is added in oVirt 4.4 release.
https://gerrit.ovirt.org/c/ovirt-dwh/+/114568
https://gerrit.ovirt.org/c/ovirt-dwh/+/114568/11/packaging/dbscripts/create_views_4_4.sql

Thank you
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/JOYM3DBPSHJIQUCBFV5STKSPLG47X4CY/
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/FYNIMRZX2FY3ZTLX2JADQAWE4XWL3QJZ/