The power to my C-8 was accidentally disconnect and when booting up it is stuck on updating database. I have searched the community and followed steps using soft reset/switch version/restore backups but all attempts either end up stuck on updating database or corrupt database. My latest local backup is version 2.3.7.145 but I have tried switching back to 2.3.7.139 & 2.3.6.146 with the same result using older local backups. My first hub was a C-7 from 2019 and upgraded to a C-8 last summer and in all my years I have never had any issue that required any reset. My C-8 has an active Hub Protect and Remote Admin subscription but the cloud backup started failing last fall and due to my good luck of never needing to restore a backup I have been ignoring it and relying on local backups. I have been careful to not reset the radio side as I have many paired z-wave devices and rules defined and desperate to recover my setup from my latest if possible but I am out of things to try. Help!
So just to be clear....you used the Diagnostic Tool (hubIPaddress:8081) to do a soft reset and restored your most recent local backup, and the hub still got stuck or reported a corrupt database?
Yes, that is correct. Using the 8081 interface I performed a soft reset and then a local restore with my latest local backup resulting in the same stuck updating database state. I have a new C-8 pro coming today that I am hoping I can restore using my latest local backup that I have saved out in an attempt to at least recover my rules setup. I understand I will have to re-pair my devices since a local backup does not backup the radios. My last successful cloud backup was from last fall and many rules (30+) have been added since then. Does this restore strategy to a new hub have any chance of success on recovering my rules engine setup?
Yes, I believe it should. The devices won't work, since your Z-Wave and Zigbee radios won't be restored. But so the rules should be there.
I received my new C-8 Pro but unfortunately restoring by backups results in the same stuck %15 updating database state. That pretty much rules out any issue with the hub hardware and must be something in the database that is tripping up the startup process.
Would it be possible for me to upload my latest backup somewhere for support to try and troubleshoot the reason for stuck state? Rebuilding my 50+ automations from scratch is going to be a difficult task and is a very depressing thought.
Did you try other backups?
If you can get the C8 working with an older backup, you can then migrate to the C8-Pro with a free migration backup.
Here are my instructions for this issue:
Yes, I have tried all of my local backups. This is the result of performing a soft reset, uploading the local backup to the new C-8 Pro hub and then performing a restore on each backup.
Platform version: 2.3.7.145
2024-02-13~2.3.7.145~manual.lzf Initializing Hub: 15% - updating database
2024-01-13~2.3.7.139~manual.lzf Initializing Hub: 15% - updating database
2023-12-20~2.3.6.146~manual.lzf Initializing Hub: 15% - updating database
2023-12-11~2.3.5.152~manual.lzf Initializing Hub: 15% - updating database
2023-09-03~2.3.5.152~manual.lzf Works but so old basically starting over
Platform version: 2.3.8.128
2024-02-13~2.3.7.145~manual.lzf Corrupt database found
2024-01-13~2.3.7.139~manual.lzf Corrupt database found
2023-12-20~2.3.6.146~manual.lzf Corrupt database found
2023-12-11~2.3.5.152~manual.lzf Corrupt database found
2023-09-03~2.3.5.152~manual.lzf Works but so old basically starting over
I have also performed these same steps on my original C-8 hub switching the platform version backup to the version running at the time of the backup with same results.
This has really shaken my confident in local backups. If you read my previous posts my cloud backups started failing last Oct. Since then I have been performing manual backups never dreaming that they would be useless in the event of a failure. It appears whatever was causing the cloud backups to fail is probably what is causing the local backups restore to hang on startup or with corrupt database with the newer platform version.
I see I am not the only user to have this issue based on your previous threads. It seems it would be in the best interest of engineering to take a look at my backups to determine the root cause of this issue. I would be more than glad to pay for a case incident if that is an possibility to try and recover at least a list of my device names and rule automations settings and improve the reliability of backups. Otherwise how can I trust that building all of this will not result in possibility losing it again in the future? I love this platform but I feel I am in need of some help from engineering.
I know it does not help now but I think they did add improvements in this area in 2.3.8, it looks like you were still on 2.3.7 at the time of the issue. As you indicated it detected the corrupted backup at boot when you updated to 2.3.8
From 2.3.8.117 notes
Bug Fixes
- Added better detection for broken database backups.
The hub holds up to 5 internal backups. Have you tried restoring an older backup that's on the hub. It's a long shot, because your manual backups are bad going back to September of last year, but might be worth a try.
I sent you a private message to get more details about your hub. Please check the notifications in the upper right corner.
Is the issue still relevant? I have a similar problem. Did @bobbyD manage to help you? @bobbyD can you PM me please?
Please post more details on what you're doing/seeing exactly, and what troubleshooting steps you have tried so far.
I haven't been home for several months, and when I returned, I noticed there were new updates for the C-8. I also had an error message saying 'ZigBee Network is Offline.' So, I attempted to upgrade from 2.3.6.146 to 2.3.9.201, but after the update, I got stuck at 15% 'update database.'
I went into the diagnostic tool to roll back to version 2.3.6.146, but I still faced the same 15% issue. In the diagnostic tool, I performed a soft reset and cleared past logs. My C-8 starts up, but I only see a blank menu. I’ve tried restoring different backups (10 files) without success.
In summary, I seem to have two problems: the ZigBee issue and corrupted backups. In the meantime, I purchased a C-8 Pro, which should arrive this week. Since it’s winter and my heating system relies on ZigBee-controlled thermostats—and I’m not a fan of using them in manual mode—I need to set everything up again from scratch.
Without success how? What happens exactly?
Do you have hub protect with cloud backups or only local backups?
The Zigbee issue probably would have been solved by simply rebooting the hub.
Without success how? What happens exactly?
after uploading lzf the C8 reboot and stay stuck 15 update database
Do you have hub protect with cloud backups or only local backups? no cloud backups only local backup (10 files)
The Zigbee issue probably would have been solved by simply rebooting the hub.
in the past a try only reboot and the error stay, and zibee module stay offline. That why a try to update but, after update i use clean DB, zigbee stay offline.
no choice to restart from scratch when i receive C8 pro.
If you have not already I would download your backup files to a local PC for safe keeping.
The only other way I know to get it unstuck from the 15% initializing is a "Full Reset" from the diagnostic tool. This wipes the hub clean to factory settings. Unless @bobbyD has any other tricks?
Once that is done you should be able to restore one of your backups to get all your rules and zigbee devices back. You will have to pair the zigbee devices again but they will drop into place. If you had any Z-wave devices those will need a special procedure to get them back. It is more than just pairing them so DO NOT pair old z-wave devices after a full reset without further instructions.
Otherwise you could also just full reset and just start from a clean hub.
I wouldn't go that route trying to get the database unstuck. I would try older backups, first. It sounds like the one used is bad. While bad backups are rare, it could happen. Going further back could save valuable time by not resetting the radios, which means the user must repair everything.
Can you try an older backup? If that doesn't work, send me a private message along with your hub id and will see what we can do.
