Dashboard crashed my hub

🛎️ Get Help
1

I woke up this morning to an unresponsive hub, no reply from the Web interface. I rebooted via the 8088 interface.

The logs indicate the last entry as the following sent from the dashboard app.

Any ideas?

332020-06-23 01:25:02.929 errororg.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement:
SELECT C.ID AS CAPID, C.NAME AS CAPNAME, A.ID AS ATTRID, A.NAME AS ATTRNAME, COM.ID AS COMID, COM.NAME AS COMNAME
FROM CAPABILITY C
JOIN DEVICE_TYPE_CAPABILITY_LINK DTCL ON DTCL.CAPABILITY_ID = C.ID
LEFT JOIN ATTRIBUTE A ON A.CAPABILITY_ID = C.ID
LEFT JOIN COMMAND COM ON COM.CAPABILITY_ID = C.ID
WHERE DTCL.DEVICE_TYPE_ID = ?
ORDER BY C.ID, A.ID, COM.ID [90108-197] on line 626 (dashboardDevices2)

2

Standard response in the community for a SQL error is: you have a corrupted DB. It got corrupted and then more, eventually the last thing running was Dashboard. 'Straw that broke..." so to speak.

You should try a safe reboot. Use the Diagnostic menu. When it comes back, take a backup and follow up with a Soft Reset, which is the safe way to reconstruct a corruption free DB.

You may not NEED the soft reset but it's not going to hurt anything.

1 Like
3

OK, thanks for the info