View Issue Details

IDProjectCategoryView StatusLast Update
0006930SymmetricDSBugpublic2025-07-10 12:55
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.19Fixed in Version3.15.19 
Summary0006930: Purge recapture of stranded data does not specify correct key columns when Sync Key Names is populated
DescriptionWhen purge attempts to recapture stranded data, it needs to use the mangled Table definition because the customer may have specified Sync Key Names which changes the key values for the target.

Steps To Reproduce1. Configure table with Sync Key Names (different columns than the original key columns).
2. Insert record into source, but don't commit until after the logging indicates that a data gap has timed out.
3. Commit the insert.
4. Run the Purge Outgoing job and look for the recaptured sym_data record and check the primary key values.
5. The values will be the wrong columns.
Tagspurge

Activities

pbelov

2025-07-10 12:55

manager   ~0003176

Included in the 3.15.19 release

Related Changesets

SymmetricDS: 3.15 3b0d3d56

2025-06-30 21:12:09

philipmarzullo64


Committer: GitHub Details Diff
6930: Purge recapture of stranded data does not specify correct key (#295)

6930: Purge recapture of stranded data does not specify correct key
Affected Issues
0006930
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

SymmetricDS: 3.16 e439aead

2025-07-01 12:52:57

pbelov


Committer: GitHub Details Diff
6930: Merged and resolved conflicts - Purge recapture of stranded data (#314)

6930: Merged (into 3.16) and resolved conflicts - Purge recapture of stranded data does not specify correct key. Co-authored-by: philipmarzullo64
Affected Issues
0006930
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

SymmetricDS: 3.16 ee6a2d67

2025-07-09 12:37:46

admin

Details Diff
6930: fix H2 dialect, unescape ticks Affected Issues
0006930
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/AbstractEmbeddedSymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2025-06-09 20:46 pmarzullo New Issue
2025-06-09 20:46 pmarzullo Status new => assigned
2025-06-09 20:46 pmarzullo Assigned To => pmarzullo
2025-06-09 20:46 pmarzullo Tag Attached: purge
2025-06-20 19:46 pbelov Target Version 3.15.18 => 3.15.19
2025-06-30 21:13 pbelov Status assigned => resolved
2025-06-30 21:13 pbelov Resolution open => fixed
2025-06-30 21:13 pbelov Fixed in Version => 3.15.19
2025-06-30 22:00 Changeset attached => SymmetricDS 3.15 3b0d3d56
2025-07-01 13:00 pbelov Changeset attached => SymmetricDS 3.16 e439aead
2025-07-09 13:00 admin Changeset attached => SymmetricDS 3.16 ee6a2d67
2025-07-10 12:55 pbelov Note Added: 0003176
2025-07-10 12:55 pbelov Status resolved => closed