View Issue Details

IDProjectCategoryView StatusLast Update
0006871SymmetricDSImprovementpublic2025-06-08 01:07
Reporteremiller Assigned Toemiller  
Priorityhigh 
Status closedResolutionfixed 
Product Version3.16.0 
Target Version3.16.3Fixed in Version3.16.3 
Summary0006871: Skip purging inactive trigger histories still referenced by sym_data (Purge Incoming job)
DescriptionCurrently, the Purge Incoming job purges all inactive trigger histories that are older than the time specified by the purge.trigger.hist.retention.minutes parameter.
This can cause problems if a row exists in sym_data that corresponds with one of these trigger histories (and it gets purged).

Instead, the Purge Incoming job should only purge inactive trigger histories that are older than the oldest create_time in sym_data.
Tagspurge, trigger

Activities

emiller

2025-05-06 17:42

developer   ~0002943

PR: https://github.com/JumpMind/symmetric-ds/pull/270

pbelov

2025-05-09 18:02

manager   ~0002953

Merged PR: https://github.com/JumpMind/symmetric-ds/pull/270

pbelov

2025-06-08 01:07

manager   ~0003037

Included in the 3.16.3 release

Related Changesets

SymmetricDS: 3.16 9f3b6b64

2025-05-09 18:02:02

evan-miller-jumpmind


Committer: GitHub Details Diff
0006871: Skip purging inactive trigger histories still referenced by sym_data (Purge Incoming job) (0000270)

* 0006871: Skip purging inactive trigger histories still referenced by sym_data (Purge Incoming job)
Affected Issues
0006871
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

Issue History

Date Modified Username Field Change
2025-05-06 15:33 emiller New Issue
2025-05-06 15:33 emiller Status new => assigned
2025-05-06 15:33 emiller Assigned To => emiller
2025-05-06 15:33 emiller Tag Attached: purge
2025-05-06 15:33 emiller Tag Attached: trigger
2025-05-06 17:42 emiller Note Added: 0002943
2025-05-09 18:02 pbelov Status assigned => resolved
2025-05-09 18:02 pbelov Resolution open => fixed
2025-05-09 18:02 pbelov Fixed in Version => 3.16.3
2025-05-09 18:02 pbelov Summary Make the Purge Incoming job only purge inactive trigger histories that are older than the oldest create_time in sym_data => Skip purging inactive trigger histories still referenced by sym_data (Purge Incoming job)
2025-05-09 18:02 pbelov Description Updated View Revisions
2025-05-09 18:02 pbelov Note Added: 0002953
2025-05-09 19:00 Changeset attached => SymmetricDS 3.16 9f3b6b64
2025-06-08 01:07 pbelov Note Added: 0003037
2025-06-08 01:07 pbelov Status resolved => closed