• 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

    RuntimeManager initialization failure

    Mango General
    2
    5
    1.5k
    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
      balanceBryce
      last edited by phildunlap

      [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]
      1 Reply Last reply Reply Quote 0
      • B
        balanceBryce
        last edited by phildunlap

        [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:
        1 Reply Last reply Reply Quote 0
        • B
          balanceBryce
          last edited by phildunlap

          [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.
          1 Reply Last reply Reply Quote 0
          • phildunlapP
            phildunlap
            last edited by

            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....

            B 1 Reply Last reply Reply Quote 0
            • B
              balanceBryce @phildunlap
              last edited by

              @phildunlap

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

              Bryce

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