MangoES datasource's database error
I getting the follow error while opening one of the BACnet/IP datasource, may I know what it means of by "recovery tool", how and where to get this tool? this is from MangoES v3.7.11 which got a uptime for FOUR years.
Internal Server Error — org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLNonTransientConnectionException: File corrupted while reading record: "111243 of 110631". Possible solution: use the recovery tool; SQL statement: SELECT BLOCK, HASH FROM INFORMATION_SCHEMA.LOB_MAP D WHERE D.LOB = ? AND NOT EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.LOB_MAP O WHERE O.BLOCK = D.BLOCK AND O.LOB <> ?) [90030-199]
@derguang might be a corrupt h2 db.
Are you able to restore from an older h2 db?
See if you can replicate the issue on another instance using the backup.
I don't know of a recovery tool, but I do know there is an H2 db server in the mango bin folder.
This will allow you to connect to your h2 db and run the provided command, but it does mean your mango instance will need to be off before you can access it.
Afraid I'm not much more help than that.
Thanks for the reply.
May I know the h2 dbase do backup the event history also, as previously connected to a BASgatewayLX from Comtemporary controls where convert the modbus rtu to BACnet IP.
During the power shutdown service of the plant, the Mango OS pickup millions of comm loss alarm from the connected data points, after that the customer complaint that become sluggish. so i get into the h2 web interface, and delete the event history, The mango os perform well again, but some how I can't delete and connect the BACnet/IP datasource again. And I found this error in the log. Is there a way that I can force delete the datasource in ssh or h2 web interface.
@derguang your other option is setting events to 'do not log' this will prevent your system getting clogged up. Alternatively, given the steep drop in capability, you may need to upgrade your hardware. As four years is a pretty good run for an ES!
I'm not a huge fan of h2 once you're going above a thousand points. I change to MySQL so I have a dedicated database service handling the configs.
My only last resort of advice is raising a support ticket with radix to see if they are willing to provide some help to investigate the issue.
Thanks for your advice