Hi,
This is my first question in Grafana community, thanks for this great software.
I installed Grafana one year ago, and shows our company temperature/humidity info in a server.
Server: Ubuntu 16.04.5 LTS
MariaDB is my datasource, 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
I always upgrade system and Grafana software every month. Until v5.2.4 it is OK for all graphs. Now I find when I upgrade it to v5.3.1 or v5.3.2 there is problem like the attachment. Grafana only gets the data from datasource 8H before, not now. In the datasource, there is data at 16:00, but Grafana graph stopps at 08:00.
BTW, I installed Zabbix plugin on the server, they are all OK after upgrade, no problem.
Here is my server result of ‘timedatectl status’:
$ timedatectl status
Local time: Sun 2018-10-28 16:36:14 CST
Universal time: Sun 2018-10-28 08:36:14 UTC
RTC time: Sun 2018-10-28 08:36:14
Time zone: Asia/Shanghai (CST, +0800)
Network time on: yes
NTP synchronized: yes
RTC in local TZ: no
This is my SQL query for this attachment,
select UNIX_TIMESTAMP(dateandtime) as time_sec, temperaturex10 as ‘Temperature’ from nti13 where $__timeFilter(dateandtime) order by dateandtime asc
I know most of problem could be timezone, but as I said, graphs were OK before. It is strange.
Please help me, thanks in advance!