After upgrading both Grafana (v.4.6.3) and Zabbix Plugin (v.3.8.1) I’ve get gaps on some graphs in one dashboard:
The same metric displays in another dashboards without any problem. I cannot figure out why It’s happen and before recreating dashboard with problems I want to know how can I fix dashboard without it.
During further problem investigation I found than gaps depend on time range selected - when I select “last 1 hour” or “last 6 hours” I see normal graph, when “last 3 hours” - graph with gaps.
sql SELECT itemid AS metric, clock DIV 15 * 15 AS time_sec, AVG(value) AS value FROM history WHERE itemid IN (96539) AND clock > 1519016970 AND clock < 1519027770 GROUP BY clock DIV 15 * 15, metric ORDER BY time_sec ASC