View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004320 | SymmetricDS | Bug | public | 2020-03-17 15:20 | 2020-03-17 18:43 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.11.7 | Fixed in Version | 3.11.7 | ||
| Summary | 0004320: MySQL upgrade gets sym_transaction_id_pre_5_7_6 does not exist | ||||
| Description | SymmetricDS alters tables, runs the upgrade listener (which syncs triggers), and then createsRequiredDatabaseObjects. The syncing of triggers updates the triggers, but the triggers require the missing function that is created by createsRequiredDatabaseObjects. An update of sym_channel causes the triggers to fire prior to createsRequiredDatabaseObjects so you get the following error and SymmetricDS doesn't start. org.jumpmind.db.sql.SqlException: FUNCTION storedb.sym_transaction_id_pre_5_7_6 does not exist at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:305) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:294) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:519) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:358) at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:227) at org.jumpmind.symmetric.db.DatabaseUpgradeListener.afterUpgrade(DatabaseUpgradeListener.java:217) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:546) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:513) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:487) | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-03-17 15:20 | elong | New Issue | |
| 2020-03-17 15:20 | elong | Status | new => assigned |
| 2020-03-17 15:20 | elong | Assigned To | => elong |
| 2020-03-17 15:20 | elong | Issue generated from: 0004318 | |
| 2020-03-17 15:20 | elong | Relationship added | related to 0004318 |
| 2020-03-17 15:21 | elong | Status | assigned => resolved |
| 2020-03-17 15:21 | elong | Resolution | open => fixed |
| 2020-03-17 15:21 | elong | Fixed in Version | => 3.11.7 |
| 2020-03-17 18:43 | admin | Status | resolved => closed |