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
<https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/> ovirt-dwh
<https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/> 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_cui...@163.com> wrote:

> So, 4.3 cannot resolve it ?
>
> Thanks.
>
>
>
> -----Original Message-----
> From: users-boun...@ovirt.org <users-boun...@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-le...@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-le...@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/
>
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/TMSEKS2QDELZN5HTZGKO33HMOQZXRF4T/

Reply via email to