It seems like the issue is related to shards.
You simply can’t have data for too long. Not even adding extra memory will help. At one point the DB will just start crashing and corrupt the files not being able to recover it anymore.
Such a big issue, completely unreliable to be used for serious production. We will be migrating away. None of these issues are mentioned anywhere in the documentation but seems like it is a problem since influx1. Also, very hard to find information about it.
Similar issues mentioned
Edit:
DB being 750MB, having cardinality 50, less than 2mil data points. Changing shard durations but retention forever. Influx is using 7 GB memory.
Seems like there is no solution for this, you simply can’t have long term data.
