Retention policies not removing old data!

#1

We have a database with only one and default retention policy 7 days… I can select data older than 7 days … why ?

influx
Connected to http://localhost:8086 version 1.3.1
InfluxDB shell version: 1.3.1

auth
username: dbadmin
password:

show retention policies on indicators
name duration shardGroupDuration replicaN default


autogen 168h0m0s 24h0m0s 1 true

select count(*) from MA1 WHERE time < now() -7d
name: MA1
time count_MA_12H count_MA_12_Hour count_MA_2D count_MA_2_Day count_MA_5D count_MA_5_Day count_MA_6H count_MA_6_Hour count_SD_12H count_SD_12_Hour count_SD_2D count_SD_2_Day count_SD_5D count_SD_5_Day count_SD_6H count_SD_6_Hour


0 3 19169 3 19169 3 19169 3 19169 3 18996 3 19057 3 19128 3 18818

exit

when does the data gets removed if at all !

1 Like
#2

If retention policy relies on the Shard cleanup which seems to be set to 24 hours. The clean-up should happen everyday (24 hours cycle). Instead of using count; can you run select first(fieldname)

So we the first timestamp can be viewed under the database.

1 Like
#3

Thanks… I wish there was a way to close the cases