• Categories
    • Recent
    • Tags
    • Popular
    • Register
    • Login

    Database issue?

    Scheduled Pinned Locked Moved
    Troubleshooting
    2
    6
    2.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.
    • B
      benya
      last edited by

      I see the following errors in mycontroller.log and mycontroller process appears to be down:

      2017-03-31 22:17:47,223 INFO [main] [org.mycontroller.standalone.db.DataBaseUtils:116] Checking migration...
2017-03-31 22:17:47,999 ERROR [main] [org.mycontroller.standalone.db.DataBaseUtils:119] Migration exception, 
org.flywaydb.core.internal.dbsupport.FlywaySqlException: 
Unable to obtain Jdbc connection from DataSource (jdbc:h2:file:../conf/mycontroller;MVCC=TRUE) for user 'mycontroller': General error: "java.lang.ArrayIndexOutOfBoundsException: 2048" [50000-193]
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State  : HY000
Error Code : 50000
Message    : General error: "java.lang.ArrayIndexOutOfBoundsException: 2048" [50000-193]

	at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:396)
	at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:358)
	at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:51)
	at org.flywaydb.core.Flyway.execute(Flyway.java:1367)
	at org.flywaydb.core.Flyway.migrate(Flyway.java:930)
	at org.mycontroller.standalone.db.DataBaseUtils.runDatabaseMigration(DataBaseUtils.java:117)
	at org.mycontroller.standalone.StartApp.startServices(StartApp.java:251)
	at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:108)
	at org.mycontroller.standalone.StartApp.main(StartApp.java:95)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 2048" [50000-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.message.DbException.convert(DbException.java:295)
	at org.h2.engine.Database.openDatabase(Database.java:304)
	at org.h2.engine.Database.<init>(Database.java:267)
	at org.h2.engine.Engine.openSession(Engine.java:64)
	at org.h2.engine.Engine.openSession(Engine.java:176)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
	at org.h2.Driver.connect(Driver.java:69)
	at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:393)
	... 8 common frames omitted
Caused by: java.lang.ArrayIndexOutOfBoundsException: 2048
	at org.h2.store.Data.readInt(Data.java:160)
	at org.h2.index.PageDataNode.read(PageDataNode.java:105)
	at org.h2.index.PageDataNode.read(PageDataNode.java:84)
	at org.h2.store.PageStore.getPage(PageStore.java:799)
	at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:232)
	at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:85)
	at org.h2.table.RegularTable.<init>(RegularTable.java:83)
	at org.h2.store.PageStore.addMeta(PageStore.java:1696)
	at org.h2.store.PageStore.readMetaData(PageStore.java:1627)
	at org.h2.store.PageStore.recover(PageStore.java:1405)
	at org.h2.store.PageStore.openExisting(PageStore.java:367)
	at org.h2.store.PageStore.open(PageStore.java:288)
	at org.h2.engine.Database.getPageStore(Database.java:2482)
	at org.h2.engine.Database.open(Database.java:695)
	at org.h2.engine.Database.openDatabase(Database.java:273)
	... 19 common frames omitted
2017-03-31 22:17:48,095 ERROR [main] [org.mycontroller.standalone.db.DataBaseUtils:132] Unable to close flyway connection
org.flywaydb.core.internal.dbsupport.FlywaySqlException: 
Unable to obtain Jdbc connection from DataSource (jdbc:h2:file:../conf/mycontroller;MVCC=TRUE) for user 'mycontroller': General error: "java.lang.ArrayIndexOutOfBoundsException: 2048" [50000-193]
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State  : HY000
Error Code : 50000
Message    : General error: "java.lang.ArrayIndexOutOfBoundsException: 2048" [50000-193]

	at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:396)
	at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnection(DriverDataSource.java:358)
	at org.mycontroller.standalone.db.DataBaseUtils.runDatabaseMigration(DataBaseUtils.java:127)
	at org.mycontroller.standalone.StartApp.startServices(StartApp.java:251)
	at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:108)
	at org.mycontroller.standalone.StartApp.main(StartApp.java:95)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 2048" [50000-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.message.DbException.convert(DbException.java:295)
	at org.h2.engine.Database.openDatabase(Database.java:304)
	at org.h2.engine.Database.<init>(Database.java:267)
	at org.h2.engine.Engine.openSession(Engine.java:64)
	at org.h2.engine.Engine.openSession(Engine.java:176)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
	at org.h2.Driver.connect(Driver.java:69)
	at org.flywaydb.core.internal.util.jdbc.DriverDataSource.getConnectionFromDriver(DriverDataSource.java:393)
	... 5 common frames omitted
Caused by: java.lang.ArrayIndexOutOfBoundsException: 2048
	at org.h2.store.Data.readInt(Data.java:160)
	at org.h2.index.PageDataNode.read(PageDataNode.java:105)
	at org.h2.index.PageDataNode.read(PageDataNode.java:84)
	at org.h2.store.PageStore.getPage(PageStore.java:799)
	at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:232)
	at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:85)
	at org.h2.table.RegularTable.<init>(RegularTable.java:83)
	at org.h2.store.PageStore.addMeta(PageStore.java:1696)
	at org.h2.store.PageStore.readMetaData(PageStore.java:1627)
	at org.h2.store.PageStore.recover(PageStore.java:1405)
	at org.h2.store.PageStore.openExisting(PageStore.java:367)
	at org.h2.store.PageStore.open(PageStore.java:288)
	at org.h2.engine.Database.getPageStore(Database.java:2482)
	at org.h2.engine.Database.open(Database.java:695)
	at org.h2.engine.Database.openDatabase(Database.java:273)
	... 16 common frames omitted
2017-03-31 22:17:48,568 ERROR [main] [org.mycontroller.standalone.db.DaoUtils:198] Unable to load Dao,
org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 2048" [50000-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.message.DbException.convert(DbException.java:295)
	at org.h2.engine.Database.openDatabase(Database.java:304)
	at org.h2.engine.Database.<init>(Database.java:267)
	at org.h2.engine.Engine.openSession(Engine.java:64)
	at org.h2.engine.Engine.openSession(Engine.java:176)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
	at org.h2.Driver.connect(Driver.java:69)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at com.j256.ormlite.jdbc.JdbcConnectionSource.makeConnection(JdbcConnectionSource.java:266)
	at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadWriteConnection(JdbcPooledConnectionSource.java:140)
	at com.j256.ormlite.table.TableUtils.doCreateTable(TableUtils.java:397)
	at com.j256.ormlite.table.TableUtils.doCreateTable(TableUtils.java:383)
	at com.j256.ormlite.table.TableUtils.createTableIfNotExists(TableUtils.java:75)
	at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.<init>(BaseAbstractDaoImpl.java:65)
	at org.mycontroller.standalone.db.dao.ExternalServerDaoImpl.<init>(ExternalServerDaoImpl.java:38)
	at org.mycontroller.standalone.db.DaoUtils.loadAllDao(DaoUtils.java:157)
	at org.mycontroller.standalone.db.DataBaseUtils.runDatabaseMigration(DataBaseUtils.java:136)
	at org.mycontroller.standalone.StartApp.startServices(StartApp.java:251)
	at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:108)
	at org.mycontroller.standalone.StartApp.main(StartApp.java:95)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 2048
	at org.h2.store.Data.readInt(Data.java:160)
	at org.h2.index.PageDataNode.read(PageDataNode.java:105)
	at org.h2.index.PageDataNode.read(PageDataNode.java:84)
	at org.h2.store.PageStore.getPage(PageStore.java:799)
	at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:232)
	at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:85)
	at org.h2.table.RegularTable.<init>(RegularTable.java:83)
	at org.h2.store.PageStore.addMeta(PageStore.java:1696)
	at org.h2.store.PageStore.readMetaData(PageStore.java:1627)
	at org.h2.store.PageStore.recover(PageStore.java:1405)
	at org.h2.store.PageStore.openExisting(PageStore.java:367)
	at org.h2.store.PageStore.open(PageStore.java:288)
	at org.h2.engine.Database.getPageStore(Database.java:2482)
	at org.h2.engine.Database.open(Database.java:695)
	at org.h2.engine.Database.openDatabase(Database.java:273)
	... 24 common frames omitted
2017-03-31 22:17:49,136 ERROR [main] [org.mycontroller.standalone.StartApp:97] Unable to start application, refer error log,
java.lang.NullPointerException: null
	at org.mycontroller.standalone.settings.SettingsUtils.getValue(SettingsUtils.java:57)
	at org.mycontroller.standalone.settings.SettingsUtils.getValue(SettingsUtils.java:62)
	at org.mycontroller.standalone.settings.LocationSettings.getValue(LocationSettings.java:72)
	at org.mycontroller.standalone.settings.LocationSettings.get(LocationSettings.java:57)
	at org.mycontroller.standalone.AppProperties.loadPropertiesFromDb(AppProperties.java:520)
	at org.mycontroller.standalone.db.DataBaseUtils.runDatabaseMigration(DataBaseUtils.java:141)
	at org.mycontroller.standalone.StartApp.startServices(StartApp.java:251)
	at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:108)
	at org.mycontroller.standalone.StartApp.main(StartApp.java:95)
Exception in thread "MyController.org Shutdown-Hook" java.lang.NullPointerException
	at Acme.Serve.Serve.stopBackground(Serve.java:684)
	at org.jboss.resteasy.plugins.server.tjws.TJWSServletServer.stop(TJWSServletServer.java:184)
	at org.mycontroller.standalone.StartApp.stopHTTPWebServer(StartApp.java:222)
	at org.mycontroller.standalone.StartApp.stopServices(StartApp.java:303)
	at org.mycontroller.standalone.AppShutdownHook$1.run(AppShutdownHook.java:34)
      jkandasaJ 1 Reply Last reply Reply Quote 0
      • jkandasaJ
        jkandasa @benya
        last edited by

        @benya When it was happened? Do you try to upgrade from previous version?

        B 1 Reply Last reply Reply Quote 0
        • B
          benya @jkandasa
          last edited by

          @jkandasa I upgraded a while ago when you fixed another DB error.
          New error appeared with no particular reason.
          Should I restore DB from backup?

          jkandasaJ 1 Reply Last reply Reply Quote 0
          • jkandasaJ
            jkandasa @benya
            last edited by jkandasa

            @benya Yes, please try with backup. I do not get any clue now.

            B 1 Reply Last reply Reply Quote 0
            • B
              benya @jkandasa
              last edited by

              @jkandasa How could I wipe out database?

              jkandasaJ 1 Reply Last reply Reply Quote 0
              • jkandasaJ
                jkandasa @benya
                last edited by

                @benya

                • Remove old database
                • Start MyController
                • Restore your backup file
                • Start MyController
                1 Reply Last reply Reply Quote 0
                • First post
                  Last post

                1

                Online

                546

                Users

                524

                Topics

                3.4k

                Posts
                Copyright © 2015-2024 MyController.org | Contributors | Localization