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.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Navigation

    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular

    Backup failed errors in log

    User help
    2
    3
    371
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      mseverin last edited by

      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]

      1 Reply Last reply Reply Quote 0
      • terrypacker
        terrypacker last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • M
          mseverin last edited by

          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.

          1 Reply Last reply Reply Quote 0
          • First post
            Last post