Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Backup failed errors in log
-
I'm getting these errors in the log but when I look at the directory /opt/mango/backup I see a core database and an incremental backup for today so I'm not sure why I'm seeing these errors.
Backup Failed for File: /opt/mango/backup/core-database-H2-Nov-25-2019_072644 because StatementCallback; uncategorized SQLException for SQL [SCRIPT DROP TO '/opt/mango/backup/core-database-H2-Nov-25-2019_072644.zip' COMPRESSION ZIP; ]; SQL state [90031]; error code [90031]; IO Exception: "java.io.IOException: java.lang.ArrayIndexOutOfBoundsException"; "lob: null table: 90 id: 18396806"; SQL statement: SCRIPT DROP TO '/opt/mango/backup/core-database-H2-Nov-25-2019_072644.zip' COMPRESSION ZIP; [90031-199]; nested exception is org.h2.jdbc.JdbcSQLNonTransientException: IO Exception: "java.io.IOException: java.lang.ArrayIndexOutOfBoundsException"; "lob: null table: 90 id: 18396806"; SQL statement: SCRIPT DROP TO '/opt/mango/backup/core-database-H2-Nov-25-2019_072644.zip' COMPRESSION ZIP; [90031-199]
-
There is a bug in The H2 database that causes this. It has been mitigated in later versions of Mango. I would suggest you upgrade Mango. The other option is to restore Mango from a backup after starting on a fresh database, assuming your backups are complete. I would confirm that before deleting your existing database.
Basically the problem you are seeing is that some of the internal tables of your H2 database are corrupt.
-
Thanks for the update. I am running the latest version of Mango 3.6.6. and apply all system updates when they are released.
It does appear like the backups are working so I will try your suggestion of restoring a backup on a fresh database when appropriate.
