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.
Help!urgent! why I use mysql in mango and display below?
-
now I install a new mango in new computer. I want to use mysql .and install mysql .but display below message .how to solve it ?
2014-08-22 14:47:33,288 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:47:33,293 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 14:47:33,300 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 14:47:33,307 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:47:33,310 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:47:33,313 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 14:47:33,315 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:47:34,605 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 14:47:34,607 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 14:47:35,365 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:47:35,432 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 14:47:35,483 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 14:47:35,542 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 14:47:35,544 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 14:47:35,596 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 14:47:35,598 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 14:47:35,633 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 14:47:35,635 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 14:47:35,636 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 14:47:35,659 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 14:47:35,661 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 14:47:35,663 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:47:35,679 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 14:47:35,681 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 14:47:35,682 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 14:47:36,363 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 14:47:36,365 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 14:47:36,547 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 14:47:39,917 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 14:47:39,951 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 14:47:40,048 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 14:47:40,054 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more
INFO 2014-08-22 14:52:06,653 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,668 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-22 14:52:06,688 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,700 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,713 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,716 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,720 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,723 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,750 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-22 14:52:06,754 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,756 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,759 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-22 14:52:06,765 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,771 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,774 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,777 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:52:06,782 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,785 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-22 14:52:06,790 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,796 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software
INFO 2014-08-22 14:52:06,801 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software
INFO 2014-08-22 14:52:06,811 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,815 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,820 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,823 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,826 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,829 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,832 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-22 14:52:06,833 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-22 14:52:06,836 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-22 14:52:06,842 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-22 14:52:06,845 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,848 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,850 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-22 14:52:06,851 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-22 14:52:06,855 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,865 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 14:52:06,867 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 14:52:06,872 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,875 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,879 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 14:52:06,881 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:52:08,105 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 14:52:08,106 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 14:52:08,469 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:52:08,527 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 14:52:08,569 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 14:52:08,629 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 14:52:08,630 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 14:52:08,668 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 14:52:08,676 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 14:52:08,706 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 14:52:08,712 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 14:52:08,713 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 14:52:08,753 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 14:52:08,754 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 14:52:08,755 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:52:08,801 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 14:52:08,803 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 14:52:08,804 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 14:52:09,365 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 14:52:09,367 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 14:52:09,477 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 14:52:09,875 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 14:52:09,879 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 14:52:10,010 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 14:52:10,015 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more
INFO 2014-08-22 14:56:35,980 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:35,996 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-22 14:56:36,009 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,021 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,041 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,044 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,050 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,053 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,085 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-22 14:56:36,088 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,090 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,092 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-22 14:56:36,098 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,105 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,108 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,111 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:56:36,116 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,119 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-22 14:56:36,123 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,127 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software
INFO 2014-08-22 14:56:36,133 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software
INFO 2014-08-22 14:56:36,144 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,147 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,153 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,156 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,159 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,162 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,166 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-22 14:56:36,167 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-22 14:56:36,169 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-22 14:56:36,175 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-22 14:56:36,178 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,181 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,182 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-22 14:56:36,184 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-22 14:56:36,189 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,197 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 14:56:36,200 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 14:56:36,206 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,208 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,211 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 14:56:36,213 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:56:37,456 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 14:56:37,458 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 14:56:37,820 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:56:37,887 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 14:56:37,933 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 14:56:37,994 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 14:56:37,995 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 14:56:38,032 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 14:56:38,041 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 14:56:38,065 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 14:56:38,076 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 14:56:38,078 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 14:56:38,113 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 14:56:38,120 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 14:56:38,121 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:56:38,157 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 14:56:38,159 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 14:56:38,160 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 14:56:38,707 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 14:56:38,709 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 14:56:38,819 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 14:56:39,215 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 14:56:39,218 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 14:56:39,354 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 14:56:39,359 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more
INFO 2014-08-22 15:03:58,695 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,722 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-22 15:03:58,725 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,737 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,749 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,761 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,768 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,772 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,799 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-22 15:03:58,802 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,804 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,806 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-22 15:03:58,813 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,821 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,824 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,826 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 15:03:58,831 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,834 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-22 15:03:58,838 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,843 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software
INFO 2014-08-22 15:03:58,849 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software
INFO 2014-08-22 15:03:58,859 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,865 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,871 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,874 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,877 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,879 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,883 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-22 15:03:58,885 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-22 15:03:58,889 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-22 15:03:58,895 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-22 15:03:58,898 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,901 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,902 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-22 15:03:58,904 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-22 15:03:58,908 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,917 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 15:03:58,923 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 15:03:58,929 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,931 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,934 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 15:03:58,936 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 15:04:00,176 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 15:04:00,178 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 15:04:00,548 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 15:04:00,610 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 15:04:00,646 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 15:04:00,714 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 15:04:00,720 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 15:04:00,753 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 15:04:00,761 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 15:04:00,800 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 15:04:00,809 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 15:04:00,811 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 15:04:00,851 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 15:04:00,856 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 15:04:00,857 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 15:04:00,898 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 15:04:00,900 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 15:04:00,901 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 15:04:01,453 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 15:04:01,455 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 15:04:01,566 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 15:04:01,983 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 15:04:01,986 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 15:04:02,121 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 15:04:02,134 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more
INFO 2014-08-22 15:04:49,049 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,064 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-22 15:04:49,076 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,093 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,106 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,113 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,120 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,123 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,151 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-22 15:04:49,154 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,155 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,157 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-22 15:04:49,165 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,172 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,174 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,179 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 15:04:49,184 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,187 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-22 15:04:49,191 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,197 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software
INFO 2014-08-22 15:04:49,203 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software
INFO 2014-08-22 15:04:49,212 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,218 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,224 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,227 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,229 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,232 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,235 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-22 15:04:49,236 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-22 15:04:49,240 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-22 15:04:49,248 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-22 15:04:49,251 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,253 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,255 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-22 15:04:49,256 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-22 15:04:49,260 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,270 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 15:04:49,275 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 15:04:49,278 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,282 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,284 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 15:04:49,286 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 15:04:50,530 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 15:04:50,532 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 15:04:50,914 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 15:04:50,979 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 15:04:51,019 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 15:04:51,090 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 15:04:51,096 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 15:04:51,137 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 15:04:51,145 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 15:04:51,178 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 15:04:51,185 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 15:04:51,191 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 15:04:51,232 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 15:04:51,234 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 15:04:51,235 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 15:04:51,281 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 15:04:51,284 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 15:04:51,287 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 15:04:51,868 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 15:04:51,869 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 15:04:51,973 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 15:04:52,368 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 15:04:52,371 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 15:04:52,504 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 15:04:52,510 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more