• 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.
    • J
      Jay1089 @MattFox
      last edited by

      @mattfox Thanks for responding. I am very new to this Mango module. Could you please explain further , what you really mean by checking credentials. Also I don't have the original project and also the username password for this device to log in. I am kinda stuck. Is there any way to restore factory settings?

      Thanks again.

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

        Hi Jay1089,

        Do you have the NoSQL modules installed? In older versions (certainly that old!) if Mango did not shut down cleanly the NoSQL module runs the corruption scanner at 40% in startup, which can take a long time to run. How long did you let it run?

        Otherwise I would suggest,

        1. Use a newer version. Why wouldn't you be using 2.8 if you are using 2.x versions?
        2. Wait longer for it to finish the corruption scan, if applicable.
        3. Run Mango at the command line via /path/to/Mango/bin/ma.sh start to see if an error is making it to stderr
        J 1 Reply Last reply Reply Quote 0
        • J
          Jay1089 @phildunlap
          last edited by

          @phildunlap said in cannot load database:

          /path/to/Mango/bin/ma.sh start

          Is it applicable to MangoES hardware. Mango is not installed in my computer. I am accessing the small MangoES standalone device which acts as a SCADA

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

            RequestError: Unable to load /status/mango.json?time=1565839042939 status: 0

            this is the error popup in the browser when trying to access MangoES device. Hope it gives some idea

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

              I am more interested in restoring this device to Factory Default and create new works in it

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

                Ah, I overlooked that it was a MangoES so I provided an informative if inaccurate way of writing the correct path. On a MangoES it would be /opt/mango/bin/ma.sh start

                There is not the ability to restore the device to a factory default. You can start Mango fresh, though, by deleting or moving your Mango/databases/ which Mango isn't running.

                Since the upgrade tool on the modules page isn't present in 2.5, you may consider downloading the 2.8 core from https://store.infiniteautomation.com/core , placing the .zip file into the /opt/mango/ directory and then start Mango. It would start up without modules installed, but you could download those from the modules page.

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

                  FATAL 2019-08-22 20:28:41,277 (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-180]
                  at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
                  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
                  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:468)
                  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:478)
                  at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:488)
                  at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:494)
                  at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:507)
                  at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:215)
                  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:595)
                  at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:261)
                  at com.serotonin.m2m2.Main.main(Main.java:103)
                  Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-180]
                  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:2382)
                  at org.h2.engine.Database.open(Database.java:663)
                  at org.h2.engine.Database.openDatabase(Database.java:263)
                  at org.h2.engine.Database.<init>(Database.java:257)
                  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-22 20:28:41,317 (com.serotonin.m2m2.Main.main:108) - 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-180]
                  at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
                  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
                  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:468)
                  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:478)
                  at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:488)
                  at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:494)
                  at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:507)
                  at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:215)
                  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:595)
                  at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:261)
                  at com.serotonin.m2m2.Main.main(Main.java:103)
                  Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-180]
                  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:2382)
                  at org.h2.engine.Database.open(Database.java:663)
                  at org.h2.engine.Database.openDatabase(Database.java:263)
                  at org.h2.engine.Database.<init>(Database.java:257)
                  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

                  The above is the error details i get when i run the command you mentioned. Also i tried to delete the databse, It cant be deleted completely. What kind of recovery tool they have for correcting this error?

                  Any help is appreciated. Thanks

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

                    I tried 2.8 inside the Mango but it couldn't run. It is still running the old version.

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

                      /opt/mango/bin/ma.sh start
                      MA_HOME is /opt/mango
                      ma-start: MA started with Process ID: 28182
                      INFO 2019-08-22 23:28:07,482 (com.serotonin.m2m2.Main.main:82) - Starting Mango 2.8.8 with Schema Version: 13
                      WARN 2019-08-22 23:28:07,677 (com.serotonin.m2m2.Main.loadModules:356) - Module loggingConsole: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,679 (com.serotonin.m2m2.Main.loadModules:356) - Module openv4j: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,682 (com.serotonin.m2m2.Main.loadModules:356) - Module pointLinks: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,684 (com.serotonin.m2m2.Main.loadModules:356) - Module persistent: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,687 (com.serotonin.m2m2.Main.loadModules:356) - Module http: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,690 (com.serotonin.m2m2.Main.loadModules:356) - Module meta: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,692 (com.serotonin.m2m2.Main.loadModules:356) - Module templateConfig: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,693 (com.serotonin.m2m2.Main.loadModules:356) - Module virtualDS: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,694 (com.serotonin.m2m2.Main.loadModules:356) - Module onewire: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,696 (com.serotonin.m2m2.Main.loadModules:356) - Module scheduledEvents: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,697 (com.serotonin.m2m2.Main.loadModules:356) - Module dashboards: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,698 (com.serotonin.m2m2.Main.loadModules:356) - Module mangoNoSqlDatabase: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,700 (com.serotonin.m2m2.Main.loadModules:356) - Module scripting: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,701 (com.serotonin.m2m2.Main.loadModules:356) - Module sstTheme: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,703 (com.serotonin.m2m2.Main.loadModules:356) - Module twilio: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,712 (com.serotonin.m2m2.Main.loadModules:356) - Module log4JReset: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,714 (com.serotonin.m2m2.Main.loadModules:356) - Module mangoApi: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,715 (com.serotonin.m2m2.Main.loadModules:356) - Module mbus: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,716 (com.serotonin.m2m2.Main.loadModules:356) - Module jspViews: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,718 (com.serotonin.m2m2.Main.loadModules:356) - Module internal: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,719 (com.serotonin.m2m2.Main.loadModules:356) - Module jmxds: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,720 (com.serotonin.m2m2.Main.loadModules:356) - Module sqlds: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,723 (com.serotonin.m2m2.Main.loadModules:356) - Module pop3: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,724 (com.serotonin.m2m2.Main.loadModules:356) - Module sstGlobalScripts: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,726 (com.serotonin.m2m2.Main.loadModules:356) - Module bonjourBroadcaster: this module requires a core version of 2.4, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,728 (com.serotonin.m2m2.Main.loadModules:356) - Module modbus: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,729 (com.serotonin.m2m2.Main.loadModules:356) - Module serial: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,730 (com.serotonin.m2m2.Main.loadModules:356) - Module opcda: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,732 (com.serotonin.m2m2.Main.loadModules:356) - Module graphicalViews: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,733 (com.serotonin.m2m2.Main.loadModules:356) - Module dataFile: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,742 (com.serotonin.m2m2.Main.loadModules:356) - Module dglux: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,744 (com.serotonin.m2m2.Main.loadModules:356) - Module dataImport: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,745 (com.serotonin.m2m2.Main.loadModules:356) - Module sstGraphics: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,747 (com.serotonin.m2m2.Main.loadModules:356) - Module snmp: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,748 (com.serotonin.m2m2.Main.loadModules:356) - Module pid: this module requires a core version of 2.4, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,750 (com.serotonin.m2m2.Main.loadModules:356) - Module reports: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,751 (com.serotonin.m2m2.Main.loadModules:356) - Module maintenanceEvents: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,753 (com.serotonin.m2m2.Main.loadModules:356) - Module galil: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,754 (com.serotonin.m2m2.Main.loadModules:356) - Module watchlists: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,756 (com.serotonin.m2m2.Main.loadModules:356) - Module sqlConsole: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,757 (com.serotonin.m2m2.Main.loadModules:356) - Module log4jDS: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,758 (com.serotonin.m2m2.Main.loadModules:356) - Module controlcore: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,760 (com.serotonin.m2m2.Main.loadModules:356) - Module BACnet: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,761 (com.serotonin.m2m2.Main.loadModules:356) - Module vmstat: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,763 (com.serotonin.m2m2.Main.loadModules:356) - Module dnp3: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,764 (com.serotonin.m2m2.Main.loadModules:356) - Module pachube: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      WARN 2019-08-22 23:28:07,765 (com.serotonin.m2m2.Main.loadModules:356) - Module asciiFile: this module requires a core version of 2.5, which does not match the current core version of 2.8.8. Module not loaded.
                      INFO 2019-08-22 23:28:08,011 (com.serotonin.m2m2.Main.loadModules:416) - Loading module 'abpccc', v1.0.4 by Deltamation Software
                      INFO 2019-08-22 23:28:08,091 (com.serotonin.m2m2.Main.loadModules:416) - Loading module 'abeip', v1.0.6 by Deltamation Software
                      INFO 2019-08-22 23:28:08,103 (com.serotonin.m2m2.Main.loadModules:416) - Loading module 'SystemManager', v1.0.0 by (unknown vendor)
                      INFO 2019-08-22 23:28:08,110 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/SystemManager/web/dox/manifest.xml
                      INFO 2019-08-22 23:28:08,257 (com.serotonin.m2m2.Lifecycle.initialize:216) - Initializing Spring Object Mapper
                      ERROR 2019-08-22 23:28:09,218 (com.serotonin.m2m2.Main.main:119) - Error during initialization
                      java.lang.RuntimeException: java.net.BindException: Address already in use
                      at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:810)
                      at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:223)
                      at com.serotonin.m2m2.Main.main(Main.java:115)
                      Caused by: java.net.BindException: Address already in use
                      at sun.nio.ch.Net.bind0(Native Method)
                      at sun.nio.ch.Net.bind(Net.java:414)
                      at sun.nio.ch.Net.bind(Net.java:406)
                      at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:214)
                      at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
                      at org.eclipse.jetty.server.ServerConnector.open(ServerConnector.java:321)
                      at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:80)
                      at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:236)
                      at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
                      at org.eclipse.jetty.server.Server.doStart(Server.java:366)
                      at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
                      at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:807)
                      ... 2 more
                      INFO 2019-08-22 23:28:09,224 (com.serotonin.m2m2.Lifecycle.terminate:353) - Mango Lifecycle terminating...
                      ERROR 2019-08-22 23:28:09,238 (com.serotonin.m2m2.Lifecycle.terminate:425) - com.serotonin.provider.InputStreamEPollProvider
                      ERROR 2019-08-22 23:28:09,240 (com.serotonin.m2m2.Lifecycle.terminate:433) - com.serotonin.provider.ProcessEPollProvider
                      INFO 2019-08-22 23:28:09,240 (com.serotonin.m2m2.Lifecycle.terminate:453) - Mango Lifecycle terminated.
                      ma-start: no restart flag found, not restarting MA
                      ma-start: MA done

                      Updated to 2.8 version. but still can't open the Mango normally. its stuck in 40% loading

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

                        To the stack trace involving,

                        Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-180]

                        I would advise restoring a database backup. See this these resources for ways of doing that:
                        https://help.infiniteautomation.com/how-to-restore-a-h2-database-backup
                        https://forum.infiniteautomation.com/topic/2748/how-to-restore-a-database-backup

                        To the stack trace involving,

                        Caused by: java.net.BindException: Address already in use

                        This usually means that Mango is already running on that port, but it could also mean that another application is running and has bound that port. The solution if Mango is already running is to access the Mango that is running, and if another application has bound it you can change the port Mango binds to in the Mango/overrides/properties/env.properties file.

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

                          My help is for MangoES hardware. I think you are talking about Mango software running on a System

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

                            To add to the problems, I had installed a module MySQL Database server and now the MangoES refusing to connect through IP. any alternatives to retrirvr back the last change? i can ping, but no connection can be established through Webmin or through browser

                            1 Reply Last reply Reply Quote 0
                            • 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
                                            • First post
                                              Last post