Possible bug, grafana showing data in ~4h delay from database

Grafana
1

Hi!

I monitor test data from infludb and grafana shows the data a bit delay:

image
image1164×1003 68.5 KB

data in influx is in unix timestamp and i managed to avoid this with taking 4 hours off from the timestamp.

image
image1168×974 59.1 KB

influx query:
time build build_id status
2017-07-20T12:12:29Z a 10854 fail
2017-07-20T19:51:03Z a 10870 fail
2017-07-23T21:44:28Z a 10935 pass

I live in finland and my timezone is EEST. Could it have something to do with time zones? I tried to change timezone from settings but it did not help.

2

Whe you write to influxdb do you set time or let influx set time? Influx usually uses UTC time, unless you specify time.

Must be something strange going in your case, no reported timezone issues with InfluxDB and Grafana, so not sure what it can be. What timezone is your browser computer using, what timezone is influxdb at?

3

Checked my browsers time and it gave me this:
The current time is Fri Jul 28 2017 09:23:21 GMT+0300 (FLE Standard Time)
The GMT current time is Fri, 28 Jul 2017 06:23:21 GMT
You are currently at GMT+/–3:00

I pull data from SQL and push it to influx and i transfer the time tag in the process also.

4

And the time you push to influxdb is that in UTC?

5

Actually figured it out. I did change the timezone from preferences and it did not have any influence. Just found out that you can do it from dashboard settings too. My bad.