hello everyone
I have a question about my influxdb database.
First of all, when I set up my system (raspberry 4), I immediately installed version 2.2. For a simple, preset query in Grafana, I mapped the bucket and retention policy to influxql using this guide:
https://docs.influxdata.com/influxdb/v2.0/query-data/influxql/?t=InfluxDB+API
I initially set the retention period to one year in the iobroker settings for the Influx adapter. Then I put the database on a USB drive, according to these instructions (last post):
https://community.influxdata.com/t/influxdb-2-0-moving-database/20452/5
Works well. Now I have noticed that the database has a relatively high storage requirement: 800 mb per week with approx. 30 data points from the smart home (e.g. climate, electricity data). Is that size normal?
Now I have reduced the retention period (“delete after” in bucket settings in the new graphical interface of influx) to one month.
As expected, data older than one month can no longer be queried in grafana, but no storage space was released on the usb drive.
Can anyone tell me about this issue? maybe it has something to do with the mapping?
Apart from that: what happens with these “saw teeth” in normal operation? why is a little storage space suddenly released again and again?
Hi I had quite the same issue .
I could fix the issue by performing a backup then a restore —full.
From a 1Go SSD I had 30% used then only 4 % after the restore
Phil
Was your backup successful? Which version are you using?
Unfortunately, the backup always ends with this error for me:
2022/05/31 05:56:40 INFO: Downloading metadata snapshot
2022/05/31 05:56:40 INFO: Backing up TSM for shard 11
2022/05/31 05:56:40 WARN: Shard 11 removed during backup
2022/05/31 05:56:40 INFO: Backing up TSM for shard 13
2022/05/31 05:56:40 WARN: Shard 13 removed during backup
2022/05/31 05:56:40 INFO: Backing up TSM for shard 15
2022/05/31 05:56:40 WARN: Shard 15 removed during backup
2022/05/31 05:56:40 INFO: Backing up TSM for shard 17
2022/05/31 05:56:40 WARN: Shard 17 removed during backup
2022/05/31 05:56:40 INFO: Backing up TSM for shard 19
2022/05/31 05:56:40 WARN: Shard 19 removed during backup
2022/05/31 05:56:40 INFO: Backing up TSM for shard 21
Error: failed to backup bucket data: failed to download snapshot of shard 21: 500 Internal Server Error: An internal error has occurred - check server logs
Where I can find these logs?
I use InfluxDB 2.
And yes all was successful.
I assume that logs depend upon the type of installation .
Phil
And after that update the data cleanup with retention policy works?
