Influx does not show data older than 2d

Store
1

Hello,

I noticed my problem in grafana when I extended the time range to 7d in the past, with 2d it is working. I triggered down the problem to this example:
Connected to http://localhost:8086 version 1.8.3
InfluxDB shell version: 1.8.3
> use knx
Using database knx
> select * from heatcontrol where short_name = ‘Heizen-Schlafen-Blockieren’
> select * from heatcontrol where short_name = ‘Heizen-Schlafen-Blockieren’ and time > now()-2d
name: heatcontrol
time group_addr short_name value

1605640129788826310 10/0/104 Heizen-Schlafen-Blockieren true
1605685589144280527 10/0/104 Heizen-Schlafen-Blockieren false
1605811256944688804 10/0/104 Heizen-Schlafen-Blockieren true
1605811257800080295 10/0/104 Heizen-Schlafen-Blockieren false
> select * from heatcontrol where short_name = ‘Heizen-Schlafen-Blockieren’ and time > now()-4d
> select * from heatcontrol where short_name = ‘Heizen-Schlafen-Blockieren’ and time > now()-3d
name: heatcontrol
time group_addr short_name value

1605640129788826310 10/0/104 Heizen-Schlafen-Blockieren true
1605685589144280527 10/0/104 Heizen-Schlafen-Blockieren false
1605811256944688804 10/0/104 Heizen-Schlafen-Blockieren true
1605811257800080295 10/0/104 Heizen-Schlafen-Blockieren false

Can someone push me in the right direction? I already did a influx_inspect verify.

Thanks,
Ralf

2

Hello @rasi,
Welcome! So just to clarify when you query with -7d you expect to also see:

1605640129788826310 10/0/104 Heizen-Schlafen-Blockieren true
1605685589144280527 10/0/104 Heizen-Schlafen-Blockieren false
1605811256944688804 10/0/104 Heizen-Schlafen-Blockieren true
1605811257800080295 10/0/104 Heizen-Schlafen-Blockieren false

That’s strange indeed. Which you’re not getting right now? What version of InfluxDB are you using? Can you share the query with -7d and the output? Thank you.