Where did my Integrations Go?!

hackerkatt · March 7, 2021, 4:44am

Hmmmm,

I know this isn’t a lot of information for troubleshooting… But WT??? where did my integrations disappear too? I did a fresh install on Debian 10 (to satisfy the support requirement) and a restore of my latest “working” snapshot backup. Working with the exception of ALL of my Z-Wave stuff was broken. This broke coincedentally at the very time I did a Core update. I’ve linked the two related discussions on this issue below. Following the restore, all USB Hubs were available again, AeonTec Z-Wave Hub and devices, Wyze Hub and devices, all Integrations, Automations and Node-Red Flows, all working. I come back a few hours later to find this.

Selection_032

Core Update Broke my Z-Wave
Core update broke my install - Reinstall-Dilemma

The current supervisor log entries. I don’t see any issues. The same is true of the home-assistant.log.

21-03-07 04:23:49 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:23:49 INFO (SyncWorker_3) [supervisor.docker.interface] Cleaning addon_cebe7a76_hassio_google_drive_backup application
21-03-07 04:23:49 INFO (SyncWorker_3) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:23:50 INFO (SyncWorker_3) [supervisor.docker.addon] Starting Docker add-on sabeechen/hassio-google-drive-backup-amd64 with version 3.12
21-03-07 04:23:50 INFO (SyncWorker_4) [supervisor.docker.interface] Cleaning addon_a0d7b954_nodered application
21-03-07 04:23:50 INFO (MainThread) [supervisor.api.security] /host/info access from a0d7b954_esphome
21-03-07 04:23:50 INFO (SyncWorker_4) [supervisor.docker.addon] Starting Docker add-on hassioaddons/node-red-amd64 with version 7.2.11
21-03-07 04:23:51 INFO (MainThread) [supervisor.api.security] /host/info access from a0d7b954_nodered
21-03-07 04:23:51 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:23:51 INFO (MainThread) [supervisor.api.security] /core/info access from cebe7a76_hassio_google_drive_backup
21-03-07 04:23:51 INFO (MainThread) [supervisor.api.security] /supervisor/info access from cebe7a76_hassio_google_drive_backup
21-03-07 04:23:51 INFO (MainThread) [supervisor.api.security] /snapshots access from cebe7a76_hassio_google_drive_backup
21-03-07 04:23:51 INFO (MainThread) [supervisor.api.security] /snapshots/c7835b52/info access from cebe7a76_hassio_google_drive_backup
21-03-07 04:23:51 INFO (MainThread) [supervisor.api.security] /snapshots/3739c660/info access from cebe7a76_hassio_google_drive_backup
21-03-07 04:23:52 INFO (MainThread) [supervisor.api.security] /dns/info access from a0d7b954_nodered
21-03-07 04:23:55 INFO (MainThread) [supervisor.misc.tasks] All core tasks are scheduled
21-03-07 04:23:55 INFO (MainThread) [supervisor.core] Supervisor is up and running
21-03-07 04:23:55 INFO (MainThread) [supervisor.host.info] Updating local host information
21-03-07 04:23:55 INFO (MainThread) [supervisor.updater] Fetching update data from https://version.home-assistant.io/stable.json
21-03-07 04:23:55 INFO (MainThread) [supervisor.resolution.check] Starting system checks with state CoreState.RUNNING
21-03-07 04:23:55 INFO (MainThread) [supervisor.resolution.checks.base] Run check for IssueType.SECURITY/ContextType.CORE
21-03-07 04:23:55 INFO (MainThread) [supervisor.resolution.checks.base] Run check for IssueType.FREE_SPACE/ContextType.SYSTEM
21-03-07 04:23:55 INFO (MainThread) [supervisor.resolution.checks.base] Run check for IssueType.PWNED/ContextType.ADDON
21-03-07 04:23:55 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:23:56 INFO (MainThread) [supervisor.resolution.check] System checks complete
21-03-07 04:23:56 INFO (MainThread) [supervisor.resolution.fixup] Starting system autofix at state CoreState.RUNNING
21-03-07 04:23:56 INFO (MainThread) [supervisor.resolution.fixup] System autofix complete
21-03-07 04:23:56 INFO (MainThread) [supervisor.host.services] Updating service information
21-03-07 04:23:56 INFO (MainThread) [supervisor.host.network] Updating local network information
21-03-07 04:23:57 INFO (MainThread) [supervisor.host.sound] Updating PulseAudio information
21-03-07 04:23:57 INFO (MainThread) [supervisor.host] Host information reload completed
21-03-07 04:24:06 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API request initialize
21-03-07 04:24:06 INFO (MainThread) [supervisor.api.proxy] WebSocket access from a0d7b954_nodered
21-03-07 04:24:06 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API request running
21-03-07 04:25:43 INFO (SyncWorker_1) [supervisor.docker.interface] Updating image esphome/esphome-hassio-amd64:1.15.3 to esphome/esphome-hassio-amd64:1.16.2
21-03-07 04:25:43 INFO (SyncWorker_1) [supervisor.docker.interface] Downloading docker image esphome/esphome-hassio-amd64 with tag 1.16.2.
21-03-07 04:25:47 INFO (SyncWorker_1) [supervisor.docker.interface] Stopping addon_a0d7b954_esphome application
21-03-07 04:25:47 INFO (SyncWorker_1) [supervisor.docker.interface] Cleaning addon_a0d7b954_esphome application
21-03-07 04:25:47 INFO (MainThread) [supervisor.addons] Add-on 'a0d7b954_esphome' successfully updated
21-03-07 04:25:47 INFO (SyncWorker_2) [supervisor.docker.interface] Cleanup images: ['esphome/esphome-hassio-amd64:1.15.3']
21-03-07 04:25:48 INFO (SyncWorker_3) [supervisor.docker.addon] Starting Docker add-on esphome/esphome-hassio-amd64 with version 1.16.2
21-03-07 04:25:48 INFO (MainThread) [supervisor.api.security] /host/info access from a0d7b954_esphome
21-03-07 04:25:52 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:25:56 INFO (SyncWorker_4) [supervisor.docker.interface] Updating image sabeechen/hassio-google-drive-backup-amd64:3.12 to sabeechen/hassio-google-drive-backup-amd64:0.103.1
21-03-07 04:25:56 INFO (SyncWorker_4) [supervisor.docker.interface] Downloading docker image sabeechen/hassio-google-drive-backup-amd64 with tag 0.103.1.
21-03-07 04:26:09 INFO (SyncWorker_4) [supervisor.docker.interface] Stopping addon_cebe7a76_hassio_google_drive_backup application
21-03-07 04:26:10 INFO (SyncWorker_4) [supervisor.docker.interface] Cleaning addon_cebe7a76_hassio_google_drive_backup application
21-03-07 04:26:10 INFO (MainThread) [supervisor.addons] Add-on 'cebe7a76_hassio_google_drive_backup' successfully updated
21-03-07 04:26:10 INFO (SyncWorker_5) [supervisor.docker.interface] Cleanup images: ['sabeechen/hassio-google-drive-backup-amd64:0.103.0']
21-03-07 04:26:11 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:26:11 INFO (SyncWorker_1) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:26:12 INFO (SyncWorker_1) [supervisor.docker.addon] Starting Docker add-on sabeechen/hassio-google-drive-backup-amd64 with version 0.103.1
21-03-07 04:26:12 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:26:12 INFO (MainThread) [supervisor.homeassistant.secrets] Request secret snapshot_password
21-03-07 04:26:12 INFO (MainThread) [supervisor.api.security] /core/info access from cebe7a76_hassio_google_drive_backup
21-03-07 04:26:12 INFO (MainThread) [supervisor.api.security] /supervisor/info access from cebe7a76_hassio_google_drive_backup
21-03-07 04:26:12 INFO (MainThread) [supervisor.api.security] /snapshots access from cebe7a76_hassio_google_drive_backup
21-03-07 04:26:12 INFO (MainThread) [supervisor.api.security] /snapshots/c7835b52/info access from cebe7a76_hassio_google_drive_backup
21-03-07 04:26:12 INFO (MainThread) [supervisor.api.security] /snapshots/3739c660/info access from cebe7a76_hassio_google_drive_backup
21-03-07 04:26:26 INFO (SyncWorker_0) [supervisor.docker.interface] Updating image homeassistant/amd64-addon-mosquitto:5.1 to homeassistant/amd64-addon-mosquitto:5.1.1
21-03-07 04:26:26 INFO (SyncWorker_0) [supervisor.docker.interface] Downloading docker image homeassistant/amd64-addon-mosquitto with tag 5.1.1.
21-03-07 04:26:31 INFO (SyncWorker_0) [supervisor.docker.interface] Stopping addon_core_mosquitto application
21-03-07 04:26:32 INFO (SyncWorker_0) [supervisor.docker.interface] Cleaning addon_core_mosquitto application
21-03-07 04:26:33 INFO (MainThread) [supervisor.addons] Add-on 'core_mosquitto' successfully updated
21-03-07 04:26:33 INFO (SyncWorker_1) [supervisor.docker.interface] Cleanup images: ['homeassistant/amd64-addon-mosquitto:5.1']
21-03-07 04:26:33 INFO (SyncWorker_3) [supervisor.docker.addon] Starting Docker add-on homeassistant/amd64-addon-mosquitto with version 5.1.1
21-03-07 04:26:34 INFO (MainThread) [supervisor.services.modules.mqtt] Set core_mosquitto as service provider for mqtt
21-03-07 04:26:41 INFO (SyncWorker_5) [supervisor.docker.interface] Updating image hassioaddons/node-red-amd64:7.2.11 to ghcr.io/hassio-addons/node-red/amd64:8.1.2
21-03-07 04:26:41 INFO (SyncWorker_5) [supervisor.docker.interface] Downloading docker image ghcr.io/hassio-addons/node-red/amd64 with tag 8.1.2.
21-03-07 04:26:55 INFO (SyncWorker_5) [supervisor.docker.interface] Stopping addon_a0d7b954_nodered application
21-03-07 04:26:55 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API error: Received message 8:0 is not WSMsgType.TEXT
21-03-07 04:26:55 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API connection is closed
21-03-07 04:26:59 INFO (SyncWorker_5) [supervisor.docker.interface] Cleaning addon_a0d7b954_nodered application
21-03-07 04:26:59 INFO (MainThread) [supervisor.addons] Add-on 'a0d7b954_nodered' successfully updated
21-03-07 04:26:59 INFO (SyncWorker_1) [supervisor.docker.interface] Cleanup images: ['hassioaddons/node-red-amd64:7.2.11']
21-03-07 04:27:06 INFO (SyncWorker_2) [supervisor.docker.addon] Starting Docker add-on ghcr.io/hassio-addons/node-red/amd64 with version 8.1.2
21-03-07 04:27:13 INFO (SyncWorker_1) [supervisor.docker.interface] Updating image hassioaddons/vscode-amd64:2.4.0 to ghcr.io/hassio-addons/vscode/amd64:3.1.0
21-03-07 04:27:13 INFO (SyncWorker_1) [supervisor.docker.interface] Downloading docker image ghcr.io/hassio-addons/vscode/amd64 with tag 3.1.0.
21-03-07 04:27:18 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API request initialize
21-03-07 04:27:18 INFO (MainThread) [supervisor.api.proxy] WebSocket access from a0d7b954_nodered
21-03-07 04:27:18 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API request running
21-03-07 04:27:48 INFO (SyncWorker_1) [supervisor.docker.interface] Stopping addon_a0d7b954_vscode application
21-03-07 04:27:56 INFO (SyncWorker_1) [supervisor.docker.interface] Cleaning addon_a0d7b954_vscode application
21-03-07 04:27:56 INFO (MainThread) [supervisor.addons] Add-on 'a0d7b954_vscode' successfully updated
21-03-07 04:27:56 INFO (SyncWorker_0) [supervisor.docker.interface] Cleanup images: ['hassioaddons/vscode-amd64:2.4.0']
21-03-07 04:27:59 INFO (SyncWorker_4) [supervisor.docker.addon] Starting Docker add-on ghcr.io/hassio-addons/vscode/amd64 with version 3.1.0
21-03-07 04:28:42 INFO (SyncWorker_5) [supervisor.docker.interface] Updating image hassioaddons/zwave2mqtt-amd64:0.8.3 to ghcr.io/hassio-addons/zwave2mqtt/amd64:0.9.2
21-03-07 04:28:42 INFO (SyncWorker_5) [supervisor.docker.interface] Downloading docker image ghcr.io/hassio-addons/zwave2mqtt/amd64 with tag 0.9.2.
21-03-07 04:28:54 INFO (SyncWorker_5) [supervisor.docker.interface] Stopping addon_a0d7b954_zwave2mqtt application
21-03-07 04:28:58 INFO (SyncWorker_5) [supervisor.docker.interface] Cleaning addon_a0d7b954_zwave2mqtt application
21-03-07 04:28:58 INFO (MainThread) [supervisor.addons] Add-on 'a0d7b954_zwave2mqtt' successfully updated
21-03-07 04:28:58 INFO (SyncWorker_1) [supervisor.docker.interface] Cleanup images: ['hassioaddons/zwave2mqtt-amd64:0.8.3']
21-03-07 04:29:01 INFO (SyncWorker_5) [supervisor.docker.addon] Starting Docker add-on ghcr.io/hassio-addons/zwave2mqtt/amd64 with version 0.9.2
21-03-07 04:33:27 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API request initialize
21-03-07 04:33:27 INFO (MainThread) [supervisor.api.proxy] WebSocket access from a0d7b954_vscode
21-03-07 04:33:27 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API request running

hackerkatt · March 7, 2021, 5:01am

EDIT:

In addition to no Integrations showing, I also see the same error on EVERY Single Configuration option with the exception of Entities.

Now I can try and restore the back up again. But before I do that, I’d like to know a little more about what the heck is going on under the covers.

EDIT:
I seem to have some sqlite db corruption. Any notion what might have caused it? Is there any downside to wiping the events, history and tracking? Doing a search on the forum and Google I didn’t find a formal procedure but I found this procedure from @eddriesen.

sqlite3 ./home-assistant_v2.db_old ".dump" | sqlite3 ./home-assistant_v2.db_fix

ihttps://community.home-assistant.io/t/db-image-malformed-how-to-fix-it/76413/4

-rw-r--r--  1 root root  6.0M Mar  6 22:31 home-assistant_v2.db
-rw-r--r--  1 root root 1014M Mar  6 12:11 home-assistant_v2.db.corrupt.2021-03-06T19:12:43.066997+00:00
-rw-r--r--  1 root root   32K Mar  6 12:12 home-assistant_v2.db-shm.corrupt.2021-03-06T19:12:43.066997+00:00
-rw-r--r--  1 root root     0 Mar  6 12:12 home-assistant_v2.db-wal.corrupt.2021-03-06T19:12:43.066997+00:00

EDIT:

After futzing around with it last night w/o resolution, I refreshed my page HA GUI this morning and everything is showing and available again. Again, I’d like to know more about what occurred.