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/