• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 Mango 5 Documentation Website

    cannot load database

    MangoES Hardware
    3
    39
    8.6k
    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.
    • MattFoxM
      MattFox
      last edited by

      Do you have a copy of your env.properties on hand?
      If so can you please paste it between some code tags???
      Follow Phil's instructions as above, also run mango from the bash console.

      Secondly Phil also added that you may have an instance of mango already running in the background.

      try

      pas aux | grep mango > mangoinstances.txt

      Something should be outputted into that file to show something is running.

      I also suggest you stop making amendments and changes to your system, it's harder to follow and diagnose if you do that.

      Fox

      Do not follow where the path may lead; go instead where there is no path.
      And leave a trail - Muriel Strode

      1 Reply Last reply Reply Quote 0
      • J
        Jay1089
        last edited by Jay1089

        Thanks Fox for responding. But now I don't have any access to the MangoES. As I said before i can ping, but can't use Webmin to get into MangoES hardware. Any alternatives to access webmin again?

        Connection refused through Network

        1 Reply Last reply Reply Quote 0
        • MattFoxM
          MattFox
          last edited by

          You mean you're unable to use putty and SSH into the unit?

          Just because webmin is out, SSH should still be running...

          Do not follow where the path may lead; go instead where there is no path.
          And leave a trail - Muriel Strode

          1 Reply Last reply Reply Quote 0
          • J
            Jay1089
            last edited by

            Yes even putty cant get in. Connection refused

            1 Reply Last reply Reply Quote 0
            • MattFoxM
              MattFox
              last edited by

              Assuming you're running a windows box, let's see if it's even on the network.
              Get yourself angry ip scanner or similar to scan the network.
              If there's nothing, I wonder if your network card gave up the ghost...

              Do not follow where the path may lead; go instead where there is no path.
              And leave a trail - Muriel Strode

              1 Reply Last reply Reply Quote 0
              • J
                Jay1089
                last edited by

                I have the advanced IP scanner, and the MangoES is available. Only it refuses to accept any connection. Also before i could access the network foler of Mango, But now its invisible and there is nothing showing up in the network.

                1 Reply Last reply Reply Quote 0
                • MattFoxM
                  MattFox
                  last edited by

                  Sounds like a power cycle is in order. Give it a good ol' hard reset. It's an old unit so I wouldn't rule out hardware failing. I've had a few V2's die on me, and one of the traits they shared before dying completely was the networking part of the system calling it a day.

                  Do not follow where the path may lead; go instead where there is no path.
                  And leave a trail - Muriel Strode

                  1 Reply Last reply Reply Quote 0
                  • J
                    Jay1089
                    last edited by

                    Just switching off the power for long time and switch it back on?

                    MattFoxM 1 Reply Last reply Reply Quote 0
                    • MattFoxM
                      MattFox @Jay1089
                      last edited by

                      @jay1089 Yep, count to 30 then fire it back up, perhaps monitor the LED's on the case - I assume here it's similar to a V2 with an aluminium cast case with 4 LEDs on the front.

                      Do not follow where the path may lead; go instead where there is no path.
                      And leave a trail - Muriel Strode

                      1 Reply Last reply Reply Quote 1
                      • J
                        Jay1089
                        last edited by

                        Yes four LED up front. One green and other blinks when network connected. Other two doesn't lit up at all

                        1 Reply Last reply Reply Quote 0
                        • MattFoxM
                          MattFox
                          last edited by MattFox

                          Good, the blinking is the heartbeat for Mango, it should be starting then. Check your network again and let's see if the SSH is available.
                          https://help.infiniteautomation.com/mangoes-connections?rq=v2

                          Do not follow where the path may lead; go instead where there is no path.
                          And leave a trail - Muriel Strode

                          1 Reply Last reply Reply Quote 1
                          • J
                            Jay1089
                            last edited by

                            Connection refused still after power cycle. In the LAN connection, The green LEd blinks whereas the orange stays lit all the time.

                            1 Reply Last reply Reply Quote 0
                            • MattFoxM
                              MattFox
                              last edited by MattFox

                              Sounds like something is causing an issue or error of some sort, I thought you meant 2 of the four leds, not the lan socket. .
                              Phil are the display ports on these old boards functioning? I know I had one on the old board, but never had a chance to check myself. It's just a last ditch idea I had.
                              Sorry that's all I've got...

                              Do not follow where the path may lead; go instead where there is no path.
                              And leave a trail - Muriel Strode

                              1 Reply Last reply Reply Quote 1
                              • J
                                Jay1089
                                last edited by

                                Display port works. But the problem is it cant complete the boot. It is booting for so long

                                1 Reply Last reply Reply Quote 0
                                • J
                                  Jay1089
                                  last edited by

                                  Somehow managed to revert back. Now webmin is working and back to the old issue. Database stuck at 40%. And in command shell, i cant execute bin/ma.sh start. it says permission denied.

                                  1 Reply Last reply Reply Quote 0
                                  • MattFoxM
                                    MattFox
                                    last edited by

                                    Nice!
                                    try

                                    sudo /opt/mango/bin/ma.sh start

                                    Let's see what you get!

                                    Do not follow where the path may lead; go instead where there is no path.
                                    And leave a trail - Muriel Strode

                                    1 Reply Last reply Reply Quote 1
                                    • J
                                      Jay1089
                                      last edited by

                                      sudo /opt/mango/bin/ma.sh start
                                      MA_HOME is /opt/mango
                                      /opt/mango/bin/ma-init.sh: line 29: unexpected EOF while looking for matching `"'
                                      /opt/mango/bin/ma-init.sh: line 34: syntax error: unexpected end of file
                                      /opt/mango/bin/ma.sh: line 28: /opt/mango/bin/ma-start.sh: Permission denied

                                      1 Reply Last reply Reply Quote 0
                                      • J
                                        Jay1089
                                        last edited by

                                        INFO 2019-08-26 18:07:08,020 (com.serotonin.m2m2.Lifecycle.loadLic:411) - Checking license...
                                        INFO 2019-08-26 18:07:08,479 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:42) - Initializing H2 connection manager
                                        FATAL 2019-08-26 18:07:10,603 (com.serotonin.m2m2.db.DatabaseProxy.initialize:173) - Unable to connect to database of type H2
                                        org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-181]
                                        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
                                        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:630)
                                        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
                                        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
                                        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
                                        at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39)
                                        at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63)
                                        at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:244)
                                        at com.serotonin.m2m2.db.DatabaseProxy.newDatabaseCheck(DatabaseProxy.java:187)
                                        at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:103)
                                        at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:542)
                                        at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:246)
                                        at com.serotonin.m2m2.Main.main(Main.java:104)
                                        Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-181]
                                        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
                                        at org.h2.message.DbException.get(DbException.java:179)
                                        at org.h2.message.DbException.get(DbException.java:155)
                                        at org.h2.store.PageStore.getPage(PageStore.java:813)
                                        at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:233)
                                        at org.h2.index.PageDataNode.freeRecursive(PageDataNode.java:272)
                                        at org.h2.index.PageDataNode.freeRecursive(PageDataNode.java:272)
                                        at org.h2.index.PageDataIndex.removeAllRows(PageDataIndex.java:397)
                                        at org.h2.index.PageDataIndex.truncate(PageDataIndex.java:382)
                                        at org.h2.store.PageStore.removeOldTempIndexes(PageStore.java:397)
                                        at org.h2.store.PageStore.openExisting(PageStore.java:373)
                                        at org.h2.store.PageStore.open(PageStore.java:288)
                                        at org.h2.engine.Database.getPageStore(Database.java:2386)
                                        at org.h2.engine.Database.open(Database.java:666)
                                        at org.h2.engine.Database.openDatabase(Database.java:266)
                                        at org.h2.engine.Database.<init>(Database.java:260)
                                        at org.h2.engine.Engine.openSession(Engine.java:60)
                                        at org.h2.engine.Engine.openSession(Engine.java:167)
                                        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
                                        at org.h2.engine.Engine.createSession(Engine.java:128)
                                        at org.h2.engine.Engine.createSession(Engine.java:26)
                                        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
                                        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
                                        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
                                        at org.h2.Driver.connect(Driver.java:72)
                                        at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190)
                                        at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:353)
                                        at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:385)
                                        at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:227)
                                        at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199)
                                        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
                                        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
                                        ... 12 more
                                        ERROR 2019-08-26 18:07:10,650 (com.serotonin.m2m2.Main.main:109) - Error during initialization
                                        org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-181]
                                        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
                                        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:630)
                                        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
                                        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
                                        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
                                        at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39)
                                        at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63)
                                        at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:244)
                                        at com.serotonin.m2m2.db.DatabaseProxy.newDatabaseCheck(DatabaseProxy.java:187)
                                        at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:103)
                                        at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:542)
                                        at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:246)
                                        at com.serotonin.m2m2.Main.main(Main.java:104)
                                        Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-181]
                                        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
                                        at org.h2.message.DbException.get(DbException.java:179)
                                        at org.h2.message.DbException.get(DbException.java:155)
                                        at org.h2.store.PageStore.getPage(PageStore.java:813)
                                        at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:233)
                                        at org.h2.index.PageDataNode.freeRecursive(PageDataNode.java:272)
                                        at org.h2.index.PageDataNode.freeRecursive(PageDataNode.java:272)
                                        at org.h2.index.PageDataIndex.removeAllRows(PageDataIndex.java:397)
                                        at org.h2.index.PageDataIndex.truncate(PageDataIndex.java:382)
                                        at org.h2.store.PageStore.removeOldTempIndexes(PageStore.java:397)
                                        at org.h2.store.PageStore.openExisting(PageStore.java:373)
                                        at org.h2.store.PageStore.open(PageStore.java:288)
                                        at org.h2.engine.Database.getPageStore(Database.java:2386)
                                        at org.h2.engine.Database.open(Database.java:666)
                                        at org.h2.engine.Database.openDatabase(Database.java:266)
                                        at org.h2.engine.Database.<init>(Database.java:260)
                                        at org.h2.engine.Engine.openSession(Engine.java:60)
                                        at org.h2.engine.Engine.openSession(Engine.java:167)
                                        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
                                        at org.h2.engine.Engine.createSession(Engine.java:128)
                                        at org.h2.engine.Engine.createSession(Engine.java:26)
                                        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
                                        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
                                        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
                                        at org.h2.Driver.connect(Driver.java:72)
                                        at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190)
                                        at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:353)
                                        at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:385)
                                        at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:227)
                                        at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199)
                                        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
                                        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
                                        ... 12 more
                                        /opt/mango/bin/ma-start.sh: line 83: /opt/mango/bin/ext-enabled/*.sh: No such file or directory

                                        1 Reply Last reply Reply Quote 0
                                        • phildunlapP
                                          phildunlap
                                          last edited by

                                          That still looks like the H2 database is corrupt and needs to be restored from a backup, as I linked in my first response.

                                          I'm not sure why you'd have problems executing the shell scripts. Probably part of that has to do with running Mango 2.5 instead of at least 2.8, as i already mentioned. You can download the 2.8 core from https://store.infiniteautomation.com/core

                                          You could still try moving your Mango/databases/ directory while Mango is not running, so that it starts on a new database. That would also get past the corruption in the H2 database.

                                          1 Reply Last reply Reply Quote 0
                                          • J
                                            Jay1089
                                            last edited by

                                            Finally deleted the old databse. what is the default user id password for login?

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