Description of problem: The time based queries displaying data based on hourly and daily tables, from that reason we can see updated data up to 02:00-02:59 hours back. We want to add those missing hours from the sample table. In addition we want to specify the relevant column names in SELECT statement, to improve query runtime Version-Release number of selected component (if applicable): 4.4.1 Actual results: The issued queries use the hourly and daily tables. The issued queries use '*' in the SELECT statement. Expected results: The issued queries use the hourly, daily, and samples tables. The issued queries use relevant column names in the SELECT statement.
*** Bug 1889056 has been marked as a duplicate of this bug. ***
Please review the doc text: ==== Previously, time-based Grafana reports did not include two hours of sample data from hours 02:00-02:59. With this update, you can now view sample data from those two hours. ===
(In reply to Steve Goodman from comment #9) > Please review the doc text: > > ==== > Previously, time-based Grafana reports did not include two hours of sample > data from hours 02:00-02:59. > > With this update, you can now view sample data from those two hours. > === Hi the description is inaccurate: Previously, time-based Grafana reports did not include two to three hours of sample data. With this update, you can now view sample data from those hours.
The doc_text is now updated: Previously, time-based Grafana reports did not include the most recent two to three hours of sample data. With this update, you can now view sample data from that time period. For example, if you ran the report at 11:54, the report had data only until 9:00. Now the report has data until 11:54.
Steps: 1) Go to Grafana, any timebased data sampling dashboard (e.g. Hosts Trend Dashboard) 2) Try various time ranges 3) Check that data is shown up until the current time and not 2-3 hours back Results: If minutes or hours time range is selected, the data is shown as expected. If Today (or Today so far) is selected, data is shown as expected. If a time range containing days, weeks, months or years (e.g. Last 2 days, Last 30 days, etc.) was selected, the data is missing for the last 2 hours. If This week, This month or This year (and their so far options) are selected, the data is missing for the last 2 hours. The data is shown for hourly or daily (withing the 24hour range) time ranges, therefore I'm moving this to VERIFIED as it matches the description of the RFE. Verified in: ovirt-engine-dwh-4.4.3.2-1.el8ev.noarch ovirt-engine-4.4.3.10-0.1.el8ev.noarch
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (RHV Manager (ovirt-engine) 4.4.z [ovirt-4.4.3] 0-day), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2020:5215