View Issue Details

IDProjectCategoryView StatusLast Update
0005667SymmetricDSBugpublic2023-02-01 15:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.7 
Target Version3.12.22Fixed in Version3.12.22 
Summary0005667: Initial load sends too many tables when using $(targetExternalId) variable
DescriptionAn initial or partial load will send more tables than it should to a target node when using $(targetExternalId) variable. The variable expands to match multiple target nodes, resulting in multiple trigger history records for the same trigger ID. For example, the trigger for $(targetExternalId)$Item with 3 nodes (client1, client2, and client3) on the system will create the following trigger history records:

client1$Item
client2$Item
client3$Item

Sending a load to client1 should send only client1$Item table, but it sends all 3 tables instead.
Tagsinitial/partial load

Relationships

related to 0004837 closedjosh-a-hicks SymmetricDS Pro Support for a new variable in trigger source table name to expand upon based on configured nodes 
related to 0005676 closedelong SymmetricDS Initial load sends too many tables when using $(targetExternalId) variable 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 9cdf060e

2023-02-01 14:17:46

admin

Details Diff
0005667: Initial load sends too many tables when using
$(targetExternalId) variable
Affected Issues
0005667
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ITriggerRouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

Issue History

Date Modified Username Field Change
2023-01-25 21:22 elong New Issue
2023-01-25 21:22 elong Status new => assigned
2023-01-25 21:22 elong Assigned To => elong
2023-01-25 21:22 elong Tag Attached: initial/partial load
2023-01-25 21:23 elong Relationship added related to 0004837
2023-02-01 14:18 elong Status assigned => resolved
2023-02-01 14:18 elong Resolution open => fixed
2023-02-01 14:18 elong Fixed in Version => 3.12.22
2023-02-01 14:18 elong Issue cloned: 0005676
2023-02-01 14:18 elong Relationship added related to 0005676
2023-02-01 15:00 admin Changeset attached => SymmetricDS 3.12 9cdf060e
2023-02-15 20:25 admin Status resolved => closed