View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001964 | SymmetricDS | Bug | public | 2014-09-12 14:37 | 2014-09-17 22:01 |
| Reporter | chenson | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.6.7 | ||||
| Target Version | 3.6.8 | Fixed in Version | 3.6.8 | ||
| Summary | 0001964: Upgrade from 3.1.5 to 3.6 fails on MySQL | ||||
| Description | [server] - MySqlSymmetricDialect - DDL failed: ALTER TABLE `ships`.`sym_console_user` ADD COLUMN `create_time` DATETIME AFTER `user_role` [server] - JdbcSqlTemplate - Unknown column 'user_role' in 'sym_console_user'. Failed to execute: ALTER TABLE `ships`.`sym_console_user` ADD COLUMN `create_time` DATETIME AFTER `user_role` [server] - AbstractSymmetricEngine - An error occurred while starting SymmetricDS org.jumpmind.db.sql.SqlException: Unknown column 'user_role' in 'sym_console_user' at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:425) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:338) at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:107) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:426) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:151) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:377) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:368) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:507) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:499) at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:440) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'user_role' in 'sym_console_user' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2832) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2781) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:908) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:788) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:351) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:338) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:423) ... 9 more | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-09-12 14:37 | chenson | New Issue | |
| 2014-09-12 14:37 | chenson | Status | new => assigned |
| 2014-09-12 14:37 | chenson | Assigned To | => chenson |
| 2014-09-12 15:00 | chenson | Changeset attached | => SymmetricDS 3.6 r8684 |
| 2014-09-12 15:00 | chenson | Changeset attached | => SymmetricDS trunk r8685 |
| 2014-09-12 15:11 | chenson | Status | assigned => resolved |
| 2014-09-12 15:11 | chenson | Fixed in Version | => 3.6.8 |
| 2014-09-12 15:11 | chenson | Resolution | open => fixed |
| 2014-09-17 22:01 | chenson | Status | resolved => closed |
| 2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master d134a42c |