System database crashed

🛎️ Get Help Devices
1

All my devices locked up and required a Hub power drop and reboot. it got even stranger that after init, it rebooted itself again. Below is where the database locked up. Anyone have any ideas?

sys:12021-05-31 09:07:01.503 am Firmware update for [:] failed.

sys:12021-05-31 09:07:01.467 am Firmware update for [:] failed.

dev:22332021-05-31 09:06:59.017 am errorjava.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database! on line 1303 (parse)

dev:32022021-05-31 09:05:43.197 am warnDescription map not parsed: [raw:AFEB01000108210020C8, dni:AFEB, endpoint:01, cluster:0001, size:08, attrId:0021, encoding:20, command:0A, value:C8, clusterInt:1, attrInt:33]

dev:2472021-05-31 09:04:55.142 am errorjava.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database! (parse)

dev:1162021-05-31 09:04:55.136 am errorjava.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database! (parse)

dev:22332021-05-31 09:04:55.038 am errorjava.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database! (parse)

dev:2472021-05-31 09:04:55.022 am errorjava.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database! (parse)

dev:22352021-05-31 09:04:24.908 am errororg.codehaus.groovy.runtime.InvokerInvocationException: org.quartz.JobPersistenceException: Couldn't obtain job names: The database has been closed [90098-197] [See nested exception: org.h2.jdbc.JdbcSQLException: The database has been closed [90098-197]] on line 1387 (active)

2

I'm not sure about your particular issue, but the standard approach to fixing database (corruption) issues is to do a soft reset.
The first step of a soft reset is to do a db backup.

1 Like
3

System was locked up solid, soft reset was not possible

4

Could you still have something in your browser cache? Can you reboot and get to hub ip:8081?

5

Tried 2 computers plus my ipad, no response before i dropped power to it

6

If there is no way of rebooting and getting to :8081, I'm going to call in the cavalry.
Tagging @bobbyD (Hubitat Support)

1 Like
7

Check the IP also, it might have grabbed a new one.

8

Hi there, I checked your hub and it appears to be online and connected to the cloud. Last known IP address was: 192.168.1.239. Please check to make sure that is the address you are using.

9

That is the address, it has been responsive and operating correctly since it rebooted itself the second time after the power drop. There was nothing going on that was out of the ordinary when I received a strange notification saying "Hub is at 2.44 at 10:12am" After the reboot, i was unable to find the cause of the notification

10