@phildunlap
How do I know if the database has finished restoring?
After hitting restore it just stays there.
My mango version is 2.5.2
"Using C:\Mango as MA_HOME
C:\Mango\overrides\classes;C:\Mango\classes;C:\Mango\overrides\properties;C:\Man
go\overrides\lib*;C:\Mango\lib*
Using Java at java
INFO 2017-05-26 14:51:16,416 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'asciiFile', v1.1.5 by Infinite Automation
INFO 2017-05-26 14:51:16,423 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'BACnet', v2.1.3 by Infinite Automation Software
INFO 2017-05-26 14:51:16,427 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'controlcore', v1.0.5 by Infinite Automation
INFO 2017-05-26 14:51:16,429 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'dashboards', v1.0.3 by Infinite Automation
INFO 2017-05-26 14:51:16,430 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'dataFile', v1.0.8 by Infinite Automation
INFO 2017-05-26 14:51:16,435 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'dataImport', v1.3.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,438 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'dglux', v1.2.0 by Infinite Automation Software
INFO 2017-05-26 14:51:16,440 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'dnp3', v1.5.0 by Infinite Automation Software
INFO 2017-05-26 14:51:16,443 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'galil', v1.4.5 by Infinite Automation Software
INFO 2017-05-26 14:51:16,445 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'graphicalViews', v1.5.2 by Infinite Automation Software
INFO 2017-05-26 14:51:16,463 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'http', v1.4.7 by Infinite Automation Software
INFO 2017-05-26 14:51:16,467 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'internal', v1.4.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,469 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'jmxds', v1.4.5 by Infinite Automation Software
INFO 2017-05-26 14:51:16,472 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'jspViews', v2.0.5 by Infinite Automation Software
INFO 2017-05-26 14:51:16,482 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'log4jDS', v1.0.2 by Infinite Automation Software
INFO 2017-05-26 14:51:16,485 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'log4JReset', v1.0.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,486 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'loggingConsole', v1.0.2 by Infinite Automation
INFO 2017-05-26 14:51:16,487 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'maintenanceEvents', v1.4.8 by Infinite Automation Software
INFO 2017-05-26 14:51:16,490 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'mangoApi', v1.0.3 by Infinite Automation
INFO 2017-05-26 14:51:16,491 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'mbus', v1.0.7 by Infinite Automation Software
INFO 2017-05-26 14:51:16,496 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'meta', v2.1.1 by Infinite Automation Software
INFO 2017-05-26 14:51:16,500 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'modbus', v1.5.4 by Infinite Automation Software
INFO 2017-05-26 14:51:16,509 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'onewire', v1.4.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,512 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'opcda', v1.5.7 by Infinite Automation Software
INFO 2017-05-26 14:51:16,513 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'openv4j', v1.0.5 by aploese
INFO 2017-05-26 14:51:16,515 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'pachube', v1.4.8 by Infinite Automation Software
INFO 2017-05-26 14:51:16,517 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'persistent', v1.5.8 by Infinite Automation Systems Inc.
INFO 2017-05-26 14:51:16,520 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'pointLinks', v1.4.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,522 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'pop3', v1.4.5 by Infinite Automation Software
INFO 2017-05-26 14:51:16,525 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'reports', v2.1.3 by Infinite Automation Systems Inc.
INFO 2017-05-26 14:51:16,529 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'scheduledEvents', v1.4.7 by (unknown vendor)
INFO 2017-05-26 14:51:16,531 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'scripting', v1.0.8 by Infinite Automation Software
INFO 2017-05-26 14:51:16,535 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'serial', v1.1.5 by Infinite Automation
INFO 2017-05-26 14:51:16,537 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'snmp', v1.4.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,540 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'sqlConsole', v1.4.5 by Infinite Automation Software
INFO 2017-05-26 14:51:16,542 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'sqlds', v1.5.7 by Infinite Automation Software
INFO 2017-05-26 14:51:16,545 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'ssh', v1.0.5 by Infinite Automation Systems Inc.
INFO 2017-05-26 14:51:16,548 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'sstGlobalScripts', v1.4.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,550 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'sstGraphics', v1.0.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,551 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'sstTheme', v1.0.6 by Infinite Automation Software
INFO 2017-05-26 14:51:16,551 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'TCPIP', v1.0.3 by Infinite Automation Systems Inc.
INFO 2017-05-26 14:51:16,554 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'templateConfig', v1.0.5 by Infinite Automation Software
INFO 2017-05-26 14:51:16,556 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'twilio', v1.0.4 by (unknown vendor)
INFO 2017-05-26 14:51:16,560 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'virtualDS', v1.4.5 by Infinite Automation Software
INFO 2017-05-26 14:51:16,563 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'vmstat', v1.4.7 by Infinite Automation Software
INFO 2017-05-26 14:51:16,569 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
g module 'watchlists', v1.6.1 by Infinite Automation Systems Inc.
INFO 2017-05-26 14:51:17,306 (com.serotonin.m2m2.Lifecycle.loadLic:411) - Check
ing license...
INFO 2017-05-26 14:51:17,373 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:42)
- Initializing H2 connection manager
INFO 2017-05-26 14:51:22,014 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgr
ade:36) - Starting instance with core version 2.5.2, db 9
Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: Prep
aredStatementCallback; bad SQL grammar [select id, xid, alias, data from eventHa
ndlers where eventTypeName=? and eventSubtypeName=? and (eventTypeRef1=? or ev
entTypeRef1=0) and (eventTypeRef2=? or eventTypeRef2=0)]; nested exception is o
rg.h2.jdbc.JdbcSQLException: Tabla "EVENTHANDLERS" no encontrada
Table "EVENTHANDLERS" not found; SQL statement:
select id, xid, alias, data from eventHandlers where eventTypeName=? and eventSu
btypeName=? and (eventTypeRef1=? or eventTypeRef1=0) and (eventTypeRef2=? or
eventTypeRef2=0) [42102-181]
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
oTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:69
-
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:72
-
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:73
-
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:78
-
at com.serotonin.db.DaoUtils.query(DaoUtils.java:308)
at com.serotonin.m2m2.db.dao.EventDao.getEventHandlers(EventDao.java:611
)
at com.serotonin.m2m2.db.dao.EventDao.getEventHandlers(EventDao.java:581
)
at com.serotonin.m2m2.rt.EventManager.setHandlers(EventManager.java:415)
at com.serotonin.m2m2.rt.EventManager.raiseEvent(EventManager.java:94)
at com.serotonin.m2m2.rt.event.type.SystemEventType.raiseEvent(SystemEve
ntType.java:97)
at com.serotonin.m2m2.Lifecycle.terminate(Lifecycle.java:321)
at com.serotonin.m2m2.Main.main(Main.java:108)
Caused by: org.h2.jdbc.JdbcSQLException: Tabla "EVENTHANDLERS" no encontrada
Table "EVENTHANDLERS" not found; SQL statement:
select id, xid, alias, data from eventHandlers where eventTypeName=? and eventSu
btypeName=? and (eventTypeRef1=? or eventTypeRef1=0) and (eventTypeRef2=? or
eventTypeRef2=0) [42102-181]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.command.Parser.readTableOrView(Parser.java:5227)
at org.h2.command.Parser.readTableFilter(Parser.java:1221)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1860)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1969)
at org.h2.command.Parser.parseSelectSub(Parser.java:1854)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1675)
at org.h2.command.Parser.parseSelect(Parser.java:1663)
at org.h2.command.Parser.parsePrepared(Parser.java:433)
at org.h2.command.Parser.parse(Parser.java:305)
at org.h2.command.Parser.parse(Parser.java:277)
at org.h2.command.Parser.prepareCommand(Parser.java:242)
at org.h2.engine.Session.prepareLocal(Session.java:446)
at org.h2.engine.Session.prepareCommand(Session.java:388)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1189)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
2)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:277)
at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCre
ator.createPreparedStatement(JdbcTemplate.java:1557)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
638)
... 12 more
"