I am just trying out Grafana right now and on every line graph I make the first two hours are missing:
The Data gets loaded, the generated SQL works and in the Query Inspector I can see the missing Data:
While writting this the behavior changed a little (or whats more likely, I just overlooked something…).
It generates the right SQL Query with the right timestamps, but I do not get the right Data back:
The first data row has the unix time 1594404025000 which converts to 10.7.2020, 20:00:25. Thats the first Datapoint shown in the graph.
When I execute the SQL query in heidisql I get the data which it should select:
[As I am a new user I can’t upload more than two images in one post. See first reply)
HeidiSQL and Grafana are running on the same PC (Win10), the mysql db is running on an external server(WinServer2019 I think). Both machines have the same time.
I ve already read through these two posts:
Does not seem to be the same issue:
Maybe something in that direction, but the time is the same on the server and my PC (both are synced over the internet)
Maybe I am just overseeing something obvious…
Does someone know how to fix that?