View Issue Details

IDProjectCategoryView StatusLast Update
0004075SymmetricDSBugpublic2019-08-23 16:46
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.3 
Target Version3.10.4Fixed in Version3.10.4 
Summary0004075: During upgrade, remove triggers for symmetric tables that changed, then add them back before doing any possible DML statements
DescriptionRight now, the upgrade leaves the current triggers in place after changing the DDL of the Symmetric tables, then there are DML statements run that cause the old triggers to run against the possibly modified tables.

Before the table structures are changed, the triggers should be removed, then after the structures are changed, put them back.
Steps To Reproduce1. Install version 3.8.14.
2. Define some groups and nodes
3. Upgrade to 3.10.3

ArrayIndexOutOfBounds exceptions should be thrown.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 b3d9ce1b

2019-08-21 16:38:12

Philip Marzullo

Details Diff
0004075: During upgrade, remove triggers for symmetric tables that
changed, then add them back before doing any possible DML statements
Affected Issues
0004075
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/DatabaseUpgradeListener.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2019-08-21 20:24 pmarzullo New Issue
2019-08-21 20:24 pmarzullo Status new => assigned
2019-08-21 20:24 pmarzullo Assigned To => pmarzullo
2019-08-21 21:00 Changeset attached => SymmetricDS 3.10 b3d9ce1b
2019-08-21 21:04 pmarzullo Status assigned => resolved
2019-08-21 21:04 pmarzullo Resolution open => fixed
2019-08-21 21:04 pmarzullo Fixed in Version => 3.10.4
2019-08-23 16:46 admin Status resolved => closed