hassio-addons/addon-influxdb

InfluxDB not starting after snapshot restore due to missing database #84

bbogdanmircea posted onGitHub

Problem/Motivation

After restoring HA from a snapshot, InfluxDB is not starting anymore

Expected behavior

InfluxDB should start and the db should be restored from the snapshot data?

Actual behavior

InfluxDB can't be started

Steps to reproduce

Make snapshot with InfluxDB installed and some database Load snapshot Try to start InfluxDB

Proposed changes

I saved from the crashed SSD the folder addons where the influxdbs are saved, maybe it is possible to copy back the databases with the last data before the crash?

(If you have a proposed change, workaround or fix, describe the rationale behind it)

Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/zeroconf/init.py", line 2792, in send bytes_sent = s.sendto(packet, 0, (real_addr, port)) OSError: [Errno 101] Network unreachable 2020-06-22 17:28:43 WARNING (SyncWorker_6) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9d22410>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:29:59 WARNING (SyncWorker_19) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9f75bf0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:31:15 WARNING (SyncWorker_14) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cc3bd0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:32:31 WARNING (SyncWorker_6) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9e3a350>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:33:47 WARNING (SyncWorker_15) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa95922f0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:35:03 WARNING (SyncWorker_3) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9592e30>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:36:19 WARNING (SyncWorker_19) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cd39d0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:37:35 WARNING (SyncWorker_14) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cadc70>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:38:51 WARNING (SyncWorker_17) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9d22830>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:40:07 WARNING (SyncWorker_16) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cad6f0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:41:23 WARNING (SyncWorker_6) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cc3cd0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:42:39 WARNING (SyncWorker_16) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9596770>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:43:55 WARNING (SyncWorker_19) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cad690>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:45:11 WARNING (SyncWorker_3) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cd3ef0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:46:27 WARNING (SyncWorker_13) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9caded0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:47:43 WARNING (SyncWorker_9) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xacc58950>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:48:59 WARNING (SyncWorker_7) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cd3930>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:50:15 WARNING (SyncWorker_17) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9e46550>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:51:31 WARNING (SyncWorker_4) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cadcd0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:52:47 WARNING (SyncWorker_9) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9d0fab0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:54:03 WARNING (SyncWorker_14) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cad2d0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:55:19 WARNING (SyncWorker_10) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9d22850>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:56:35 WARNING (SyncWorker_5) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9f69cf0>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds. 2020-06-22 17:57:51 WARNING (SyncWorker_12) [homeassistant.components.influxdb] Database host is not accessible due to 'HTTPConnectionPool(host='a0d7b954-influxdb', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0xa9cfa730>: Failed to establish a new connection: [Errno -3] Try again'))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds.


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

posted by addons-assistant[bot] almost 5 years ago

Did you find a solution yet? As my influxdb plugin in HASSIO will not start. Service is running.

posted by ionultd almost 5 years ago

I just copied the database folders manually for InfluxDB and it seems to be working.

posted by bbogdanmircea almost 5 years ago

Could you please explain? :-)

posted by ionultd almost 5 years ago

Did you restore a snapshot containing influxdb? Do you have access to the SD or SDD containing the influxdb databases? What I did was to copy the folders containing the influxdb from my failed SSD to my new installation and then influxdb started working. My installation was on an RPi4 so my folder is hassio\addons\data\a0d7b954_influxdb\

posted by bbogdanmircea almost 5 years ago

Fund this Issue

$0.00
Funded
Only logged in users can fund an issue

Pull requests