Over the last 10-18 months, my Elevation hub performance has been getting worse and worse and on numerous occasions, the devices controlled by the hub fail to work with Amazon Alexa voice commands. Sometimes, they work with the Hubitat app and sometimes not. On 3 occasions now, the database has been corrupted which means that all the functionality of the hub devices fail. I have relocated the hub, relocated the z and USB switch controller but the problem is not resolved,
I regularly update the hub but as the hub is currently now working, I cannot provide any details.
On the previous occasions, a soft reset has been successful, but it takes time and effort which is frustrating.
That's a good question. And the answer is in your Logs (past Logs). If nothing obvious in the Logs explains why the hub is struggling (having lots or errors and/or warnings and/or unusual activity) then you may be dealing with a hardware malfunction. Also, what hub model do you have?
I have been in charge of many complex systems, and any software I have had written, always has a daily reset built in. You've answered my question I think, but is there a feature within the C-4 that allows a scheduled reset? Easily done from the power supply but I'm sure the unit doesn't like regular power supply resets.
That cleans up the corruption. When you do a backup (either the automatic or manually download) the database is cleaned up. Also given the age of your unit, remember that SD inside has a limited amount of writes, so one day in the future it may stop all together. Just something to think about.
Sadly, I suspect I would not replace it. Due to poor performance of z wave, in my personal experience, and Hubitat was the only thing I could find to control IP controlled, multiple relay boxes from KMTronic. Maybe time to look for an alternative controller for the multiple KMTronic units I have. IFTTT going commercial also put back my designs plans.
Personally I've never had any real problems with z-wave. (It's possible you have some ghosts and don't realize it. On the c4/c5 the only way to really tell is with a z-wave stick paired as a secondary controller). The c8 external antennas really helped a lot of people. In my own case I have have between 60 and 70 z-wave devices and all but 2 are now directly connected to the hub.... (the remaining 2 are a single hop). You can always try it for 30 days and see how you like it... Amazon has a very liberal return policy.
Confirming.
I had C-4, and if not reset periodically, then it was going (in my case) hung up, thankfully without memory/configs corruption. In your case, looks like that power failure(s) caused corruption(s).