View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006871 | SymmetricDS | Improvement | public | 2025-05-06 15:33 | 2025-06-08 01:07 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.16.0 | ||||
| Target Version | 3.16.3 | Fixed in Version | 3.16.3 | ||
| Summary | 0006871: Skip purging inactive trigger histories still referenced by sym_data (Purge Incoming job) | ||||
| Description | Currently, 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. | ||||
| Tags | purge, trigger | ||||
|
|
PR: https://github.com/JumpMind/symmetric-ds/pull/270 |
|
|
Merged PR: https://github.com/JumpMind/symmetric-ds/pull/270 |
|
|
Included in the 3.16.3 release |
|
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 | ||
| 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 |