View Issue Details

IDProjectCategoryView StatusLast Update
0005693SymmetricDSBugpublic2023-02-15 14:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.4 
Target Version3.14.5Fixed in Version3.14.5 
Summary0005693: Fix multiple active trigger histories before sync triggers is run
DescriptionWe currently have a problem where sometimes there are multiple active trigger histories that are active for the same trigger ID, source table name, source schema, and source catalog.

In order to fix this problem, we could add an automated fix that will run before any sync triggers method is called.
This method will leave the most recent duplicate trigger ID/source table name/source schema/source catalog as the active trigger history ID and mark all others that are still active as inactive.
Tagssync-trigger

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 bf71bb82

2023-02-14 18:13:50

pmarzullo

Details Diff
0005693: Fix multiple active trigger histories before sync triggers is
run
Affected Issues
0005693
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterServiceSqlMap.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

SymmetricDS: 3.14 04d39ed6

2023-02-15 13:43:52

pmarzullo

Details Diff
0005693: Fix multiple active trigger histories before sync triggers is
run

Default parameter to true if not specified in properties file
Affected Issues
0005693
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

Issue History

Date Modified Username Field Change
2023-02-07 17:26 pmarzullo New Issue
2023-02-07 17:26 pmarzullo Status new => assigned
2023-02-07 17:26 pmarzullo Assigned To => pmarzullo
2023-02-07 17:26 pmarzullo Tag Attached: sync-trigger
2023-02-14 18:14 pmarzullo Status assigned => resolved
2023-02-14 18:14 pmarzullo Resolution open => fixed
2023-02-14 18:14 pmarzullo Fixed in Version => 3.14.5
2023-02-14 19:00 pmarzullo Changeset attached => SymmetricDS 3.14 bf71bb82
2023-02-15 14:00 pmarzullo Changeset attached => SymmetricDS 3.14 04d39ed6
2023-02-15 20:26 admin Status resolved => closed