View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004318 | SymmetricDS | Bug | public | 2020-03-17 13:09 | 2020-03-17 18:42 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.10.11 | Fixed in Version | 3.10.11 | ||
| Summary | 0004318: 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. | ||||
|
SymmetricDS: 3.10 6b57e89f 2020-03-17 09:23:39 Details Diff |
0004318: MySQL upgrade gets sym_transaction_id_pre_5_7_6 does not exist |
Affected Issues 0004318 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2SymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-03-17 13:09 | elong | New Issue | |
| 2020-03-17 13:09 | elong | Status | new => assigned |
| 2020-03-17 13:09 | elong | Assigned To | => elong |
| 2020-03-17 14:00 | admin | Changeset attached | => SymmetricDS 3.10 6b57e89f |
| 2020-03-17 15:20 | elong | Status | assigned => resolved |
| 2020-03-17 15:20 | elong | Resolution | open => fixed |
| 2020-03-17 15:20 | elong | Fixed in Version | => 3.10.11 |
| 2020-03-17 15:20 | elong | Issue cloned: 0004320 | |
| 2020-03-17 15:20 | elong | Relationship added | related to 0004320 |
| 2020-03-17 18:42 | admin | Status | resolved => closed |