Recover From Possible Corrupt HUB?

⚙️ Custom Apps and Drivers Hubitat Package Manager
1

*** UPDATE 10/7/2025 ***

The latest update fixed everything. Adding driver code no longer gives errors and new devices are no longer creating ghost items.

*** UPDATE 10/2/2025 ***

Hubitat says this is a known issue and will be fixed in the next update.
(Current version is 2.4.3.127.)

*** ORIGINAL POST***
C8-Pro.
Platform 2.4.2.134.
Newly purchased Oct 2024.

I started having issues installing new drivers some months back. I tried many things including uninstalling and reinstalling the Package Manager. Removing newer drivers. Searching for updates and waiting to see if updates would fix it. It's not just one driver and included issues with existing drivers not updating in the package manager.

My worry, based on the errors I'm getting trying to manually install drivers (see below), is the HUB might have files or a database that didn't update correctly or became corrupted.

The package manager errors out with the following when installing new packages:
Error Occurred During Installation
An error occurred while installing the package: Failed to install driver...

If I try to install a driver manually I get the following message:
org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "ZW_DEVICE_CLASS" not found; SQL statement: INSERT INTO fingerprint (device_type_id, profile_id, endpoint_id, in_clusters, out_clusters, manufacturer, model, device_join_name, device_id, mfr, prod, controller_type, zw_device_class) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [42122-224]

Packages and drivers that were in place prior to this starting continue to function. I just can't add new ones or update some old ones. I have been able to use generic drivers for some devices instead.

Secondarily, maybe related, but maybe not:
I was trying to install a new Z-WAVE device yesterday (first in a long while) and it wouldn't initiate and the only log message I found was "Z-Wave Inclusion timed out, status:7". I also have some devices that stop functioning randomly over time until I do a HUB reboot. Some of these devices are Z-WAVE and some are ZIGBEE.

Anyone see the above driver installation issues before?

Any tools exist that validate a Hub's database and system files?

Are there good instruction for doing a backup, factory reset to reinstall all HUBITAT, and a restore so I don't have to start from scratch?

Any other thoughts or ideas?

2

Your DB seems corrupted. There's a Soft Reset process that usually fixes that. Have you done one?? You don't mention it.

Additionally, a reboot does NOT reset the radios, only a power cycle does.

1 Like
3

Click Reboot, then check Advanced, and rebuild database.

That will automatically backup, rebuild and reload the hub database to clear out any corruption. Its possible whatever you have going on goes deeper than that and it wont fix it, but that's the best place to start.

5 Likes
4

After you’re back up and running using instructions from @csteele and @jtp10181, consider getting a Hub Protect subscription. It will let you back up your hub, including both zwave and zigbee radios, to Hubitat’s cloud. And restore a hub using that cloud backup.

Local backups do not include radio data.

1 Like
5

Do you get a commission? :smiling_imp:

1 Like
6

Yes, and he has almost enough for a 1/3 cup of coffee after a couple years of promoting it :smiley: :smiley: :smiley:

3 Likes
7

To be fair, it is a cup of Irish coffee :joy::joy:

3 Likes
8

Thanks for the suggestions!

I tried each and the problem still exists.

Any possibility the restore just copies the old files back (instead of transferring data items one by one), as that might simply restore problem files?

Any other ideas? At this point I assume it will require rebuilding everything manually after a factory reset, which might take days.

9

The backup is not "files" it is a database of some sort. H2 format maybe? From what I understand the rebuild (or backup and restore) just cleans out any garbage. Sort of like if you run CHKDSK and it looks for garbage in the file system.

Is it possibly your hub is just overloaded and things are crashing? Have you check the system logs for errors or repeated warn messages?

You could submit a warranty claim Warranty – Hubitat Support
Maybe staff will have a better idea of what happened.

10

Still having this issue where I get errors when trying to install drivers.

org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "ZW_DEVICE_CLASS" not found;

Is there a way to get support from Hubitat? It seems like something is corrupt that does not get fixed during database rebuilds or a reset and restore.

11

Could try and ask gopher or one of the other guys to take a look at your internal logs and see if they can see anything. That sound like a corrupt database though.

1 Like
12

I just heard back from Hubitat staff. This is a known issue that has been reported multiple times and will be fixed in an upcoming update.

2 Likes
13

The latest update fixed everything. Adding driver code no longer gives errors and new devices are no longer creating ghost items.

1 Like