[ovirt-users] Re: Some errors on the grafana dashboard

Sorry , I have got the cause of the files : /root/ovirt-dwh-backup/packaging/dbscripts/create_views_4_3.sql /root/ovirt-dwh/packaging/dbscripts/create_views_4_3.sql So, please just focus only on other issues in my last mail. Thanks. *From:* Tommy Sway <sz_cuitao(a)163.com&gt; *Sent:* Wednesday, November 3, 2021 1:01 PM *To:* 'Aviv Litman' <alitman(a)redhat.com>; users(a)ovirt.org *Subject:* RE: Some errors on the grafana dashboard 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/... . --- 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(a)redhat.com&gt; *Sent:* Monday, November 1, 2021 5:50 PM *To:* Tommy Sway <sz_cuitao(a)163.com>; users(a)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/... . 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(a)163.com&gt; wrote: But how to apply the patches? Is some docs can guide me how to apply? Thanks. *From:* Aviv Litman <alitman(a)redhat.com&gt; *Sent:* Sunday, October 3, 2021 10:08 PM *To:* Tommy Sway <sz_cuitao(a)163.com&gt; *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(a)redhat.com&gt; 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(a)163.com&gt; wrote: Thank you! *From:* Aviv Litman <alitman(a)redhat.com&gt; *Sent:* Sunday, September 19, 2021 3:04 PM *To:* Tommy Sway <sz_cuitao(a)163.com&gt; *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 <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. 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(a)163.com&gt; 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!