ZHA integration not loading after 2023.3.0b2 upgrade

[timiman]

The problem

After upgrading from 2023.3.0b1 to 2023.3.0b2 there is a constant message of "Home Assistant is starting, not everything will be available until it is finished." on UI, which possibly preventing ZHA integration to load. I've left it about 3h thinking it is an on-going db migration job or something but the message is still there.

What version of Home Assistant Core has the issue?

2023.3.0b2

What was the last working version of Home Assistant Core?

2023.3.0b1

What type of installation are you running?

Home Assistant OS

Integration causing the issue

ZHA, sqlite3

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:232
Integration: Recorder (documentation, issues)
First occurred: 11:07:38 am (1 occurrences)
Last logged: 11:07:38 am

The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly

Additional information

Is there a way to find which task is taken so long or have been stuck ? The other logs seem clear ( Supervisor, Host ). If it is a database issue is there a way to repair it, because I cannot find any command through Terminal or on VM Box window.

Also, if I try to add a new ZHA integration, the pop-up modal get stuck at "Please wait, starting configuration wizard for Zigbee Home Automation".

[timiman]

Also the Log Book is empty, the Automations are gone and no history data can be shown on UI at all. Possibly a Recorder issue ?

[Basher92]

I can observe exactly the same behavior after upgrading. Same behavior same log. Probably fixed with PR88751? Sounds like it could be the reason behind this bug.

[timiman]

I hope #88751 will cure this issue. I also hope that the state HA is in now will not prevent the upgrade task to be performed !

Also, when trying to restart from the new UI dialog, I get a "The system cannot restart while a database upgrade is in progress." message, thus pointing that something bad is going on DB wise.

[bekovan]

I can observe exactly the same behavior after upgrading. Same behavior same log.

[timiman]

2023.3.0b3 has been released including #88751. Shortly will be available.

[timiman]

What I was afraid of happened. The stuck task does not allow the update process to begin. Any other ways to update to 2023.3.0b3 ?

[bekovan]

@timiman you where just beating me with some minutes, same issue & same question here

[timiman]

Using "ha core update --version 2023.3.0b3 --backup" wont initiate the update

[Basher92]

that's what I was afraid off. Restore and downgrade didn't work for me either... EDIT: Worked for me now

[Denis19xx]

that's what I was afraid off. Restore and downgrade didn't work for me either... EDIT: Worked for me now

Didn´t work for me because: 23-02-25 14:46:20 ERROR (MainThread) [supervisor.utils] Can't execute update while a task is in progress

[bekovan]

did the task timed out or did you force this ?

[Denis19xx]

The task has been running for several hours. Then I restarted the host, unfortunately the same problem.

[Basher92]

I disabled ZHA, waited for around 30min. till it really showed being disabled. Restarted my HA machine, and the update showed up and I immediately pressed install. That worked for me

[Denis19xx]

I also deactivated ZHA in the integrations section but the start still doesn't go through completely. Do I need to disable ZHA somewhere else?

[timiman]

I've recovered using a 7-days old backup of the VM. In my case nothing else helped

[Denis19xx]

I got it! In my case, disabling Zha AND removing the SkyConnect Stick helped. Then restart the system, update to 0b3, reboot and activate everything again + connect the stick.

[bekovan]

Reformat SSD + restore from manual backup update to 2023.3.0b1 did the job for me, kind of brute force solution

[dmulcahey]

Upgrade to b3

[Waghead]

Same problem. but i dont seem to be able to restore backup or run update 😔

[meremortals70]

Upgrade to b3

If only it was that easy. Dave

[meremortals70]

I got it! In my case, disabling Zha AND removing the SkyConnect Stick helped. Then restart the system, update to 0b3, reboot and activate everything again + connect the stick.

Didn’t work for me unfortunately

[juhanjuku]

I have tried update from 2023.2.5 to 2023.3.0 and 2023.3.1 but ZHA refuses to start. I even tried to migrate from Nortek HUSBZB-1 to SkyConnect but still same result - ZHA failed to start. Fortunately I can downgrade to 2023.2.5 where all works.

[TheJulianJES]

That's very likely a completely different issue. Post more logs here (or better yet: create a new issue). And make sure you're not using any broken/outdated custom quirks.

[juhanjuku]

Thanks', it was quirk. When I commented out custom quirks, ZHA starts normally.

[issue-triage-workflows[bot]]

There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates. Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.