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

RuntimeManager initialization failure


  • [page 1]

    Hello,

    I have a system running Mango that was working until last week when it suddenly stopped. I have been told the only thing that happened when it stopped working is someone copying the database files. Now it hangs on start-up and I can't find a way around this. I got the following log file from my last attempt to start.

    INFO  2018-08-08T16:13:14,677 (com.serotonin.m2m2.Main.main:97) - Starting Mango 3.4.4 with Schema Version: 25 
    INFO  2018-08-08T16:13:18,379 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'advancedScheduler', v3.4.2 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,479 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'asciiFile', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,503 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'BACnet', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,555 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'controlcore', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,611 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'dashboardDesigner', v3.4.2 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,627 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: C:\free-m2m2-core-3.4.4\web\modules\dashboardDesigner\web\dox\manifest.xml 
    INFO  2018-08-08T16:13:18,651 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'dataFile', v3.4.1 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,739 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'dataImport', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,755 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'deviceConfig', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,763 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: C:\free-m2m2-core-3.4.4\web\modules\deviceConfig\web\dox\manifest.xml 
    INFO  2018-08-08T16:13:18,791 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'dnp3', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,807 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'egauge', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,823 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'envcands', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,838 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'excelReports', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:18,898 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'graphicalViews', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,469 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'Haystack', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,489 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'http', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,529 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'jsonFileImport', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,549 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'log4jDS', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,613 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'log4JReset', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,617 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'loggingConsole', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,777 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'maintenanceEvents', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,813 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'mangoApi', v3.4.3 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,829 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'mangoUI', v3.4.5 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:19,857 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: C:\free-m2m2-core-3.4.4\web\modules\mangoUI\web\dox\manifest.xml 
    INFO  2018-08-08T16:13:19,981 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'mbus', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,025 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'meta', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,076 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'modbus', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,124 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'onewire', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,156 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'opcda', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,172 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'pakbus', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,216 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'pointLinks', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,268 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'pop3', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,292 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'reports', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,352 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'scheduledEvents', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,408 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'scripting', v3.4.1 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,424 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'serial', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,440 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'snmp', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,520 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'sqlConsole', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,536 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'sqlds', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,560 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'ssh', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,576 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'sstGlobalScripts', v3.4.1 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,600 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'sstGraphics', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,739 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'TCPIP', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,827 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'templateConfig', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,859 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'twilio', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,883 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'virtualDS', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,915 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'vmstat', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:20,939 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'watchlists', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:21,175 (com.serotonin.m2m2.Main.loadModules:581) - Loading module 'internal', v3.4.0 by Infinite Automation Systems Inc. 
    INFO  2018-08-08T16:13:32,364 (com.serotonin.m2m2.Lifecycle.initialize:223) - Initializing Spring Object Mapper 
    INFO  2018-08-08T16:13:36,134 (com.serotonin.m2m2.Lifecycle.loadLic:529) - Checking license... 
    INFO  2018-08-08T16:13:36,134 (com.serotonin.m2m2.Lifecycle.loadLic:615) - License file not found 
    INFO  2018-08-08T16:13:36,828 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:42) - Initializing H2 connection manager 
    INFO  2018-08-08T16:13:42,344 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:38) - Starting instance with core version 3.4.4, db 25 
    ERROR 2018-08-08T16:13:43,660 (com.serotonin.m2m2.Lifecycle.runtimeManagerInitialize:733) - RuntimeManager initialization failure 
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT id, xid, name, dataSourceType, data, editPermission FROM dataSources ]; SQL state [HY000]; error code [50000]; General error: "java.lang.RuntimeException: rowCount expected 7271 got 7333 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]; nested exception is org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 7271 got 7333 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]
    	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:478) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at com.serotonin.db.DaoUtils.query(DaoUtils.java:376) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.db.dao.DataSourceDao.getDataSources(DataSourceDao.java:69) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize(RuntimeManagerImpl.java:118) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.Lifecycle.runtimeManagerInitialize(Lifecycle.java:730) [ma-priv-3.4.4.jar:?]
    	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:337) [ma-priv-3.4.4.jar:?]
    	at com.serotonin.m2m2.Main.main(Main.java:134) [ma-priv-3.4.4.jar:?]
    Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 7271 got 7333 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.message.DbException.get(DbException.java:168) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.message.DbException.convert(DbException.java:295) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.table.RegularTable.addRow(RegularTable.java:137) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.addRow(Insert.java:198) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.insertRows(Insert.java:172) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.update(Insert.java:114) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.CommandContainer.update(CommandContainer.java:101) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.Command.executeUpdate(Command.java:260) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:164) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:150) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.store.LobStorageBackend.copyLob(LobStorageBackend.java:468) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.value.ValueLobDb.copyToResult(ValueLobDb.java:488) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.value.ValueLobDb.copyToResult(ValueLobDb.java:38) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.result.LocalResult.cloneLobs(LocalResult.java:273) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.result.LocalResult.addRow(LocalResult.java:298) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Select.queryFlat(Select.java:523) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.query(Query.java:371) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.query(Query.java:333) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.CommandContainer.query(CommandContainer.java:113) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.Command.executeQuery(Command.java:201) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:80) ~[h2-1.4.196.jar:1.4.196]
    	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	... 7 more
    Caused by: java.lang.RuntimeException: rowCount expected 7271 got 7333 LOB_MAP.INDEX_LOB_MAP_DATA_LOB
    	at org.h2.message.DbException.throwInternalError(DbException.java:242) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.table.RegularTable.checkRowCount(RegularTable.java:169) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.table.RegularTable.addRow(RegularTable.java:120) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.addRow(Insert.java:198) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.insertRows(Insert.java:172) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.update(Insert.java:114) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.CommandContainer.update(CommandContainer.java:101) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.Command.executeUpdate(Command.java:260) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:164) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:150) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.store.LobStorageBackend.copyLob(LobStorageBackend.java:468) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.value.ValueLobDb.copyToResult(ValueLobDb.java:488) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.value.ValueLobDb.copyToResult(ValueLobDb.java:38) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.result.LocalResult.cloneLobs(LocalResult.java:273) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.result.LocalResult.addRow(LocalResult.java:298) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Select.queryFlat(Select.java:523) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.query(Query.java:371) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.query(Query.java:333) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.CommandContainer.query(CommandContainer.java:113) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.Command.executeQuery(Command.java:201) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:80) ~[h2-1.4.196.jar:1.4.196]
    	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	... 7 more
    INFO  2018-08-08T16:13:48,239 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:32) - Mango Automation context starting 
    INFO  2018-08-08T16:13:48,240 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:40) - Mango Automation context started 
    ERROR 2018-08-08T16:13:52,962 (org.springframework.web.context.ContextLoader.initWebApplicationContext:350) - Context initialization failed 
    org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'mangoSecurityConfiguration': Unsatisfied dependency expressed through method 'configureAuthenticationManager' parameter 3; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'mangoTokenAuthenticationProvider' defined in URL [jar:file:/C:/free-m2m2-core-3.4.4/lib/mango-3.4.4.jar!/com/serotonin/m2m2/web/mvc/spring/security/authentication/MangoTokenAuthenticationProvider.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tokenAuthenticationService' defined in URL [jar:file:/C:/free-m2m2-core-3.4.4/lib/mango-3.4.4.jar!/com/serotonin/m2m2/web/mvc/spring/components/TokenAuthenticationService.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService]: Constructor threw exception; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select settingValue from systemSettings where settingName=?]; SQL state [HY000]; error code [50000]; General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]; nested exception is org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]
    	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:667) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1272) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) ~[spring-context-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) ~[spring-context-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443) ~[spring-web-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325) [spring-web-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    

  • [page 2]

    	at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:843) [jetty-server-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:533) [jetty-servlet-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:816) [jetty-server-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:345) [jetty-servlet-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1406) [jetty-webapp-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1368) [jetty-webapp-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:778) [jetty-server-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:262) [jetty-servlet-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:522) [jetty-webapp-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) [jetty-util-9.3.23.v20180228.jar:9.3.23.v20180228]
    	at com.serotonin.m2m2.Lifecycle.fullyInitializeWebContext(Lifecycle.java:1084) [ma-priv-3.4.4.jar:?]
    	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:346) [ma-priv-3.4.4.jar:?]
    	at com.serotonin.m2m2.Main.main(Main.java:134) [ma-priv-3.4.4.jar:?]
    Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'mangoTokenAuthenticationProvider' defined in URL [jar:file:/C:/free-m2m2-core-3.4.4/lib/mango-3.4.4.jar!/com/serotonin/m2m2/web/mvc/spring/security/authentication/MangoTokenAuthenticationProvider.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tokenAuthenticationService' defined in URL [jar:file:/C:/free-m2m2-core-3.4.4/lib/mango-3.4.4.jar!/com/serotonin/m2m2/web/mvc/spring/components/TokenAuthenticationService.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService]: Constructor threw exception; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select settingValue from systemSettings where settingName=?]; SQL state [HY000]; error code [50000]; General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]; nested exception is org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]
    	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	... 28 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tokenAuthenticationService' defined in URL [jar:file:/C:/free-m2m2-core-3.4.4/lib/mango-3.4.4.jar!/com/serotonin/m2m2/web/mvc/spring/components/TokenAuthenticationService.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService]: Constructor threw exception; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select settingValue from systemSettings where settingName=?]; SQL state [HY000]; error code [50000]; General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]; nested exception is org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:279) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	... 28 more
    Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService]: Constructor threw exception; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select settingValue from systemSettings where settingName=?]; SQL state [HY000]; error code [50000]; General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]; nested exception is org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]
    	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:154) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	... 28 more
    Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select settingValue from systemSettings where settingName=?]; SQL state [HY000]; error code [50000]; General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]; nested exception is org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]
    	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:655) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:690) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:732) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39) ~[mango-3.4.4.jar:?]
    	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63) ~[mango-3.4.4.jar:?]
    	at com.serotonin.db.DaoUtils.queryForObject(DaoUtils.java:400) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.lambda$getValue$0(SystemSettingsDao.java:207) ~[mango-3.4.4.jar:?]
    	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(Unknown Source) ~[?:1.8.0_172]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.getValue(SystemSettingsDao.java:206) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.getValue(SystemSettingsDao.java:191) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService.loadKeyPair(TokenAuthenticationService.java:63) ~[mango-3.4.4.jar:?]
    	at com.infiniteautomation.mango.jwt.JwtSignerVerifier.<init>(JwtSignerVerifier.java:55) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService.<init>(TokenAuthenticationService.java:44) ~[mango-3.4.4.jar:?]
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_172]
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:142) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	... 28 more
    Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB"; SQL statement:
    

  • [page 3]

    INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, POS, HASH, BLOCK) SELECT ?, SEQ, POS, HASH, BLOCK FROM INFORMATION_SCHEMA.LOB_MAP WHERE LOB = ? [50000-196]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.message.DbException.get(DbException.java:168) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.message.DbException.convert(DbException.java:295) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.table.RegularTable.addRow(RegularTable.java:137) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.addRow(Insert.java:198) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.insertRows(Insert.java:172) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.update(Insert.java:114) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.CommandContainer.update(CommandContainer.java:101) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.Command.executeUpdate(Command.java:260) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:164) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:150) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.store.LobStorageBackend.copyLob(LobStorageBackend.java:468) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.value.ValueLobDb.copyToResult(ValueLobDb.java:488) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.value.ValueLobDb.copyToResult(ValueLobDb.java:38) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.result.LocalResult.cloneLobs(LocalResult.java:273) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.result.LocalResult.addRow(LocalResult.java:298) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Select.queryFlat(Select.java:523) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.query(Query.java:371) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.query(Query.java:333) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.CommandContainer.query(CommandContainer.java:113) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.Command.executeQuery(Command.java:201) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) ~[h2-1.4.196.jar:1.4.196]
    	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:698) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:639) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:690) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:732) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39) ~[mango-3.4.4.jar:?]
    	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63) ~[mango-3.4.4.jar:?]
    	at com.serotonin.db.DaoUtils.queryForObject(DaoUtils.java:400) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.lambda$getValue$0(SystemSettingsDao.java:207) ~[mango-3.4.4.jar:?]
    	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(Unknown Source) ~[?:1.8.0_172]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.getValue(SystemSettingsDao.java:206) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.getValue(SystemSettingsDao.java:191) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService.loadKeyPair(TokenAuthenticationService.java:63) ~[mango-3.4.4.jar:?]
    	at com.infiniteautomation.mango.jwt.JwtSignerVerifier.<init>(JwtSignerVerifier.java:55) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService.<init>(TokenAuthenticationService.java:44) ~[mango-3.4.4.jar:?]
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_172]
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:142) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	... 28 more
    Caused by: java.lang.RuntimeException: rowCount expected 7271 got 7334 LOB_MAP.INDEX_LOB_MAP_DATA_LOB
    	at org.h2.message.DbException.throwInternalError(DbException.java:242) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.table.RegularTable.checkRowCount(RegularTable.java:169) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.table.RegularTable.addRow(RegularTable.java:120) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.addRow(Insert.java:198) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.insertRows(Insert.java:172) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Insert.update(Insert.java:114) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.CommandContainer.update(CommandContainer.java:101) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.Command.executeUpdate(Command.java:260) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:164) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:150) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.store.LobStorageBackend.copyLob(LobStorageBackend.java:468) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.value.ValueLobDb.copyToResult(ValueLobDb.java:488) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.value.ValueLobDb.copyToResult(ValueLobDb.java:38) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.result.LocalResult.cloneLobs(LocalResult.java:273) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.result.LocalResult.addRow(LocalResult.java:298) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Select.queryFlat(Select.java:523) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:625) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.query(Query.java:371) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.dml.Query.query(Query.java:333) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.CommandContainer.query(CommandContainer.java:113) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.command.Command.executeQuery(Command.java:201) ~[h2-1.4.196.jar:1.4.196]
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) ~[h2-1.4.196.jar:1.4.196]
    	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:698) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:639) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:690) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:732) ~[spring-jdbc-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39) ~[mango-3.4.4.jar:?]
    	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63) ~[mango-3.4.4.jar:?]
    	at com.serotonin.db.DaoUtils.queryForObject(DaoUtils.java:400) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.lambda$getValue$0(SystemSettingsDao.java:207) ~[mango-3.4.4.jar:?]
    	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(Unknown Source) ~[?:1.8.0_172]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.getValue(SystemSettingsDao.java:206) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.db.dao.SystemSettingsDao.getValue(SystemSettingsDao.java:191) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService.loadKeyPair(TokenAuthenticationService.java:63) ~[mango-3.4.4.jar:?]
    	at com.infiniteautomation.mango.jwt.JwtSignerVerifier.<init>(JwtSignerVerifier.java:55) ~[mango-3.4.4.jar:?]
    	at com.serotonin.m2m2.web.mvc.spring.components.TokenAuthenticationService.<init>(TokenAuthenticationService.java:44) ~[mango-3.4.4.jar:?]
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_172]
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_172]
    	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:142) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1201) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1103) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-4.3.17.RELEASE.jar:4.3.17.RELEASE]
    	... 28 more
    ERROR 2018-08-08T16:13:52,985 (com.serotonin.m2m2.Main.main:138) - Error during initialization 
    java.lang.NullPointerException: null
    	at com.serotonin.m2m2.Lifecycle.configureStartupDwr(Lifecycle.java:1151) ~[ma-priv-3.4.4.jar:?]
    	at com.serotonin.m2m2.Lifecycle.fullyInitializeWebContext(Lifecycle.java:1090) ~[ma-priv-3.4.4.jar:?]
    	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:346) ~[ma-priv-3.4.4.jar:?]
    	at com.serotonin.m2m2.Main.main(Main.java:134) [ma-priv-3.4.4.jar:?]
    INFO  2018-08-08T16:13:52,985 (com.serotonin.m2m2.Lifecycle.terminate:387) - Mango Lifecycle terminating... 
    INFO  2018-08-08T16:13:53,344 (com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl.joinTermination:550) - All high priority tasks exited gracefully. 
    INFO  2018-08-08T16:13:53,344 (com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl.joinTermination:556) - All medium priority tasks exited gracefully. 
    INFO  2018-08-08T16:13:53,344 (com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl.joinTermination:561) - All low priority tasks exited gracefully. 
    INFO  2018-08-08T16:13:56,612 (com.serotonin.m2m2.Lifecycle.terminate:496) - Mango Lifecycle terminated.
    

  • Hi balanceBryce, welcome to the forum!

    It looks like your database is probably corrupted. You may have a backup in your Mango/backup/ with a name like core-database-H2-Aug-*

    If so, I advise moving your Mango/databases directory to Mango/corrupted-database (while Mango is stopped, but it looks like it's not starting anyway) just for safe keeping, then start Mango and try to restore the backup using the instructions here: https://help.infiniteautomation.com/how-to-restore-a-h2-database-backup/ There is also an SQL backups section in the new System Settings page under the Administration menu.

    Mango will have started with the default username and password, admin / admin

    You can post logs between three backtick marks on their own lines to get good formatting. I'm going to edit some into your posts....


  • @phildunlap

    Thank you, that has it fixed. I appreciate your quick response.

    Bryce