I am using influxdb 1.8 on a pi zero w - it had been working well but then started crashing at 4AM each day. This coincided with me creating a second database.
Syslog showed errors at this time related to compaction.
I have reduced the shard size and retention policy on the default policy, and it now stays up but I still get errors between 4AM and 7AM and nothing is written to the databases during this time.
The error I get just before things resume is
oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),global_oom,task_memcg=/,task=influxd,pid=456,uid=999
From reading on here my guess is that I need to convert from tsm to tsi and maybe increase my swapfile size.
I am not sure if compaction has been done, or if it will just keep retrying daily and fail.
I would be grateful to know if I am heading in the right direction or if there are any other measures I can take.
To serve queries, InfluxDB maintains a series index - this can either be “in-memory” or file based via “TSI” files, which are then memory mapped as needed to access different parts of the index. The in-memory option generally uses more memory than the file based version. You can configure this via a config setting: Configure InfluxDB OSS | InfluxDB OSS 1.8 Documentation
I recommend using TSI for RPi. Increasing swap limit can help too if you have the disk available. Pis can be challenging (but also fun!) as they are resource constrained.
Thanks for the advice. Last nights “outage” at 4AM was only for 25 minutes but I have followed the instructions and changed to TSI this morning. I deleted the .idx files as per instructions.
I can still see my data in grafana so will see how it behaves tonight and report back.
All was working OK after the conversion to TSI but at the moment the pi is not serving web pages.
First thing this morning it was taking a long time to serve up Grafana and I could see on the CPU graph there had been a few “outages”.
At the moment it is not responding. Getting a response from a ping mostly fails.
