HA (Core) doesn't start up anymore

Hello,

After installing the latest version of HA 2022.9.4 on my raspi it is not starting up fully anymore. I tried to solve it for some days now, going back to 2022.8 and even 2022.6 without success. I also tried te disable some integrations. Now I’m in some way out of ideas.

The log-file is

2022-09-16 03:19:30.925 WARNING (Recorder) [homeassistant.components.recorder.util] The system could not validate that the sqlite3 database at //home/homeassistant/.homeassistant/home-assistant_v2.db was shutdown cleanly
2022-09-16 03:19:39.678 WARNING (MainThread) [homeassistant.components.mqtt] The 'birth_message' option near /home/homeassistant/.homeassistant/configuration.yaml:13 is deprecated, please remove it from your configuration
2022-09-16 03:19:39.684 WARNING (MainThread) [homeassistant.components.mqtt] The 'broker' option near /home/homeassistant/.homeassistant/configuration.yaml:13 is deprecated, please remove it from your configuration
2022-09-16 03:19:39.685 WARNING (MainThread) [homeassistant.components.mqtt] The 'discovery' option near /home/homeassistant/.homeassistant/configuration.yaml:13 is deprecated, please remove it from your configuration
2022-09-16 03:19:39.686 WARNING (MainThread) [homeassistant.components.mqtt] The 'will_message' option near /home/homeassistant/.homeassistant/configuration.yaml:13 is deprecated, please remove it from your configuration
2022-09-16 03:19:39.847 WARNING (MainThread) [pyotgw.commandprocessor] Unknown message in command queue: SC: 03:19/5
2022-09-16 03:19:39.852 WARNING (MainThread) [pyotgw.commandprocessor] Command PS failed with SC: 03:19/5, retrying...
2022-09-16 03:19:40.383 WARNING (MainThread) [pyotgw.commandprocessor] Unknown message in command queue: PS: 0
2022-09-16 03:19:40.385 WARNING (MainThread) [pyotgw.commandprocessor] Command PR failed with PS: 0, retrying...
2022-09-16 03:19:41.570 WARNING (MainThread) [androidtv.adb_manager.adb_manager_async] Couldn't connect to 10.0.0.27:5555.  TcpTimeoutException: Connecting to 10.0.0.27:5555 timed out (1.0 seconds)
2022-09-16 03:19:41.573 WARNING (MainThread) [homeassistant.config_entries] Config entry 'BernisLeinwand' for androidtv integration not ready yet: Could not connect to Android TV / Fire TV device at 10.0.0.27:5555 using Python ADB implementation with adbkey='/home/homeassistant/.homeassistant/.storage/androidtv_adbkey'; Retrying in background
2022-09-16 03:19:43.535 WARNING (MainThread) [homeassistant.components.home_connect] The 'home_connect' option near /home/homeassistant/.homeassistant/configuration.yaml:1 is deprecated, please remove it from your configuration
2022-09-16 03:19:43.541 WARNING (MainThread) [homeassistant.components.home_connect] Configuration of Home Connect integration in YAML is deprecated and will be removed in a future release; Your existing OAuth Application Credentials have been imported into the UI automatically and can be safely removed from your configuration.yaml file
2022-09-16 03:19:49.422 ERROR (MainThread) [homeassistant] Error doing job: Exception in callback SerialTransport._call_connection_lost(None)
Traceback (most recent call last):
  File "/usr/lib/python3.9/asyncio/events.py", line 80, in _run
    self._context.run(self._callback, *self._args)
  File "/srv/homeassistant/lib/python3.9/site-packages/serial_asyncio/__init__.py", line 414, in _call_connection_lost
    self._serial.close()
  File "/srv/homeassistant/lib/python3.9/site-packages/serial/urlhandler/protocol_socket.py", line 104, in close
    time.sleep(0.3)
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/util/async_.py", line 180, in protected_loop_func
    check_loop(func, strict=strict)
  File "/srv/homeassistant/lib/python3.9/site-packages/homeassistant/util/async_.py", line 141, in check_loop
    raise RuntimeError(
RuntimeError: Detected blocking call to sleep inside the event loop. Use `await hass.async_add_executor_job()`; This is causing stability issues. Please report issue
2022-09-16 03:19:49.467 WARNING (MainThread) [homeassistant.config_entries] Config entry 'Zentralheizung' for opentherm_gw integration not ready yet: Could not connect to gateway at socket://10.0.0.26:25238: ; Retrying in background
2022-09-16 03:19:50.838 WARNING (MainThread) [homeassistant.config_entries] Config entry 'roborock.vacuum' for xiaomi_miio integration not ready yet; Retrying in background
2022-09-16 03:19:50.839 WARNING (MainThread) [homeassistant.config_entries] Config entry 'Robi' for xiaomi_miio integration not ready yet; Retrying in background
2022-09-16 03:20:04.794 WARNING (MainThread) [homeassistant.components.kodi.media_player] Unable to connect to Kodi via websocket
2022-09-16 03:20:05.796 WARNING (MainThread) [androidtv.adb_manager.adb_manager_async] Couldn't connect to 10.0.0.27:5555.  TcpTimeoutException: Connecting to 10.0.0.27:5555 timed out (1.0 seconds)
2022-09-16 03:20:15.958 ERROR (MainThread) [homeassistant.components.google_assistant.http] Request for https://homegraph.googleapis.com/v1/devices:requestSync failed: 500
2022-09-16 03:20:16.813 WARNING (MainThread) [androidtv.adb_manager.adb_manager_async] Couldn't connect to 10.0.0.27:5555.  TcpTimeoutException: Connecting to 10.0.0.27:5555 timed out (1.0 seconds)
2022-09-16 03:20:37.823 WARNING (MainThread) [androidtv.adb_manager.adb_manager_async] Couldn't connect to 10.0.0.27:5555.  TcpTimeoutException: Connecting to 10.0.0.27:5555 timed out (1.0 seconds)
2022-09-16 03:23:07.484 ERROR (MainThread) [homeassistant.components.androidtv.media_player] Failed to execute an ADB command. ADB connection re-establishing attempt in the next update. Error: Reading from 10.0.0.27:5555 timed out (9.0 seconds)
2022-09-16 03:23:09.484 WARNING (MainThread) [androidtv.adb_manager.adb_manager_async] Couldn't connect to 10.0.0.27:5555.  TcpTimeoutException: Connecting to 10.0.0.27:5555 timed out (1.0 seconds)
2022-09-16 03:23:15.709 WARNING (Thread-6) [pychromecast.socket_client] [BernisLeinwand(10.0.0.27):8009] Heartbeat timeout, resetting connection
2022-09-16 03:23:45.739 ERROR (Thread-6) [pychromecast.socket_client] [BernisLeinwand(10.0.0.27):8009] Failed to connect to service ServiceInfo(type='host', data=('10.0.0.27', 8009)), retrying in 5.0s

On the UI I see the loading screen with

Unable to connect to Home Assistant.

Retrying in -643 seconds...

For me it seams something in the core of homeassistant is stuck very badly. I don’t know how to disable all integrations and enable the one by one to find the problem.

Unfortunately I did also some other upgrades at the same time, so I don’t know if the upgrade of the home assistant is the reason for the problem.

Any help how to find the problem would be very helpful.

Sorry, was on the wrong track because of two independent problems
1.) After updates of my router the forwarding of external requests has changed so the UI was running (at least for my last trys), even when i got these error responses in browser from inside my network.
2.) After the apt upgrade of my raspi the zigbee usb device was not recognized/initialized correctly so all automations with zigbee didn’t work anymore.