Inquiries regarding missing data in the calendar table created/inserted into the ovirt_engine_history DB.
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/modules/.... 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/upgrade/0...) to commit or request a correction? I would like to know.
On Mon, Jun 28, 2021 at 7:15 AM <whoisjmh@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/modules/.... 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/upgrade/0...) 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 _______________________________________________
Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org 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/users@ovirt.org/message/IDA2OUW4AYTYAA...
-- Martin Perina Manager, Software Engineering Red Hat Czech s.r.o.
participants (2)
-
Martin Perina -
whoisjmh＠gmail.com