So i have set up a new retention policy and a continuous query to downsample my data and store it for a year. i have used the guide located here Downsampling performance data in InfluxDB | www.neteye-blog.com
everything seems to work correctly, except my yearly retention policy stores data for the same period as the autogen rp.
so far everything seems correct:
> show retention policies
name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
autogen 2160h0m0s 2h0m0s 1 true
rp_365d 8760h0m0s 168h0m0s 1 false
forever 0s 168h0m0s 1 false
but this is where the issue start:
shard 67 should have the start time of early july, when the rp_365d retention policy has been set up. but instead it’đ the same as shard 60 - the oldest autogen shard.
> show shards
name: hpserver
id database retention_policy shard_group start_time end_time expiry_time owners
-- -------- ---------------- ----------- ---------- -------- ----------- ------
60 hpserver autogen 60 2020-07-27T00:00:00Z 2020-08-03T00:00:00Z 2020-11-01T00:00:00Z
71 hpserver autogen 71 2020-08-03T00:00:00Z 2020-08-03T02:00:00Z 2020-11-01T02:00:00Z
... (truncated shards)
440 hpserver autogen 440 2020-09-02T20:00:00Z 2020-09-02T22:00:00Z 2020-12-01T22:00:00Z
67 hpserver rp_365d 67 2020-07-27T00:00:00Z 2020-08-03T00:00:00Z 2021-08-03T00:00:00Z
72 hpserver rp_365d 72 2020-08-03T00:00:00Z 2020-08-10T00:00:00Z 2021-08-10T00:00:00Z
165 hpserver rp_365d 165 2020-08-10T00:00:00Z 2020-08-17T00:00:00Z 2021-08-17T00:00:00Z
248 hpserver rp_365d 248 2020-08-17T00:00:00Z 2020-08-24T00:00:00Z 2021-08-24T00:00:00Z
310 hpserver rp_365d 310 2020-08-24T00:00:00Z 2020-08-31T00:00:00Z 2021-08-31T00:00:00Z
403 hpserver rp_365d 403 2020-08-31T00:00:00Z 2020-09-07T00:00:00Z 2021-09-07T00:00:00Z
68 hpserver forever 68 2262-04-10T23:34:33Z 1677-09-27T00:00:00Z 1677-09-27T00:00:00Z
what did i do wrong so that my data or not kept for longer?
thanks
