I’ve create a retention policy for 1 hour.
and write data with stress tools on influx.
after 1 hour tsm files that has been created more than 1 hour deleted, but when i run “select count” on specific measurement return value that belong to 2 hours ago!
In summary : tsm file remove but seems meta data not update!
anybody have idea what happen and how should fix this?
Are you writing to, and selecting from, the 1 hour retention policy, or the default infinite retention policy?
Please share the exact commands and queries you ran.
@mark my command to create RP
CREATE RETENTION POLICY "rp1h “stress” DURATION 1h REPLICATION 1
and for selecting as @jackzampolin mention on this post i ran below command:
select last() from cpu where time > now() - 1m
select first() from cpu where time > now() - 1m
and also check count column of table in database:
select count(*) from stress
name: cpu
time count_value
0 100000
FYI:after I’ve created RP, I have two RPs:
SHOW RETENTION POLICIES ON “stress”
autogen 0s 168h0m0s 1 true
a_hour 1h0m0s 1h0m0s 1 false
