InfluxDB shutdown shortly after start about addon-influxdb HOT 10 CLOSED

This looks like it may possibly be resolved in the upcoming 1.7.9 Influx release, either way it is likely an Influx specific issue rather than the add-on itself. Will leave it open to be closed when that release is available.

from addon-influxdb.

👋 Thanks for opening your first issue here! If you're reporting a 🐛 bug, please make sure you include steps to reproduce it. Also, logs, error messages and information about your hardware might be usefull.

from addon-influxdb.

I had the same error as roblandry.
I restored the influxdb add-on from a snapshot back to version 3.2.1 and it was working again. As suggested by sinclairpaul I will wait until version 1.7.9 of Influx will be available before my next try. :-)

from addon-influxdb.

I've also had this problem for 6 weeks or so. I hope the compaction bug fixes in 1.7.9 eliminate the issue.

from addon-influxdb.

1.7.9 is in the latest release, closing for now.

from addon-influxdb.

Sadly, this problem still persists after upgrading to 1.7.9.

from addon-influxdb.

Sadly, this problem still persists after upgrading to 1.7.9.

Confirm.

Just now upgraded to add-on v3.4.1 containing InfluxDB 1.7.9 and I also get the above shown crash/shutdown directly after/during startup, as I did before the add-on upgrade.

(on RPi3B+, Hassio, HA 0.100.3)

from addon-influxdb.

You will need to log the issue at https://github.com/influxdata/influxdb

GitHub

influxdata/influxdb

Scalable datastore for metrics, events, and real-time analytics - influxdata/influxdb

from addon-influxdb.

This previous report of an issue was closed with no action: https://github.com/influxdata/influxdb/issues/12902.

There are various reports of memory issues like this one: https://community.influxdata.com/t/influxdb-1-7-4-fails-after-9-months-without-issues/9157 and https://stackoverflow.com/questions/56925881/influxdb-1-7-x-high-cpu-usage-on-rasperry-pi-3

It's not clear to me whether "our" specific issue is due to compaction on startup or not, but this is a ongoing issue that results in out of memory errors: https://github.com/influxdata/influxdb/issues/11339

The most sobering read, however, is this issue which relates to a solution for 32-bit systems which has not been picked up by influxdb: https://github.com/influxdata/influxdb/pull/12362:

For anyone still following this particular issue, specifically when running on a IoT device such as a Raspberry Pi with raspbian (a 32 bit OS) - if you get this dreaded error, the only solution is to simply load up the database on another 64-bit device just to run the compaction periodically, then transfer it back. It somewhat defeats the benefits of a small IoT device, but seems very much that InfluxDB are just not interested in the next wave IoT capabilities that are beginning to emerge, at this time. In short... don't waste too much time trying to get InfluxDB running on a 32-bit platform with even a moderate size DB, as it will inevitably fail with this issue.

My database is currently 1.7GB and presumably not compacted so I think I may have some way to go before the issue is terminal based on that what I've read but the only possible interim solution I could find was to switch from tsm to tsi to reduce memory burden. I'm not whether it will work or not, but I can't see any way of following the procedure since influxdb is inside the addon's container https://docs.influxdata.com/influxdb/v1.7/concepts/tsi-details/. Specifically the use of buildtsi:

If you want to convert an existing shard from an in-memory index to a TSI index, or if you have an existing TSI index which has become corrupt, you can use the buildtsi command to create the index from the underlying TSM data. If you have an existing TSI index that you want to rebuild, first delete the index directory within your shard.

Any thoughts, other than time to find another time-series database?

from addon-influxdb.

This thread has been automatically locked because it has not had recent activity. Please open a new issue for related bugs and link to relevant comments in this thread.

from addon-influxdb.