1. connect to your engine machine
2. vi /usr/share/ovirt-engine/dbscripts/create_dwh_views.sql :

add the new line as described in the patch: https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/4/packaging/dbscripts/create_dwh_views.sql.

 

--- This step just add one line to the /usr/share/ovirt-engine/dbscripts/create_dwh_views.sql 87 line :

--- count_threads_as_cores AS count_threads_as_cores,

--- it’s OK.

 


3. connect to your dwh machine (if the engine and dwh are on the same machine then all files are in the same machine)

4. create or edit the files in the patch: https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/, note that for you files named 4_4 should be named 4_3
You can find the file's location with this command:
find / -name 
create_views_4_3.sql

 

---- Should this step need to edit these files:

 

 

--- And there are many same name files as:

 

# find / -name create_views_4_3.sql

/root/ovirt-dwh-backup/packaging/dbscripts/create_views_4_3.sql

/root/ovirt-dwh/packaging/dbscripts/create_views_4_3.sql

/usr/share/ovirt-engine-dwh/dbscripts/create_views_4_3.sql

 

Do I need to change these files at the same time ??

 

 

 


5. run engine-setup, or engine-setup --offline 

 

 

 

 

From: Aviv Litman <alitman@redhat.com>
Sent: Monday, November 1, 2021 5:50 PM
To: Tommy Sway <sz_cuitao@163.com>; users@ovirt.org
Subject: Re: Some errors on the grafana dashboard

 

Hi Tommy,
You can apply 
 the patches by changing the relevant files in engine and dwh and run 'engine-setup' or 'engine-setup --offline' .

Steps:
1. connect to your engine machine
2. vi /usr/share/ovirt-engine/dbscripts/create_dwh_views.sql :

add the new line as described in the patch: https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/4/packaging/dbscripts/create_dwh_views.sql.
3. connect to your dwh machine (if the engine and dwh are on the same machine then all files are in the same machine)

4. create or edit the files in the patch: https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/, note that for you files named 4_4 should be named 4_3
You can find the file's location with this command:
find / -name 
create_views_4_3.sql
5. run engine-setup, or engine-setup --offline 
 
Let me know how it goes!

Thanks,
Aviv

 

 

On Mon, Nov 1, 2021 at 9:42 AM Tommy Sway <sz_cuitao@163.com> wrote:

But how to apply the patches?

 

Is some docs can guide me how to apply?

 

Thanks.

 

 

 

 

From: Aviv Litman <alitman@redhat.com>
Sent: Sunday, October 3, 2021 10:08 PM
To: Tommy Sway <sz_cuitao@163.com>
Subject: Re: Some errors on the grafana dashboard

 

Important note: do not to change the minimal version part in dwh ovirt-engine-dwh.spec.in file.

 

On Sun, Oct 3, 2021 at 4:50 PM Aviv Litman <alitman@redhat.com> wrote:

Hi Tommy,
You can try to implement the patches I shared manually by changing the relevant files in engine and dwh and run engine-setup.

Let me know if you have any questions.

Thanks,
Aviv

 

On Sun, Sep 19, 2021 at 4:56 PM Tommy Sway <sz_cuitao@163.com> wrote:

Thank you!

 

 

 

 

 

From: Aviv Litman <alitman@redhat.com>
Sent: Sunday, September 19, 2021 3:04 PM
To: Tommy Sway <sz_cuitao@163.com>
Subject: Re: Some errors on the grafana dashboard

 

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.

Feel free to contact me if you have more questions.

Best,
Aviv  

 

On Tue, Sep 14, 2021 at 11:38 AM Tommy Sway <sz_cuitao@163.com> wrote:

Hello!

 

I used the JSON file you provided and imported grafana. Before importing, I replaced the version, because the version of my system is 4.3.

$ find . -type f -name "*dashboard.json" -exec sed -i -e 's/v4_4_/v4_3_/g' {} \;

However, most of the reports are normal, but some reports have similar errors:

 

pq: column "count_threads_as_cores" does not exist

Object

status:400

statusText:"Bad Request"

data:Object

results:Object

message:"pq: column "count_threads_as_cores" does not exist"

message:"pq: column "count_threads_as_cores" does not exist"

 

Many of the other reports worked fine, with only a few similar errors.

Is this caused by version incompatibility?

After all, 4.4 in the original document was replaced with 4.3 before the import.

 

Thank you!