Hello all, I'm newer to hubitat (about 4 months).
My hub seems frozen, where no devices respond to commands nor do they update if the devices are changed manually. I've tried googling and checking the docs for troubleshooting steps, and based on what I've found I've tried the following:
- restarting the hub
- restoring a database backup from 3 days ago, then restarting
- updating the hub to v2.2.7.126
- soft rebooting the hub, then restoring from the 3 day old backup
At some point in all the troubleshooting steps, I noticed this SQL error from one of my dashboards (app 5). I tried removing the dashboard, then again restarting but still everything is frozen.
app:5 2021-06-10 13:11:53.461 errorjava.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. Query: SELECT D.ID, D.VERSION, D.DEVICE_TYPE_ID, D.DEVICE_NETWORK_ID, D.LABEL, D.NAME, D.CONTROLLER_TYPE, D.ZIGBEE_ID, D.ENDPOINT_ID, D.PARENT_INSTALLED_APP_ID AS PARENT_APP_ID, D.PARENT_DEVICE_ID, D.IS_COMPONENT, DT.NAME AS DEVICE_TYPE_NAME, DT.TYPE AS DRIVER_TYPE, D.CREATE_TIME, D.UPDATE_TIME, D.LAST_ACTIVITY_TIME, D.DISABLED, D.LAN_ID, D.DISPLAY_AS_CHILD, D.DATA AS DATA_JSON, D.MESH_ENABLED, D.MESH_FULL_SYNC, D.collection_id AS room_id, IFNULL(NULLIF(D.MAX_EVENTS, 0), 100) AS MAX_EVENTS, IFNULL(NULLIF(D.MAX_STATES, 0), 30) AS MAX_STATES FROM DEVICE D JOIN DEVICE_TYPE DT ON DT.ID = D.DEVICE_TYPE_ID WHERE D.ID = ? Parameters: [1] on line 196 (getDevices)
app:5 2021-06-10 13:09:07.989 errorjava.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. Query: SELECT D.ID, D.VERSION, D.DEVICE_TYPE_ID, D.DEVICE_NETWORK_ID, D.LABEL, D.NAME, D.CONTROLLER_TYPE, D.ZIGBEE_ID, D.ENDPOINT_ID, D.PARENT_INSTALLED_APP_ID AS PARENT_APP_ID, D.PARENT_DEVICE_ID, D.IS_COMPONENT, DT.NAME AS DEVICE_TYPE_NAME, DT.TYPE AS DRIVER_TYPE, D.CREATE_TIME, D.UPDATE_TIME, D.LAST_ACTIVITY_TIME, D.DISABLED, D.LAN_ID, D.DISPLAY_AS_CHILD, D.DATA AS DATA_JSON, D.MESH_ENABLED, D.MESH_FULL_SYNC, D.collection_id AS room_id, IFNULL(NULLIF(D.MAX_EVENTS, 0), 100) AS MAX_EVENTS, IFNULL(NULLIF(D.MAX_STATES, 0), 30) AS MAX_STATES FROM DEVICE D JOIN DEVICE_TYPE DT ON DT.ID = D.DEVICE_TYPE_ID WHERE D.ID = ? Parameters: [1] on line 196 (getDevices)
Happy to provide more info if needed.
What am I missing? What other steps should I take?
Thanks!