On Mon, Jun 28, 2021 at 7:15 AM <whoisjmh(a)gmail.com> wrote:
I recently discovered that the spark-line chart is not displayed in
the
dashboard of the ovirt admin page. As a result of looking up the code and
query, the data of the calendar table in the ovirt_engine_history DB of
ovirt-dwh was only available until 2021-01-01 00:00:00, so a query
statement (
https://github.com/oVirt/ovirt-engine/blob/master/frontend/webadmin/modul....
RIGHT OUTER JOIN of properties) was not getting the correct data. First,
the existing "generate_series('2011-01-01 00:00'::timestamp,
'2021-01-01
00:00', '1 hours')" part was temporarily modified and applied until
2051. ,
it was confirmed that the spark-line chart was displayed normally.
For this, is there a way I can directly edit the file (
https://github.com/oVirt/ovirt-dwh/blob/master/packaging/dbscripts/upgrad...)
to commit or request a correction? I would like to know.
Hi,
You should not modify existing upgrade scripts, because:
1. They are overwritten on RPM package upgrade
2. They are not applied to the database, because we track which upgrade
scripts were already applied and perform only those new scripts which were
not yet applied during engine-setup
Could you please file a oVirt bug in
https://bugzilla.redhat.com/ ?
Thanks,
Martin
_______________________________________________
--
Martin Perina
Manager, Software Engineering
Red Hat Czech s.r.o.