500 Errors then a hard reset

[ajma]

Last night, I started to get 500 Errors from every screen in the Web UI and then I couldn't find anyway to reboot it besides power cycling. After doing that, it caused a full hard reset. Any idea what happened?

[rlithgow1]

Likely a corrupt database. Log in to yourhubip:8081 , go to settings>>backup and restore and restore last good known backup.

[ajma]

My daily backup logs show that it was running 2.2.7.128 and then it was version 137 around the same time as the hard reset

[rlithgow1]

Strange. I'd try the restore though. Once everything is back up you can go ahead and re update. I'd also download a copy to your pc before the restore as well

[ajma]

that's exactly the steps I just did. I'm back and running with version 128 but now it's not telling me there any updates available. i'll just keep my backups around in case 137 does push to my device again and breaks it.

[rlithgow1]

2.2.7.128 is the latest. Not sure why it would say 137

[ajma]

Oh wait. It was 2.2.6.137 My backup was pretty old.

[ajma]

You're probably right about the corrupt db. i'm seeing a lot of this in the logs:

[dev:712](http://192.168.1.3/logs#pastdev712)2021-07-05 11:18:42.178 pm [error](http://192.168.1.3/device/edit/712)java.lang.RuntimeException: java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread.

[rlithgow1]

Yeah, downloading and restoring the db actually cleans it. Have you had a lot of power issues lately or unplugged the hub without shutting it down first?

[sburke781]

Same 500 errors and logs happened to me, once on my C-7 and once on my C-4. Here's the thread from my experience.

Database Connections Error - Should I be worried?

I have seen these errors recently in my C-4 logs for various devices, however the devices continue to work after the logs appeared. Most recently I saw them between 3:30 - 4am this morning. I have seen in other Community posts people talk about this being a sign of a potential database corruption and to do a soft reset and db restore. I had to do this (db restore only) recently on my C-7 hub after seeing a 500 error in the Web UI. Connections could not be acquired from the underlying databas…

Tagging @bobbyD from support who was able to assist me with getting back up and running

[bobbyD]

@ajma

After doing that, it caused a full hard reset.

It likely auto performed a Soft Reset upon detecting that the database was corrupted. It should automatically restore the last backup but sometimes it doesn’t, so it leaves an empty database on the hub. If you are greeted with the “Get Started” screen, first, don’t panic. Secondly go to backup and restore and restore one of the local backups. If you have a new backup that you recently saved, you can restore that file instead. No hubs auto perform a Full Reset under any circumstances.

[ajma]

I did get the "Get Started" screen and when I looked for local backups. I might have checked too quickly because I didn't see any. I found a 3 month backup file on my laptop and loaded that, but upon checking again, I saw the daily backups in there so I recovered from one of those. I'm back up and running.