Another unexplained crash

Today my Raspberry PI4 crashed so I unplugged and plugged back in

based on when this sensor stopped recording and flatlined, it seems like it crashed at 12:27
image

I was hoping I could find the cause of the crash in the logs

Home Assistant Core

Version

core-2021.8.2

Newest Version

core-2021.11.2

Operating System

Version

6.2

Newest Version

6.6

  File "/usr/local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/usr/local/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`homeassistant`.`states`, CONSTRAINT `states_ibfk_2` FOREIGN KEY (`old_state_id`) REFERENCES `states` (`state_id`) ON DELETE NO ACTION)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 632, in _process_one_event_or_recover
    self._process_one_event(event)
  File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 752, in _process_one_event
    self._commit_event_session_or_retry()
  File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 815, in _commit_event_session_or_retry
    self._commit_event_session()
  File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 834, in _commit_event_session
    self.event_session.flush()
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3286, in flush
    self._flush(objects)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3426, in _flush
    transaction.rollback(_capture_exception=True)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3386, in _flush
    flush_context.execute()
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 453, in execute
    n.execute_aggregate(self, set_)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 747, in execute_aggregate
    persistence.save_obj(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj
    _emit_insert_statements(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1219, in _emit_insert_statements
    result = connection._execute_20(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1582, in _execute_20
    return meth(self, args_10style, kwargs_10style, execution_options)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 324, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1451, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1813, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1994, in _handle_dbapi_exception
    util.raise_(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/usr/local/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
    _mysql.connection.query(self, query)
sqlalchemy.exc.IntegrityError: (MySQLdb._exceptions.IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`homeassistant`.`states`, CONSTRAINT `states_ibfk_2` FOREIGN KEY (`old_state_id`) REFERENCES `states` (`state_id`) ON DELETE NO ACTION)')
[SQL: INSERT INTO states (domain, entity_id, state, attributes, event_id, last_changed, last_updated, created, old_state_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: ('binary_sensor', 'binary_sensor.window_bathroom', 'on', '{"friendly_name":"Window Bathroom","device_class":"opening"}', 122880832, datetime.datetime(2021, 11, 9, 7, 14, 14, 967926, tzinfo=datetime.timezone.utc), datetime.datetime(2021, 11, 9, 7, 14, 14, 967926, tzinfo=datetime.timezone.utc), datetime.datetime(2021, 11, 9, 7, 14, 14, 967926, tzinfo=datetime.timezone.utc), 120863196)]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
2021-11-09 09:03:34 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 09:03:34 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 09:44:29 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 09:44:29 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 10:06:25 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 10:06:25 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 10:17:56 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 10:17:56 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 15:33:49 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 15:33:49 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 16:45:44 WARNING (MainThread) [homeassistant.components.http.ban] Login attempt or request with invalid authentication from 192.168.0.159 (192.168.0.159). (Mozilla/5.0 (iPhone; CPU iPhone OS 15_0_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Home Assistant/2021.10 (io.robbie.HomeAssistant; build:2021.247; iOS 15.0.2) Mobile/HomeAssistant, like Safari)
2021-11-09 16:56:19 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 16:56:19 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-09 17:26:31 WARNING (MainThread) [homeassistant.components.http.ban] Login attempt or request with invalid authentication from 192.168.0.159 (192.168.0.159). (Mozilla/5.0 (iPhone; CPU iPhone OS 15_0_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Home Assistant/2021.10 (io.robbie.HomeAssistant; build:2021.247; iOS 15.0.2) Mobile/HomeAssistant, like Safari)
[s6-init] making user provided files available at /var/run/s6/etc...exited 0.
[s6-init] ensuring user provided files have correct perms...exited 0.
[fix-attrs.d] applying ownership & permissions fixes...
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts...
[cont-init.d] udev.sh: executing... 
[cont-init.d] udev.sh: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
2021-11-11 14:43:25 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=39 from 2021-11-07 17:58:22)
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.setup] Setup of utility_meter is taking over 10 seconds.
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.components.sensor] Setup of sensor platform systemmonitor is taking over 10 seconds.
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.components.sensor] Setup of sensor platform integration is taking over 10 seconds.
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.components.sensor] Setup of sensor platform filter is taking over 10 seconds.
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.components.sensor] Setup of sensor platform command_line is taking over 10 seconds.
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.components.sensor] Setup of sensor platform command_line is taking over 10 seconds.
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.setup] Setup of automation is taking over 10 seconds.
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.components.sensor] Setup of sensor platform energy is taking over 10 seconds.
2021-11-11 14:43:48 WARNING (MainThread) [homeassistant.components.scene] Setup of scene platform tuya is taking over 10 seconds.
2021-11-11 14:43:49 ERROR (MainThread) [homeassistant.components.device_tracker] Platform mobile_app does not generate unique IDs. ID 2E2D6AFB-F122-4956-88B8-101736A6EE44 already exists - ignoring device_tracker.iphone_12_pro_di_jacopo
2021-11-11 15:23:11 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-11 15:23:11 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-11 16:10:33 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2021-11-11 16:10:33 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary

You sorted this out meanwhile?

Of course not!

:face_with_raised_eyebrow:
Alright.

Yesterday I had to turn the power off and when I turned it back on HA never restarted
I tried multiple times with no success

Are you sure it didn’t restart? Often it’s just the GUI that won’t load, either due to bad config (not really an issue these days since they introduced ‘safe mode’) or in your case likely a failed SD card.

How do I know if it has started? I’m pretty sure it’s not a failed SD card as I’ve been having this problem throughout lots of different SD cards and even on a virtual machine

SSH into it and check the logs

I can’t connect to SSH

How about connecting a monitor / TV and keyboard the the RPi?

I don’t have a mini HDMI cable

I’d suggest purchasing one. Since you can’t SSH in, at least this way with a screen and keyboard you should be able to access the logs.

I have, it turns out the Raspberry4 is micro HDMI, not mini :smiley:

So, I was going to ask how to see the logs after connecting a keyboard to the PI, but Home Assistant actually started for some reason

However, I’ll still post the logs

Homeassistant.log

2022-03-07 17:48:48 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=89 from 2022-03-05 14:08:45)
2022-03-07 17:49:03 WARNING (MainThread) [homeassistant.config_entries] Config entry 'shellyswitch25-10521C07265C' for shelly integration not ready yet: Cannot connect to host 192.168.0.15:80 ssl:default [Connect call failed ('192.168.0.15', 80)]; Retrying in background
2022-03-07 17:49:03 WARNING (MainThread) [homeassistant.config_entries] Config entry 'ShellyPlus1-7C87CE589570' for shelly integration not ready yet: Cannot connect to host 192.168.0.16:80 ssl:default [Connect call failed ('192.168.0.16', 80)]; Retrying in background
2022-03-07 17:49:03 WARNING (MainThread) [homeassistant.config_entries] Config entry 'shellyplug-s-DD5053' for shelly integration not ready yet: Cannot connect to host 192.168.0.27:80 ssl:default [Connect call failed ('192.168.0.27', 80)]; Retrying in background
2022-03-07 17:49:03 WARNING (MainThread) [homeassistant.config_entries] Config entry 'shellydimmer-F3E98B' for shelly integration not ready yet: Cannot connect to host 192.168.0.23:80 ssl:default [Connect call failed ('192.168.0.23', 80)]; Retrying in background
2022-03-07 17:49:03 WARNING (MainThread) [homeassistant.components.ios] The 'push' option near /config/configuration.yaml:77 is deprecated, please remove it from your configuration
2022-03-07 17:49:03 WARNING (MainThread) [homeassistant.setup] Setup of utility_meter is taking over 10 seconds.
2022-03-07 17:49:03 ERROR (MainThread) [homeassistant.components.device_tracker] Platform mobile_app does not generate unique IDs. ID 2E2D6AFB-F122-4956-88B8-101736A6EE44 already exists - ignoring device_tracker.iphone_12_pro_di_jacopo
2022-03-07 17:49:05 WARNING (MainThread) [homeassistant.helpers.frame] Detected integration that accessed discovery_info.__contains__('ssdp_location') instead of discovery_info.upnp.__contains__('ssdp_location') or discovery_info.ssdp_headers.__contains__('ssdp_location'); this will fail in version 2022.6. Please report issue for upnp using this method at homeassistant/components/upnp/device.py, line 78: if ssdp.ATTR_SSDP_LOCATION not in headers:
2022-03-07 17:49:05 WARNING (MainThread) [homeassistant.helpers.frame] Detected integration that accessed discovery_info['ssdp_location'] instead of discovery_info.ssdp_location, discovery_info.upnp['ssdp_location'] or discovery_info.ssdp_headers['ssdp_location']; this will fail in version 2022.6. Please report issue for upnp using this method at homeassistant/components/upnp/device.py, line 81: location = headers[ssdp.ATTR_SSDP_LOCATION]
2022-03-07 17:49:05 WARNING (MainThread) [homeassistant.helpers.template] Template warning: 'float' got invalid input 'unknown' when rendering template '{{ value|float + states('sensor.home_energy')|float }}' but no default was specified. Currently 'float' will return '0', however this template will fail to render in Home Assistant core 2022.1
2022-03-07 17:49:08 ERROR (MainThread) [zigpy.application] Couldn't start application
2022-03-07 17:49:08 ERROR (MainThread) [homeassistant.components.zha.core.gateway] Couldn't start EZSP = Silicon Labs EmberZNet protocol: Elelabs, HUSBZB-1, Telegesis coordinator
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 63, in open
    self._socket = socket.create_connection(self.from_url(self.portstr), timeout=POLL_TIMEOUT)
  File "/usr/local/lib/python3.9/socket.py", line 844, in create_connection
    raise err
  File "/usr/local/lib/python3.9/socket.py", line 832, in create_connection
    sock.connect(sa)
OSError: [Errno 113] Host is unreachable

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/zha/core/gateway.py", line 152, in async_initialize
    self.application_controller = await app_controller_cls.new(
  File "/usr/local/lib/python3.9/site-packages/zigpy/application.py", line 69, in new
    await app.startup(auto_form)
  File "/usr/local/lib/python3.9/site-packages/bellows/zigbee/application.py", line 132, in startup
    self._ezsp = await bellows.ezsp.EZSP.initialize(self.config)
  File "/usr/local/lib/python3.9/site-packages/bellows/ezsp/__init__.py", line 82, in initialize
    await ezsp.connect()
  File "/usr/local/lib/python3.9/site-packages/bellows/ezsp/__init__.py", line 92, in connect
    self._gw = await bellows.uart.connect(self._config, self)
  File "/usr/local/lib/python3.9/site-packages/bellows/uart.py", line 363, in connect
    protocol, connection_done = await thread.run_coroutine_threadsafe(
  File "/usr/local/lib/python3.9/site-packages/bellows/uart.py", line 340, in _connect
    transport, protocol = await serial_asyncio.create_serial_connection(
  File "/usr/local/lib/python3.9/site-packages/serial_asyncio/__init__.py", line 448, in create_serial_connection
    serial_instance = serial.serial_for_url(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/serial/__init__.py", line 90, in serial_for_url
    instance.open()
  File "/usr/local/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 66, in open
    raise SerialException("Could not open port {}: {}".format(self.portstr, msg))
serial.serialutil.SerialException: Could not open port socket://192.168.0.35:8888: [Errno 113] Host is unreachable
2022-03-07 17:49:08 WARNING (MainThread) [homeassistant.config_entries] Config entry 'socket://192.168.0.35:8888' for zha integration not ready yet: Could not open port socket://192.168.0.35:8888: [Errno 113] Host is unreachable; Retrying in background
2022-03-07 17:49:23 WARNING (MainThread) [homeassistant.components.sensor] Updating command_line sensor took longer than the scheduled update interval 0:00:03
2022-03-07 17:49:28 ERROR (MainThread) [zigpy.application] Couldn't start application
2022-03-07 17:49:28 ERROR (MainThread) [homeassistant.components.zha.core.gateway] Couldn't start EZSP = Silicon Labs EmberZNet protocol: Elelabs, HUSBZB-1, Telegesis coordinator
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 63, in open
    self._socket = socket.create_connection(self.from_url(self.portstr), timeout=POLL_TIMEOUT)
  File "/usr/local/lib/python3.9/socket.py", line 844, in create_connection
    raise err
  File "/usr/local/lib/python3.9/socket.py", line 832, in create_connection
    sock.connect(sa)
OSError: [Errno 113] Host is unreachable

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/zha/core/gateway.py", line 152, in async_initialize
    self.application_controller = await app_controller_cls.new(
  File "/usr/local/lib/python3.9/site-packages/zigpy/application.py", line 69, in new
    await app.startup(auto_form)
  File "/usr/local/lib/python3.9/site-packages/bellows/zigbee/application.py", line 132, in startup
    self._ezsp = await bellows.ezsp.EZSP.initialize(self.config)
  File "/usr/local/lib/python3.9/site-packages/bellows/ezsp/__init__.py", line 82, in initialize
    await ezsp.connect()
  File "/usr/local/lib/python3.9/site-packages/bellows/ezsp/__init__.py", line 92, in connect
    self._gw = await bellows.uart.connect(self._config, self)
  File "/usr/local/lib/python3.9/site-packages/bellows/uart.py", line 363, in connect
    protocol, connection_done = await thread.run_coroutine_threadsafe(
  File "/usr/local/lib/python3.9/site-packages/bellows/uart.py", line 340, in _connect
    transport, protocol = await serial_asyncio.create_serial_connection(
  File "/usr/local/lib/python3.9/site-packages/serial_asyncio/__init__.py", line 448, in create_serial_connection
    serial_instance = serial.serial_for_url(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/serial/__init__.py", line 90, in serial_for_url
    instance.open()
  File "/usr/local/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 66, in open
    raise SerialException("Could not open port {}: {}".format(self.portstr, msg))
serial.serialutil.SerialException: Could not open port socket://192.168.0.35:8888: [Errno 113] Host is unreachable
2022-03-07 17:49:42 ERROR (MainThread) [zigpy.application] Couldn't start application
2022-03-07 17:49:42 ERROR (MainThread) [homeassistant.components.zha.core.gateway] Couldn't start EZSP = Silicon Labs EmberZNet protocol: Elelabs, HUSBZB-1, Telegesis coordinator
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 63, in open
    self._socket = socket.create_connection(self.from_url(self.portstr), timeout=POLL_TIMEOUT)
  File "/usr/local/lib/python3.9/socket.py", line 844, in create_connection
    raise err
  File "/usr/local/lib/python3.9/socket.py", line 832, in create_connection
    sock.connect(sa)
OSError: [Errno 113] Host is unreachable

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/zha/core/gateway.py", line 152, in async_initialize
    self.application_controller = await app_controller_cls.new(
  File "/usr/local/lib/python3.9/site-packages/zigpy/application.py", line 69, in new
    await app.startup(auto_form)
  File "/usr/local/lib/python3.9/site-packages/bellows/zigbee/application.py", line 132, in startup
    self._ezsp = await bellows.ezsp.EZSP.initialize(self.config)
  File "/usr/local/lib/python3.9/site-packages/bellows/ezsp/__init__.py", line 82, in initialize
    await ezsp.connect()
  File "/usr/local/lib/python3.9/site-packages/bellows/ezsp/__init__.py", line 92, in connect
    self._gw = await bellows.uart.connect(self._config, self)
  File "/usr/local/lib/python3.9/site-packages/bellows/uart.py", line 363, in connect
    protocol, connection_done = await thread.run_coroutine_threadsafe(
  File "/usr/local/lib/python3.9/site-packages/bellows/uart.py", line 340, in _connect
    transport, protocol = await serial_asyncio.create_serial_connection(
  File "/usr/local/lib/python3.9/site-packages/serial_asyncio/__init__.py", line 448, in create_serial_connection
    serial_instance = serial.serial_for_url(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/serial/__init__.py", line 90, in serial_for_url
    instance.open()
  File "/usr/local/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 66, in open
    raise SerialException("Could not open port {}: {}".format(self.portstr, msg))
serial.serialutil.SerialException: Could not open port socket://192.168.0.35:8888: [Errno 113] Host is unreachable
2022-03-07 17:50:05 ERROR (MainThread) [zigpy.application] Couldn't start application
2022-03-07 17:50:05 ERROR (MainThread) [homeassistant.components.zha.core.gateway] Couldn't start EZSP = Silicon Labs EmberZNet protocol: Elelabs, HUSBZB-1, Telegesis coordinator
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 63, in open
    self._socket = socket.create_connection(self.from_url(self.portstr), timeout=POLL_TIMEOUT)
  File "/usr/local/lib/python3.9/socket.py", line 844, in create_connection
    raise err
  File "/usr/local/lib/python3.9/socket.py", line 832, in create_connection
    sock.connect(sa)
OSError: [Errno 113] Host is unreachable

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/zha/core/gateway.py", line 152, in async_initialize
    self.application_controller = await app_controller_cls.new(
  File "/usr/local/lib/python3.9/site-packages/zigpy/application.py", line 69, in new
    await app.startup(auto_form)
  File "/usr/local/lib/python3.9/site-packages/bellows/zigbee/application.py", line 132, in startup
    self._ezsp = await bellows.ezsp.EZSP.initialize(self.config)
  File "/usr/local/lib/python3.9/site-packages/bellows/ezsp/__init__.py", line 82, in initialize
    await ezsp.connect()
  File "/usr/local/lib/python3.9/site-packages/bellows/ezsp/__init__.py", line 92, in connect
    self._gw = await bellows.uart.connect(self._config, self)
  File "/usr/local/lib/python3.9/site-packages/bellows/uart.py", line 363, in connect
    protocol, connection_done = await thread.run_coroutine_threadsafe(
  File "/usr/local/lib/python3.9/site-packages/bellows/uart.py", line 340, in _connect
    transport, protocol = await serial_asyncio.create_serial_connection(
  File "/usr/local/lib/python3.9/site-packages/serial_asyncio/__init__.py", line 448, in create_serial_connection
    serial_instance = serial.serial_for_url(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/serial/__init__.py", line 90, in serial_for_url
    instance.open()
  File "/usr/local/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 66, in open
    raise SerialException("Could not open port {}: {}".format(self.portstr, msg))
serial.serialutil.SerialException: Could not open port socket://192.168.0.35:8888: [Errno 113] Host is unreachable

homeassistant.log.1

2022-03-05 14:08:45 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=88 from 2022-03-05 14:09:12)
2022-03-05 14:08:55 ERROR (MainThread) [homeassistant.config_entries] Error setting up entry shellyswitch25-10521C07265C for shelly
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/config_entries.py", line 327, in async_setup
    result = await component.async_setup_entry(hass, self)
  File "/usr/src/homeassistant/homeassistant/components/shelly/__init__.py", line 132, in async_setup_entry
    return await async_setup_block_entry(hass, entry)
  File "/usr/src/homeassistant/homeassistant/components/shelly/__init__.py", line 146, in async_setup_block_entry
    coap_context = await get_coap_context(hass)
  File "/usr/src/homeassistant/homeassistant/helpers/singleton.py", line 41, in async_wrapped
    result = await func(hass)
  File "/usr/src/homeassistant/homeassistant/components/shelly/utils.py", line 224, in get_coap_context
    await context.initialize(port)
  File "/usr/local/lib/python3.9/site-packages/aioshelly/coap.py", line 85, in initialize
    self.sock = socket_init(socket_port)
  File "/usr/local/lib/python3.9/site-packages/aioshelly/coap.py", line 66, in socket_init
    sock.setsockopt(socket.IPPROTO_IP, socket.IP_ADD_MEMBERSHIP, mreq)
OSError: [Errno 19] No such device
2022-03-05 14:08:55 WARNING (MainThread) [homeassistant.config_entries] Config entry 'ShellyPlus1-7C87CE589570' for shelly integration not ready yet: Cannot connect to host 192.168.0.16:80 ssl:default [Network unreachable]; Retrying in background
2022-03-05 14:09:01 WARNING (MainThread) [homeassistant.setup] Setup of utility_meter is taking over 10 seconds.

Looks like a problem with your ZigBee coordinator.

You also might have some network issues given the Shelly devices not being reached.

Another unexpected restart (I just received the notification) at 2022-06-15 17:32

Here is the log1 (before restart), well, the last part of it, as the forum doesn’t let me paste more than 32000 characters!

OlsiaG9tZS51c2VyIl0sInRhZG9fdXNlcm5hbWUiOiJqYWNvcG9zY2FycGVsbGluaUBnbWFpbC5jb20iLCJhdGkiOiJmNjJmNzEzYy0wYjU4Lda6yMhqkymax-0yUzhWVcSlcFKDTiFeTDzFHwxY4uLdYHSBw69iUn20IL1hhuGcbptJ_mici4xQxc99bvj0CwoQoVlIKeKijIK4yYdgzzpRj732TYh-uYhPCoSGSyoQaijHhCj1v_y4gmmzO8NtItonkExCkjYWcHQ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f7724c370>: Failed to establish a new connection: [Errno -3] Try again'))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 83, in <lambda>
    lambda now: tadoconnector.update(),
  File "/usr/src/homeassistant/homeassistant/util/__init__.py", line 192, in wrapper
    result = method(*args, **kwargs)
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 176, in update
    self.update_devices()
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 186, in update_devices
    devices = self.tado.getDevices()
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 170, in getDevices
    data = self._apiCall(cmd)
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 62, in _apiCall
    self._refresh_token()
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 126, in _refresh_token
    response = self._http_session.request("post", url, params=data, timeout=self.timeout, data=json.dumps({}).encode('utf8'),
  File "/usr/local/lib/python3.9/site-packages/requests/sessions.py", line 529, in request
    resp = self.send(prep, **send_kwargs)
  File "/usr/local/lib/python3.9/site-packages/requests/sessions.py", line 645, in send
    r = adapter.send(request, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/requests/adapters.py", line 519, in send
    raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPSConnectionPool(host='auth.tado.com', port=443): Max retries exceeded with url: /oauth/token?client_id=public-api-preview&client_secret=4HJGRffVR8xb3XdEUQpjgZ1VplJi6Xgw&grant_type=refresh_token&scope=home.user&refresh_token=eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsicGFydG5lciJdLCJzdWIiOiI1ZGYzYzFlNTZiMmYwNzAwMGNjZGY0ZjEiLCJuYmYiOjE2NTUyNDcyNjQsInRhZG9fc2NvcGUiOlsiaG9tZS51c2VyIl0sInRhZG9fdXNlcm5hbWUiOiJqYWNvcG9zY2FycGVsbGluaUBnbWFpbC5jb20iLCJhdGkiOiJmNjJmNzEzYy0wYjU4Lda6yMhqkymax-0yUzhWVcSlcFKDTiFeTDzFHwxY4uLdYHSBw69iUn20IL1hhuGcbptJ_mici4xQxc99bvj0CwoQoVlIKeKijIK4yYdgzzpRj732TYh-uYhPCoSGSyoQaijHhCj1v_y4gmmzO8NtItonkExCkjYWcHQ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f7724c370>: Failed to establish a new connection: [Errno -3] Try again'))
2022-06-15 00:45:22 WARNING (MainThread) [bellows.zigbee.application] Watchdog heartbeat timeout: 
2022-06-15 00:46:20 WARNING (MainThread) [bellows.zigbee.application] Watchdog heartbeat timeout: 
2022-06-15 00:47:19 WARNING (MainThread) [bellows.zigbee.application] Watchdog heartbeat timeout: 
2022-06-15 00:47:34 WARNING (MainThread) [bellows.zigbee.application] Watchdog heartbeat timeout: 
2022-06-15 00:49:21 WARNING (MainThread) [bellows.zigbee.application] Watchdog heartbeat timeout: 
2022-06-15 00:49:29 ERROR (MainThread) [homeassistant] Error doing job: Future exception was never retrieved
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 174, in _new_conn
    conn = connection.create_connection(
  File "/usr/local/lib/python3.9/site-packages/urllib3/util/connection.py", line 72, in create_connection
    for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
  File "/usr/local/lib/python3.9/socket.py", line 954, in getaddrinfo
    for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno -3] Try again

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 703, in urlopen
    httplib_response = self._make_request(
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 386, in _make_request
    self._validate_conn(conn)
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 1040, in _validate_conn
    conn.connect()
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 358, in connect
    self.sock = conn = self._new_conn()
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 186, in _new_conn
    raise NewConnectionError(
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPSConnection object at 0x7f78755340>: Failed to establish a new connection: [Errno -3] Try again

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/requests/adapters.py", line 440, in send
    resp = conn.urlopen(
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 785, in urlopen
    retries = retries.increment(
  File "/usr/local/lib/python3.9/site-packages/urllib3/util/retry.py", line 592, in increment
    raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='auth.tado.com', port=443): Max retries exceeded with url: /oauth/token?client_id=public-api-preview&client_secret=4HJGRffVR8xb3XdEUQpjgZ1VplJi6Xgw&grant_type=refresh_token&scope=home.user&refresh_token=eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsicGFydG5lciJdLCJzdWIiOiI1ZGYzYzFlNTZiMmYwNzAwMGNjZGY0ZjEiLCJuYmYiOjE2NTUyNDcyNjQsInRhZG9fc2NvcGUiOlsiaG9tZS51c2VyIl0sInRhZG9fdXNlcm5hbWUiOiJqYWNvcG9zY2FycGVsbGluaUBnbWFpbC5jb20iLCJhdGkiOiJmNjJmNzEzYy0wYjU4Lda6yMhqkymax-0yUzhWVcSlcFKDTiFeTDzFHwxY4uLdYHSBw69iUn20IL1hhuGcbptJ_mici4xQxc99bvj0CwoQoVlIKeKijIK4yYdgzzpRj732TYh-uYhPCoSGSyoQaijHhCj1v_y4gmmzO8NtItonkExCkjYWcHQ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f78755340>: Failed to establish a new connection: [Errno -3] Try again'))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 83, in <lambda>
    lambda now: tadoconnector.update(),
  File "/usr/src/homeassistant/homeassistant/util/__init__.py", line 192, in wrapper
    result = method(*args, **kwargs)
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 176, in update
    self.update_devices()
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 186, in update_devices
    devices = self.tado.getDevices()
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 170, in getDevices
    data = self._apiCall(cmd)
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 62, in _apiCall
    self._refresh_token()
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 126, in _refresh_token
    response = self._http_session.request("post", url, params=data, timeout=self.timeout, data=json.dumps({}).encode('utf8'),
  File "/usr/local/lib/python3.9/site-packages/requests/sessions.py", line 529, in request
    resp = self.send(prep, **send_kwargs)
  File "/usr/local/lib/python3.9/site-packages/requests/sessions.py", line 645, in send
    r = adapter.send(request, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/requests/adapters.py", line 519, in send
    raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPSConnectionPool(host='auth.tado.com', port=443): Max retries exceeded with url: /oauth/token?client_id=public-api-preview&client_secret=4HJGRffVR8xb3XdEUQpjgZ1VplJi6Xgw&grant_type=refresh_token&scope=home.user&refresh_token=eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsicGFydG5lciJdLCJzdWIiOiI1ZGYzYzFlNTZiMmYwNzAwMGNjZGY0ZjEiLCJuYmYiOjE2NTUyNDcyNjQsInRhZG9fc2NvcGUiOlsiaG9tZS51c2VyIl0sInRhZG9fdXNlcm5hbWUiOiJqYWNvcG9zY2FycGVsbGluaUBnbWFpbC5jb20iLCJhdGkiOiJmNjJmNzEzYy0wYjU4Lda6yMhqkymax-0yUzhWVcSlcFKDTiFeTDzFHwxY4uLdYHSBw69iUn20IL1hhuGcbptJ_mici4xQxc99bvj0CwoQoVlIKeKijIK4yYdgzzpRj732TYh-uYhPCoSGSyoQaijHhCj1v_y4gmmzO8NtItonkExCkjYWcHQ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f78755340>: Failed to establish a new connection: [Errno -3] Try again'))
2022-06-15 00:50:20 WARNING (MainThread) [bellows.zigbee.application] Watchdog heartbeat timeout: 
2022-06-15 00:51:19 WARNING (MainThread) [bellows.zigbee.application] Watchdog heartbeat timeout: 
2022-06-15 00:54:24 ERROR (SyncWorker_6) [homeassistant] Error doing job: Future exception was never retrieved
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 174, in _new_conn
    conn = connection.create_connection(
  File "/usr/local/lib/python3.9/site-packages/urllib3/util/connection.py", line 72, in create_connection
    for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
  File "/usr/local/lib/python3.9/socket.py", line 954, in getaddrinfo
    for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno -2] Name does not resolve

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 703, in urlopen
    httplib_response = self._make_request(
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 386, in _make_request
    self._validate_conn(conn)
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 1040, in _validate_conn
    conn.connect()
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 358, in connect
    self.sock = conn = self._new_conn()
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 186, in _new_conn
    raise NewConnectionError(
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPSConnection object at 0x7f7c597400>: Failed to establish a new connection: [Errno -2] Name does not resolve

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/requests/adapters.py", line 440, in send
    resp = conn.urlopen(
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 785, in urlopen
    retries = retries.increment(
  File "/usr/local/lib/python3.9/site-packages/urllib3/util/retry.py", line 592, in increment
    raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='auth.tado.com', port=443): Max retries exceeded with url: /oauth/token?client_id=public-api-preview&client_secret=4HJGRffVR8xb3XdEUQpjgZ1VplJi6Xgw&grant_type=refresh_token&scope=home.user&refresh_token=eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsicGFydG5lciJdLCJzdWIiOiI1ZGYzYzFlNTZiMmYwNzAwMGNjZGY0ZjEiLCJuYmYiOjE2NTUyNDcyNjQsInRhZG9fc2NvcGUiOlsiaG9tZS51c2VyIl0sInRhZG9fdXNlcm5hbWUiOiJqYWNvcG9zY2FycGVsbGluaUBnbWFpbC5jb20iLCJhdGkiOiJmNjJmNzEzYy0wYjU4Lda6yMhqkymax-0yUzhWVcSlcFKDTiFeTDzFHwxY4uLdYHSBw69iUn20IL1hhuGcbptJ_mici4xQxc99bvj0CwoQoVlIKeKijIK4yYdgzzpRj732TYh-uYhPCoSGSyoQaijHhCj1v_y4gmmzO8NtItonkExCkjYWcHQ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f7c597400>: Failed to establish a new connection: [Errno -2] Name does not resolve'))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 83, in <lambda>
    lambda now: tadoconnector.update(),
  File "/usr/src/homeassistant/homeassistant/util/__init__.py", line 192, in wrapper
    result = method(*args, **kwargs)
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 176, in update
    self.update_devices()
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 186, in update_devices
    devices = self.tado.getDevices()
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 170, in getDevices
    data = self._apiCall(cmd)
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 62, in _apiCall
    self._refresh_token()
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 126, in _refresh_token
    response = self._http_session.request("post", url, params=data, timeout=self.timeout, data=json.dumps({}).encode('utf8'),
  File "/usr/local/lib/python3.9/site-packages/requests/sessions.py", line 529, in request
    resp = self.send(prep, **send_kwargs)
  File "/usr/local/lib/python3.9/site-packages/requests/sessions.py", line 645, in send
    r = adapter.send(request, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/requests/adapters.py", line 519, in send
    raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPSConnectionPool(host='auth.tado.com', port=443): Max retries exceeded with url: /oauth/token?client_id=public-api-preview&client_secret=4HJGRffVR8xb3XdEUQpjgZ1VplJi6Xgw&grant_type=refresh_token&scope=home.user&refresh_token=eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsicGFydG5lciJdLCJzdWIiOiI1ZGYzYzFlNTZiMmYwNzAwMGNjZGY0ZjEiLCJuYmYiOjE2NTUyNDcyNjQsInRhZG9fc2NvcGUiOlsiaG9tZS51c2VyIl0sInRhZG9fdXNlcm5hbWUiOiJqYWNvcG9zY2FycGVsbGluaUBnbWFpbC5jb20iLCJhdGkiOiJmNjJmNzEzYy0wYjU4Lda6yMhqkymax-0yUzhWVcSlcFKDTiFeTDzFHwxY4uLdYHSBw69iUn20IL1hhuGcbptJ_mici4xQxc99bvj0CwoQoVlIKeKijIK4yYdgzzpRj732TYh-uYhPCoSGSyoQaijHhCj1v_y4gmmzO8NtItonkExCkjYWcHQ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f7c597400>: Failed to establish a new connection: [Errno -2] Name does not resolve'))
2022-06-15 00:59:24 ERROR (MainThread) [homeassistant] Error doing job: Future exception was never retrieved
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 174, in _new_conn
    conn = connection.create_connection(
  File "/usr/local/lib/python3.9/site-packages/urllib3/util/connection.py", line 72, in create_connection
    for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
  File "/usr/local/lib/python3.9/socket.py", line 954, in getaddrinfo
    for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno -2] Name does not resolve

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 703, in urlopen
    httplib_response = self._make_request(
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 386, in _make_request
    self._validate_conn(conn)
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 1040, in _validate_conn
    conn.connect()
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 358, in connect
    self.sock = conn = self._new_conn()
  File "/usr/local/lib/python3.9/site-packages/urllib3/connection.py", line 186, in _new_conn
    raise NewConnectionError(
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPSConnection object at 0x7f75bb7e20>: Failed to establish a new connection: [Errno -2] Name does not resolve

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/requests/adapters.py", line 440, in send
    resp = conn.urlopen(
  File "/usr/local/lib/python3.9/site-packages/urllib3/connectionpool.py", line 785, in urlopen
    retries = retries.increment(
  File "/usr/local/lib/python3.9/site-packages/urllib3/util/retry.py", line 592, in increment
    raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='auth.tado.com', port=443): Max retries exceeded with url: /oauth/token?client_id=public-api-preview&client_secret=4HJGRffVR8xb3XdEUQpjgZ1VplJi6Xgw&grant_type=refresh_token&scope=home.user&refresh_token=eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsicGFydG5lciJdLCJzdWIiOiI1ZGYzYzFlNTZiMmYwNzAwMGNjZGY0ZjEiLCJuYmYiOjE2NTUyNDcyNjQsInRhZG9fc2NvcGUiOlsiaG9tZS51c2VyIl0sInRhZG9fdXNlcm5hbWUiOiJqYWNvcG9zY2FycGVsbGluaUBnbWFpbC5jb20iLCJhdGkiOiJmNjJmNzEzYy0wYjU4Lda6yMhqkymax-0yUzhWVcSlcFKDTiFeTDzFHwxY4uLdYHSBw69iUn20IL1hhuGcbptJ_mici4xQxc99bvj0CwoQoVlIKeKijIK4yYdgzzpRj732TYh-uYhPCoSGSyoQaijHhCj1v_y4gmmzO8NtItonkExCkjYWcHQ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f75bb7e20>: Failed to establish a new connection: [Errno -2] Name does not resolve'))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 83, in <lambda>
    lambda now: tadoconnector.update(),
  File "/usr/src/homeassistant/homeassistant/util/__init__.py", line 192, in wrapper
    result = method(*args, **kwargs)
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 176, in update
    self.update_devices()
  File "/usr/src/homeassistant/homeassistant/components/tado/__init__.py", line 186, in update_devices
    devices = self.tado.getDevices()
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 170, in getDevices
    data = self._apiCall(cmd)
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 62, in _apiCall
    self._refresh_token()
  File "/usr/local/lib/python3.9/site-packages/PyTado/interface.py", line 126, in _refresh_token
    response = self._http_session.request("post", url, params=data, timeout=self.timeout, data=json.dumps({}).encode('utf8'),
  File "/usr/local/lib/python3.9/site-packages/requests/sessions.py", line 529, in request
    resp = self.send(prep, **send_kwargs)
  File "/usr/local/lib/python3.9/site-packages/requests/sessions.py", line 645, in send
    r = adapter.send(request, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/requests/adapters.py", line 519, in send
    raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPSConnectionPool(host='auth.tado.com', port=443): Max retries exceeded with url: /oauth/token?client_id=public-api-preview&client_secret=4HJGRffVR8xb3XdEUQpjgZ1VplJi6Xgw&grant_type=refresh_token&scope=home.user&refresh_token=eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsicGFydG5lciJdLCJzdWIiOiI1ZGYzYzFlNTZiMmYwNzAwMGNjZGY0ZjEiLCJuYmYiOjE2NTUyNDcyNjQsInRhZG9fc2NvcGUiOlsiaG9tZS51c2VyIl0sInRhZG9fdXNlcm5hbWUiOiJqYWNvcG9zY2FycGVsbGluaUBnbWFpbC5jb20iLCJhdGkiOiJmNjJmNzEzYy0wYjU4Lda6yMhqkymax-0yUzhWVcSlcFKDTiFeTDzFHwxY4uLdYHSBw69iUn20IL1hhuGcbptJ_mici4xQxc99bvj0CwoQoVlIKeKijIK4yYdgzzpRj732TYh-uYhPCoSGSyoQaijHhCj1v_y4gmmzO8NtItonkExCkjYWcHQ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f75bb7e20>: Failed to establish a new connection: [Errno -2] Name does not resolve'))
2022-06-15 01:58:43 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 01:58:43 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 04:00:01 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 04:00:01 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 06:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 06:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 06:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 06:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 06:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 06:00:00 WARNING (MainThread) [homeassistant.helpers.service] Unable to find referenced entities switch.elettra_charger_switch
2022-06-15 06:14:09 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:14:09 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:24:15 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:24:15 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:29:08 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:29:08 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:34:01 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:34:01 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:38:55 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:38:55 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:43:48 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:43:48 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:48:40 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:48:40 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:53:33 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 06:53:33 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 07:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 07:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 07:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 07:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 07:00:00 WARNING (MainThread) [homeassistant.components.utility_meter.select] The 'utility_meter.select_tariff' service has been deprecated and will be removed in HA Core 2022.7. Please use 'select.select_option' instead
2022-06-15 07:00:18 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:00:18 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:01:11 WARNING (MainThread) [homeassistant.components.http.ban] Login attempt or request with invalid authentication from 194.35.232.198 (194.35.232.198). (Mozilla/5.0 (iPhone; CPU iPhone OS 15_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Home Assistant/2022.3 (io.robbie.HomeAssistant; build:2022.358; iOS 15.5.0) Mobile/HomeAssistant, like Safari)
2022-06-15 07:01:13 WARNING (MainThread) [homeassistant.components.http.ban] Login attempt or request with invalid authentication from 194.35.232.198 (194.35.232.198). (Mozilla/5.0 (iPhone; CPU iPhone OS 15_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Home Assistant/2022.3 (io.robbie.HomeAssistant; build:2022.358; iOS 15.5.0) Mobile/HomeAssistant, like Safari)
2022-06-15 07:07:03 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:07:03 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:13:19 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:13:19 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:19:36 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:19:36 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:26:20 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:26:20 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:34:57 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:34:57 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:44:30 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:44:30 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:57:47 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 07:57:47 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:03:00 WARNING (MainThread) [homeassistant.components.http.ban] Login attempt or request with invalid authentication from 194.35.232.197 (194.35.232.197). (Mozilla/5.0 (iPhone; CPU iPhone OS 15_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Home Assistant/2022.3 (io.robbie.HomeAssistant; build:2022.358; iOS 15.5.0) Mobile/HomeAssistant, like Safari)
2022-06-15 08:09:40 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:09:40 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:24:22 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:24:22 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:38:09 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:38:09 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:43:00 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:43:00 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:47:51 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:47:51 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:54:35 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 08:54:35 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 09:13:57 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 09:13:57 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 09:38:56 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 09:38:56 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 10:20:21 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 10:20:21 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 11:11:45 ERROR (MainThread) [homeassistant.components.hassio.handler] Timeout on /addons/core_mariadb/stats request
2022-06-15 11:11:45 WARNING (MainThread) [homeassistant.components.hassio] Could not fetch stats for core_mariadb: 
2022-06-15 12:36:43 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 12:36:43 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 12:49:04 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 12:49:04 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 13:23:56 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 13:23:56 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 14:16:12 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 14:16:12 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 14:34:40 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 14:34:40 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 14:47:03 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 14:47:03 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 15:58:34 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 15:58:34 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 16:22:42 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
2022-06-15 16:22:42 WARNING (MainThread) [homeassistant.components.mqtt.mixins] JSON result was not a dictionary
``

A lot of that seems to be an authentication issue with Tado. Try disabling that integration for now.

There’s also a socket error on your Zigbee, like I mentioned previously.

I’ve disabled Tado

I don’t know what to do with Zigbee

So less errors now with Tado disabled? It might just need to be reconfigured with me authentication or something, it’s not an integration I use myself so I don’t know anything about it.

For the Zigbee, go into settings and look at the hardware section. Make sure the USB address is what you have in the Zigbee integration configuration. Maybe try a different USB port…