with HA Influxdb and Grafana?
I`m recording temperature and want to temperature graphs , but i cannot reach the RPI via webinterface anymore.
Is there a solution available or must i pull the plug to reboot?
Can i be sure that the data are recorded?
Thanks for your help.
Thanks, super.
How can i check size of swap file ?
Where can i find some explanations about the attached log file?
[Processing: 2022-09-20 07:52:51.408 WARNING (Recorder) [homeassistant.components.recorder.util] The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly 2022-09-20 07:52:52.725 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=50 from 2022-09-19 16:38:13.674141) 2022-09-20 07:53:32.831 ERROR (SyncWorker_2) [homeassistant.components.influxdb] Cannot connect to InfluxDB due to 'HTTPConnectionPool(host='192.168.178.67', port=8086): Max retries exceeded with url: /write?db=home_assistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f90c86140>: Failed to establish a new connection: [Errno 111] Connection refused'))'. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible. Retrying in 60 seconds. 2022-09-20 07:53:34.393 WARNING (MainThread) [homeassistant.setup] Setup of input_button is taking over 10 seconds. 2022-09-20 07:53:34.416 WARNING (MainThread) [homeassistant.setup] Setup of input_select is taking over 10 seconds. 2022-09-20 07:53:34.420 WARNING (MainThread) [homeassistant.setup] Setup of schedule is taking over 10 seconds. 2022-09-20 07:53:34.425 WARNING (MainThread) [homeassistant.setup] Setup of input_text is taking over 10 seconds. 2022-09-20 07:53:34.429 WARNING (MainThread) [homeassistant.setup] Setup of input_boolean is taking over 10 seconds. 2022-09-20 07:54:33.058 ERROR (SyncWorker_1) [homeassistant.components.influxdb] Cannot connect to InfluxDB due to 'HTTPConnectionPool(host='192.168.178.67', port=8086): Max retries exceeded with url: /write?db=home_assistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f7c0eeb00>: Failed to establish a new connection: [Errno 111] Connection refused'))'. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible. Retrying in 60 seconds.
OK, you’re just firing questions at us without enough information.
Firstly, how have you installed HA on your Pi? When you say you “cannot reach the web interface any more” — was it working for a while? How long?
Are you certain the Pi’s IP address hasn’t changed? If you have not set a static address, your router might have handed out a different address which would mean that the system continues to work, but your web browser won’t find it any more. That may also be the reason for some of the errors you show, relating to looking for Influx at 192.168.178.67.
Sorry of my negligence.
HA OS on USB-M.2 SSD 250gb.
The Connection stopped after about one hour. In the meantime i applied the board recommended swap increase which was referenced to my above post and my RPI was still available in my network after 12 hours.
The IP is always the same and is fixed in my router.
In general it is very difficult to find through all the experience of this board if you only used to windows. All i want is a stable sytem.
Good to hear that the swap change seems to have fixed things. HA should be fine on a base RPi3, but once you start adding things like Influx and Grafana, the memory requirements might start to push its limits.
Since you changed the swap size, have the above errors repeated or has it fixed that also?
"2022-09-21 11:58:20.607 WARNING (MainThread) [homeassistant.components.modbus.modbus] modbus SYSTAComfort2 communication closed
2022-09-21 11:58:21.702 ERROR (MainThread) [homeassistant.components.hassio.handler] Client error on /host/reboot request Server disconnected
2022-09-21 11:58:21.705 ERROR (MainThread) [homeassistant.components.hassio] Failed to to call /host/reboot - "
“Free” shows: swap 232868 used 121600
leider wieder hängt er wieder nach 15 Stunden.
“2022-09-21 14:04:37.128 ERROR (SyncWorker_1) [homeassistant.components.influxdb] Cannot connect to InfluxDB due to ‘HTTPConnectionPool(host=‘192.168.178.67’, port=8086): Max retries exceeded with url: /write?db=home_assistant (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0x7fa13351e0>: Failed to establish a new connection: [Errno 111] Connection refused’))’. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible. Retrying in 60 seconds.”
the Config in HA for influxdb 
“influxdb:
host: 192.168.178.67
port: 8086
database: home_assistant
username: xxxxx
password: yyyy
ssl: false
verify_ssl: false
max_retries: 3
default_measurement: state”
i am using as host the ip of the rpi3 .
but in Influxdb under connections " http://localhost:8086 (Default)"
So what is correct?
Why does it not reconnect to influxdb - see above log.?
Booting HA:
12:27:14.447 ERROR (SyncWorker_0) [homeassistant.components.influxdb] Cannot connect to InfluxDB due to ‘HTTPConnectionPool(host=‘192.168.178.67’, port=8086): Max retries exceeded with url: /write?db=home_assistant (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0x7f62ede3e0>: Failed to establish a new connection: [Errno 111] Connection refused’))’. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible. Retrying in 60 seconds.
But i get Data in Grafana