View Issue Details

IDProjectCategoryView StatusLast Update
0006415SymmetricDSBugpublic2024-05-10 13:20
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.6 
Target Version3.15.7Fixed in Version3.15.7 
Summary0006415: Recapture data for stranded data and for expired data gaps should keep the old data values to allow subselect routing to work
DescriptionRight now, the recapture data functionality does not recapture the old data.
But the old data can be used by the subselect routers directly, or it can be used when it is a DELETE event when referencing the row data (old data is used for DELETE event since there is no rowdata captured for a DELETE event).
This causes the routing to fail because the referenced column names are not available in the old data.

The recapture data functionality should keep the old data from the original data that was stranded or expired.
Steps To Reproduce1. Create a subselect router that references a column value.
2. Cause a delete event to be stranded by not committing for more than the parameter value routing.stale.dataid.gap.time.ms
3. Run purge to have it recapture this data ID.
4. Run routing to allow it to fail because it refers to data that is not saved in the sym_data record.
Tagspurge

Related Changesets

SymmetricDS: 3.15 00ac2e41

2024-05-09 18:46:30

pmarzullo

Details Diff
0006415: Recapture data for stranded data and for expired data gaps
should keep the old data values to allow subselect routing to work
Affected Issues
0006415
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2024-05-09 18:12 pmarzullo New Issue
2024-05-09 18:12 pmarzullo Status new => assigned
2024-05-09 18:12 pmarzullo Assigned To => pmarzullo
2024-05-09 18:12 pmarzullo Tag Attached: purge
2024-05-09 19:00 pmarzullo Changeset attached => SymmetricDS 3.15 00ac2e41
2024-05-10 13:20 pmarzullo Status assigned => resolved
2024-05-10 13:20 pmarzullo Resolution open => fixed
2024-05-10 13:20 pmarzullo Fixed in Version => 3.15.7
2024-05-10 13:20 pmarzullo Note Added: 0002447
2024-06-07 16:46 admin Status resolved => closed