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.