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/ICXEAXD5NYPQPCAUH42NGJNV62Z4JTWE/
