We still have issues with data missing in grafana from time to time on some timespans. Not sure if it is Grafana or the datasource. I was hoping it should dissapear after the latest Grafana update but it is still ther.
DanielH
08/16/2023, 2:46 PM
this is last 6h
DanielH
08/16/2023, 2:47 PM
this a part of the data
DanielH
08/16/2023, 2:48 PM
and we are +2h in the timezone, so the data is there but it looks like grafana can not render it properly from time to time.
j
Jermuk
08/16/2023, 3:23 PM
can you confirm that it actually landed up in timescaledb? could also be that the mqtt broker restarted or similar
d
DanielH
08/16/2023, 5:26 PM
no i mean, the data comming in to grafana is correct as you see in the timestamps.. the data is UTC+0 and the browser is UTC+2 atm, so grafana should render the data with +2h but it sometimes fail.. i have not seen that behaviour from queries direct from sql.
j
Jermuk
08/17/2023, 4:41 PM
if it appears there, then it is probably not a datasource problem, but a visualization. can you check if it appears with different visualization options as well? e.g., a table
d
DanielH
08/17/2023, 5:26 PM
table looks correct if i remember. also gauge works.. i have not however had the same problems when getting data from the database.. if i have time tomorrow i will create a copy of the visualization but use postgres instead and see if i have the same problem.
DanielH
08/21/2023, 7:30 AM
the error seems to be connected to the datasource.. here are 2 timeseries with the same data. the upper is from the datasource and the lower is from postgres