Data Outside of Range Issue

Grafana MySQL
, ,
1

I am currently getting two graphs on one dashboard that shows data outside of range. They are both MySQL queries that were working fine for a week and now that has changed. I have another dashboard with the same queries that are not showing this error. Can this be addressed? We are considering Enterprise but need to show the platform works reliably

3 
SELECT
  Date AS "time",
  secBehind "mysql02"
FROM Repstat
WHERE
  Server = 'mysql02'
ORDER BY Date
4

It also is only affecting one of the queries. When I show both lines on the graph, there is missing data. If I highlight the second server, I get the correct results:

image
image914Ă—326 15.7 KB

image
image926Ă—325 20.2 KB

5

Both queries are the same for this graph:

SELECT
  Date AS "time",
  secBehind "mysql02"
FROM Repstat
WHERE
  Server = 'mysql02'
ORDER BY Date

SELECT
  Date AS "time",
  secBehind "mysql-archive"
FROM Repstat
WHERE
  Server = 'mysql-archive'
ORDER BY Date
6

Hello,

Could you please define what data out of range is?

7

I can’t, hence the issue

8

:eyes: I mean what do you mean by “data out of range” is it an error you are seeing on the screen? Please post screen shot?

9

Two screenshots were posted

1 Like
10

Oops sorry I am blind.Is your datefield UTC?

11

Yes it is UTC time by default

12

what does your time filter look like and what version of grafana are you on?

image