Remedy for possibly corrupted database question

We had a momentary power outage yesterday. Despite using a battery backup, my Hubitat lost power and was powered off without a proper shutdown.

Some of the motion control and fan control rules do not seem to be working correctly.

Should I just wait and see if things clear up by tomorrow or start flailing now?

If my database is corrupted does a shutdown and power off with a restart have a chance of resolving the corruption?

If I backup the possibly corrupted database to the Hubitat cloud and reset the Hubitat and restore will that resolve the issue or do I have to backup from a "pre power outage" backup file?

Thanks for any comments or discussion!

With 2.2.8.x it appears that many times only a reboot is necessary; when that doesn’t work, downloading a backup followed by a soft reset and a restore from the downloaded backup seems to do the trick.

1 Like

If powered with a BBU, what caused the Hubitat to lose power? Was it too long an outage? This is easy to fix with a car battery or marine deep-cycle battery in place of the small "motorcycle-sized" battery included in most BBUs.

Another approach is to notice the loss of AC power (which means a battery-powered monitoring device), and run a countdown timer to an orderly shutdown of the Hubitat when enough time has gone by to imply a impending loss of battery power.

Pertinent question!

I did not go into detail about this part but since you asked ....

I have my Hubitat on a UPS so it should be able to tolerate reasonably brief power outages. This particular instance was about a one second outage associated with a lighting strike in the neighborhood not too far away.

I have the Hubitat plugged into a Tuya WiFi switch operated by the Tuya app and not Hubitat. I use it to power down Hubitat remotely when I'm trying to reset the Hubitat for all of the reasons discussed elsewhere.

Apparently, something in the outage current profile turned off the Tuya switch suddenly disconnecting the Hubitat from the UPS without a proper shutdown first.

Simple!