On our evaluation of InfluxDB we are also testing the data integrity after a power loss (i.e. PC shutdown). For this we use an InfluxDB with default configuration and write data with a rate of 7000 points/sec on a virtual machine. After 5 minutes wo stop the VM hard (like a PC crash), restart it and check how much data is lost. Then we restart the test.
After four such iterations the DB was not usable any more, when trying to write data the message “Error while writing values to influx:[shard 1] error opening memory map for file C:\Users\etmtst.influxdb\data\testdb\autogen\1\000000162-000000001.tsm: indirectIndex: not enough data for min time” was shown and it looked like the DB was empty:
Connected to http://localhost:8086 version 1.5.1
InfluxDB shell version: 1.5.1
Using database testdb
select * from _EVENT
Are there any options to avoid loosing data after system failures (besides a backup)?