Grafana influxdb aggregation display a graph which doesn't match the db contents

Dear All

I’m using grafana 5.4.2 with infludb 1.7.2-1 on Ubuntu Xenial

I’ve an issue with graphs which are displaying strange datas. After checking it seems grafana doesn’t graph the datas present in the influxdb database. Please find below my debug

here are the datas which are present in the database for the same counter (cpc-auth-fail)

1585822801000000000 17256998 ach1spgw01
1585822801000000000 119741 ach1spgw01

at the same time the value displayed in grafana shows 8.688 Millions for the same host. I’ve performed by hand the same query than the one performed by grafana in the DB and the results are differents

curiously those values doesn’t match … does someone have an idea of the origin of the differences ?

thanks in advance for your help and support

francois

Hi,

First your linux system have correct time ?

Can you display the query for the result below ? Before in your InfluxDB database use this command “precision rfc3339”.
1585822801000000000 17256998 ach1spgw01
1585822801000000000 119741 ach1spgw01

hi
fisrt of all thanks a lot for your help

the system time is correct … we use an ntp server

the query is

select cpc-auth-fail from gtpc

kind regards

francois