Yes, change all files at the same time. Note that file 04_04_0040_added_host_count_threads_as_cores.sql needs to be created. After that run engine-setup --offline (since you don't want to upgrade to 4.4).
On Wed, Nov 3, 2021 at 7:06 AM Tommy Sway <[email protected]> wrote: > 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 <[email protected]> > *Sent:* Wednesday, November 3, 2021 1:01 PM > *To:* 'Aviv Litman' <[email protected]>; [email protected] > *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/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 <[email protected]> > *Sent:* Monday, November 1, 2021 5:50 PM > *To:* Tommy Sway <[email protected]>; [email protected] > *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 <[email protected]> wrote: > > But how to apply the patches? > > > > Is some docs can guide me how to apply? > > > > Thanks. > > > > > > > > > > *From:* Aviv Litman <[email protected]> > *Sent:* Sunday, October 3, 2021 10:08 PM > *To:* Tommy Sway <[email protected]> > *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 <[email protected]> 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 <[email protected]> wrote: > > Thank you! > > > > > > > > > > > > *From:* Aviv Litman <[email protected]> > *Sent:* Sunday, September 19, 2021 3:04 PM > *To:* Tommy Sway <[email protected]> > *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 <[email protected]> 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! > > > > > >
_______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] 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/[email protected]/message/BVHNCQABYSBHCEQISFYBRBB53E6ZNJCF/
