possibly not the right place to ask, so sorry for that. i am trying to get the second (or n-th) value of the day for a certain measurement and i really can’t figure out how. first/last are quite obvious, using the built-in functions. thank you for any suggestions.
Like @Cococabana above, I wanted to move from the internal 1.x version to an external 2.7 on a Synology NAS (in Docker). Because v1 and v2 handle the data in different ways, there does not appear to be a beginner friendly way of transferring the data, so I just cut my losses and went for the new install and stopped collecting the data internally.
My InfluxDB database takes up more than half my backups, so I wanted to find an alternative storage.
What I would really like is a way to use the add-on, but store the data on my NAS. Is that possible?
(I’m not holding my breath - and sadly this thread is more questions than solutions these days.)
My InfluxDB and Grafana addons keep crashing recently. The logs show the exact same error message:
s6-rc: warning: unable to start service base-addon-timezone: command exited 2
However the base-addon-timezone seems to be working for all other addons in my installation.
Except for updates I’m not aware that I’ve changed anything recently.
Things I tried without success:
- rebooting
- increasing the VM’s RAM to 3 GB
- removing the InfluxDB addon and re-installed it from scratch
- setting logging to debug
Do you have any advice on how to access the in-contailer logging mentioned in the error message. I could not figure out how to access those for a crashing container…
The full logs are:
Add-on: InfluxDB
Scalable datastore for metrics, events, and real-time analytics
-----------------------------------------------------------
Add-on version: 4.7.0
You are running the latest version of this add-on.
System: Home Assistant OS 10.2 (amd64 / qemux86-64)
Home Assistant Core: 2023.6.2
Home Assistant Supervisor: 2023.06.2
-----------------------------------------------------------
Please, share the above information when looking for help
or support in, e.g., GitHub, forums or the Discord chat.
-----------------------------------------------------------
s6-rc: info: service base-addon-banner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service base-addon-timezone: starting
s6-rc: info: service base-addon-log-level: starting
s6-rc: info: service fix-attrs successfully started
[17:19:06] INFO: Configuring timezone (Europe/Berlin)...
s6-rc: info: service base-addon-log-level successfully started
s6-rc: warning: unable to start service base-addon-timezone: command exited 2
/run/s6/basedir/scripts/rc.init: warning: s6-rc failed to properly bring all the services up! Check your logs (in /run/uncaught-logs/current if you have in-container logging) for more information.
/run/s6/basedir/scripts/rc.init: fatal: stopping the container.
s6-rc: info: service fix-attrs: stopping
s6-rc: info: service base-addon-log-level: stopping
s6-rc: info: service fix-attrs successfully stopped
s6-rc: info: service base-addon-log-level successfully stopped
s6-rc: info: service base-addon-banner: stopping
s6-rc: info: service base-addon-banner successfully stopped
s6-rc: info: service s6rc-oneshot-runner: stopping
s6-rc: info: service s6rc-oneshot-runner successfully stopped
s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service base-addon-banner: starting
Hi all,
I have just mounted my Synology NAS to my RPi where HA is running.
How I could change the configuration of InfluxDB to save data on NAS disk?
Many thanks for any support you could provide.
Hi, i cant find a way to export influxdb database. Using commands influxd from ssh terminal does not work (it give command not found error). Someone can help? Thank you
I managed it 2 years ago, but things may have changed. I now have my database on a separate PVE setup!
Hello Frenck,
I have installed and uninstalled InfluxDB several times without success.
Unfortunately, I’m now at the end of my knowledge, I only have rudimentary knowledge of programming.
But you could already incorporate a lot into your “Wonderful World of Home Assistant”.
A really great project in my opinion, thank you for your time, work and effort!
The InfluxDB doesn’t start properly, can you help me or someone from the Home Assistant group? I would be happy to find a solution, thank you!
I’ve made a few attempts with changes in the config yaml, without success.
I’ve been stuck with this problem for a few days now.
Here is the log from the start:
s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service base-addon-banner: starting
Add-on: InfluxDB
Scalable datastore for metrics, events, and real-time analytics
Add-on version: 4.8.0
You are running the latest version of this add-on.
System: Home Assistant OS 11.1 (amd64 / generic-x86-64)
Home Assistant Core: 2023.10.5
Home Assistant Supervisor: 2023.10.1
Please, share the above information when looking for help
or support in, e.g., GitHub, forums or the Discord chat.
s6-rc: info: service base-addon-banner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service base-addon-timezone: starting
s6-rc: info: service base-addon-log-level: starting
s6-rc: info: service fix-attrs successfully started
[19:00:14] INFO: Configuring timezone (Europe/Berlin)…
s6-rc: info: service base-addon-log-level successfully started
s6-rc: info: service base-addon-timezone successfully started
s6-rc: info: service legacy-cont-init: starting
cont-init: info: running /etc/cont-init.d/create-users.sh
[19:00:18] INFO: InfluxDB init process in progress…
[tcp] 2023/11/01 19:00:23 tcp.Mux: Listener at 127.0.0.1:8088 failed failed to accept a connection, closing all listeners - accept tcp 127.0.0.1:8088: use of closed network connection
cont-init: info: /etc/cont-init.d/create-users.sh exited 0
cont-init: info: running /etc/cont-init.d/influxdb.sh
cont-init: info: /etc/cont-init.d/influxdb.sh exited 0
cont-init: info: running /etc/cont-init.d/kapacitor.sh
cont-init: info: /etc/cont-init.d/kapacitor.sh exited 0
cont-init: info: running /etc/cont-init.d/nginx.sh
cont-init: info: /etc/cont-init.d/nginx.sh exited 0
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service legacy-services: starting
services-up: info: copying legacy longrun chronograf (no readiness notification)
services-up: info: copying legacy longrun influxdb (no readiness notification)
services-up: info: copying legacy longrun kapacitor (no readiness notification)
services-up: info: copying legacy longrun nginx (no readiness notification)
[19:00:24] INFO: Chronograf is waiting until InfluxDB is available…
[19:00:24] INFO: Kapacitor is waiting until InfluxDB is available…
s6-rc: info: service legacy-services successfully started
[19:00:24] INFO: Starting the InfluxDB…
[19:00:29] INFO: Starting Chronograf…
[19:00:29] INFO: Starting the Kapacitor
‘##:::’##::::’###::::’########:::::’###:::::’######::’####:’########::’#######::’########::
##::’##::::’## ##::: ##… ##:::’## ##:::’##… ##:. ##::… ##…::’##… ##: ##… ##:
##:’##::::’##:. ##:: ##:::: ##::’##:. ##:: ##:::…::: ##::::: ##:::: ##:::: ##: ##:::: ##:
#####::::’##:::. ##: ########::’##:::. ##: ##:::::::: ##::::: ##:::: ##:::: ##: ########::
##. ##::: #########: ##…::: #########: ##:::::::: ##::::: ##:::: ##:::: ##: ##… ##:::
##:. ##:: ##… ##: ##:::::::: ##… ##: ##::: ##:: ##::::: ##:::: ##:::: ##: ##::. ##::
##::. ##: ##:::: ##: ##:::::::: ##:::: ##:. ######::’####:::: ##::::. #######:: ##:::. ##:
…::::…::…:::::…::…:::::::::…:::::…:::…:::…:::::…::::::…:::…:::::…::
2023/11/01 19:00:29 Using configuration at: /etc/kapacitor/kapacitor.conf
time=“2023-11-01T19:00:32+01:00” level=info msg=“Serving chronograf at http://127.0.0.1:8889” component=server
time=“2023-11-01T19:00:32+01:00” level=info msg=“Reporting usage stats” component=usage freq=24h reporting_addr=“https://usage.influxdata.com” stats=“os,arch,version,cluster_id,uptime”
[19:00:33] INFO: Starting NGINX…
I’m getting the exact same logs, stuck at Starting NGINX…
I had to uninstall the add-on completely since it would prevent HA from starting correctly on reboot (time out errors everywhere in my logs, CPU running very high).
I’m sure it’s just a temporary snag. I’ll be waiting for a fix since this looks like the perfect solution for the custom component I’m working on.
If there is any info I can provide I’ll be happy to help.
UPDATE: Managed to get it started after updating to latest version of supervisor (2023.11.2, from 2023.10.1). However CPU usage remains high and my host (R-pi 3) keeps crashing.
I’m too is stuck at Starting NGINX… Running latest HAOS and core.
Any update? I too have the same problem
Do you see the Open WEB UI button on the first page of the Addon?
Hello since 2 weeks my InfluxDB doesn’t work anymore. InfluxDB crasches al the time.
If uninstalled influxDB. En installed it again. Now everything works fine again. But now i want to restore data back to de InfluxDB. Becourse i have 3 years data.
I have a full backup of the influxDB.Tar.gz file. (800MB data) But i don’t no how i restore the data back to the new influxDB. I can only import a *.CSV file
Please can someone help me to restore my InfluxDB.
Regards,
Dolby
Problem solved with HA update
Franck
I appreciate all you do here, thanks.
I wonder if you could help me with a problem regarding my InfluxDB size?
After 4 years it’s over 15Gb because I never set a retention policy nor did I exclude anything. My backups are 18Gb and take 2 days to upload to Google Drive cloud.
I’ve now set a retention and have added Includes for just the stuff I want and have also set about deleting entirely all the stuff already in the database I don’t want.
But - How can I force the database file to re-size itself. I’ve done lots of searching but come up with nothing apart from others asking (no answers) and something on an Influx site talking about ‘Compacting’ that requires Unix like commands, but I don’t know how this translates to Influx as an Add-On in HA.
Grateful if you could help
Is it possible to access InfluxDB and/or the data somehow?
I have the Terminal add-on but it runs it its own docker container. Usually add-ons export everything to that container but for Influx I did not find anything…
Hi folks, I realized that more peple had the same problem in previous years randomly but I cannot find a solution. My influxDB in the container on my Synology failed, so I decided to run it again as an addon but it refuses to start with this found in the log:
tcp.Mux: Listener at 127.0.0.1:8088 failed failed to accept a connection, closing all listeners - accept tcp 127.0.0.1:8088: use of closed network connection
Reinstalling the addon does not solve it. Are there some remnants of the container that I can delete manually to have a fresh install or do you know how to solve this problem in any other way?
And how can a user change the ID? I am stuck in this bug for months, updates have not solve it
@frenck it looks a lot of people have the same problem and we do not get any answers, neither here, nor on Github, please, have a look. Thank you.
Same problem here. Says
tcp.Mux: Listener at 127.0.0.1:8088 failed failed to accept a connection, closing all listeners - accept tcp 127.0.0.1:8088: use of closed network connection
And seems to loop reboot the container and that makes high cpu usage. Load average is about 12 on a RPI4/4G
Hi !
Same problem, same message.
Some Grafana dashboards are good, others not …
I’ve checked the config of the add-on and … wow, the SSL option was checked …
Uncheck.
Restart and … all fine.
I didn’t know why the SSL option suddenly change to ON …