View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005041 | SymmetricDS | Bug | public | 2021-06-25 15:14 | 2021-07-13 17:53 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.12.11 | Fixed in Version | 3.12.11 | ||
| Summary | 0005041: Upgrade from 3.7 to 3.11 fails to upgrade schema | ||||
| Description | When upgrading from version 3.7 or older to version 3.11 or newer, the routine that prepares to alter the SymmetricDS schema gets an exception. It is checking the configuration and data to see if data changes need to be made to sym_data_event before a unique index will be applied. The routine makes a service call to return configuration, but the service is expecting new columns to be present on SymmetricDS tables, which haven't been altered yet. [server] - MariaDBSymmetricDialect - Checking if SymmetricDS tables need created or altered [server] - DatabaseUpgradeListener - Detected upgrade from pre-3.11 version. [server] - AbstractSymmetricEngine - An error occurred while starting SymmetricDS org.jumpmind.db.sql.SqlException: Failed to execute sql: select source_node_group_id, target_node_group_id, data_event_action, sync_config_enabled, is_reversible, last_update_time, last_update_by, create_time from sym_node_group_link order by source_node_group_id at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:313) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:123) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:160) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:148) at org.jumpmind.db.sql.AbstractSqlTemplate.queryForCursor(AbstractSqlTemplate.java:113) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:210) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:206) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:196) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:132) at org.jumpmind.symmetric.service.impl.ConfigurationService.getNodeGroupLinks(ConfigurationService.java:251) at org.jumpmind.symmetric.service.impl.TriggerRouterService.getRouters(TriggerRouterService.java:926) at org.jumpmind.symmetric.service.impl.TriggerRouterService.getRouters(TriggerRouterService.java:921) at org.jumpmind.symmetric.service.impl.TriggerRouterService.enhanceTriggerRouters(TriggerRouterService.java:1006) at org.jumpmind.symmetric.service.impl.TriggerRouterService.getAllTriggerRoutersForCurrentNode(TriggerRouterService.java:962) at org.jumpmind.symmetric.db.DatabaseUpgradeListener.shouldFixDataEvent311(DatabaseUpgradeListener.java:259) at org.jumpmind.symmetric.db.DatabaseUpgradeListener.beforeUpgrade(DatabaseUpgradeListener.java:97) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:506) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:160) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:513) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:487) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:660) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:649) at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:283) at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:630) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'is_reversible' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:100) ... 25 more | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-06-25 15:14 | elong | New Issue | |
| 2021-06-25 15:14 | elong | Status | new => assigned |
| 2021-06-25 15:14 | elong | Assigned To | => elong |
| 2021-06-25 16:40 | elong | Status | assigned => resolved |
| 2021-06-25 16:40 | elong | Resolution | open => fixed |
| 2021-06-25 16:40 | elong | Fixed in Version | => 3.12.11 |
| 2021-06-25 17:00 | admin | Changeset attached | => SymmetricDS 3.12 e1925815 |
| 2021-07-13 17:53 | admin | Status | resolved => closed |