I have been using InfluxDB for several years with different databases. for one of them I have created a RETENTION POLICY with the name 90d.
As the name suggests, the data should be kept for 90 days. This always works over a certain period of time.
But then I see how the database suddenly grows again.
When I then look at the policy, it suddenly pops up again: 90d 8760h0m0s 168h0m0s 1 true
How can this happen?
Then I use again ALTER RETENTION POLICY “90d” ON “peffs-90d” DURATION 90d SHARD DURATION 1d DEFAULT
And it works again for a long time.
Your “never seen this happen before.” gave me an idea!
The system is still running an IO broker to which the DB is also connected. It seems that the retention policy is set to the value stored in the IO-Broker when the IO-Broker service is started. Even if it is a self-created policy and not the one from the IO-Broker!
