View Issue Details

IDProjectCategoryView StatusLast Update
0004318SymmetricDSBugpublic2020-03-17 18:42
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.11Fixed in Version3.10.11 
Summary0004318: MySQL upgrade gets sym_transaction_id_pre_5_7_6 does not exist
DescriptionSymmetricDS 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)
TagsNo tags attached.

Relationships

related to 0004320 closedelong MySQL upgrade gets sym_transaction_id_pre_5_7_6 does not exist 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 6b57e89f

2020-03-17 09:23:39

admin

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

Issue History

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