It seems that this (and similar issues) are not uncommon when running on 32 bit system, such as on a pi. See, for example, Compaction crash loops and data loss on Raspberry Pi 3 B+ under minimal load · Issue #11339 · influxdata/influxdb · GitHub
It may well fail again when the db gets back to a significant size.
Unfortunately there doesn't seem to be a fix and likely never will be as there is no further development on 1.8 and apparently 2.0 doesn't (and won't) support 32 bit systems.
There is now, I think, a 64 bit OS version available for the pi 4, though I haven't tried it, or I suppose one could install Ubuntu or Debian.
I now use an old laptop as my main server (running Ubuntu server). Pretty much any old 64 bit laptop will handle the sort of loads you are talking about.
However, whatever you do, you should re-arrange the db schema, as the way you have it at the moment is a long way from ideal. Maybe best to carry on that discussion on your other thread?
