View Issue Details

IDProjectCategoryView StatusLast Update
0006971SymmetricDSImprovementpublic2025-08-07 15:49
Reportercquamme Assigned Tocquamme  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.16.0 
Target Version3.16.5Fixed in Version3.16.5 
Summary0006971: Preserve one week of stats in the sym_console_table_stats and sym_node_host_stats tables
DescriptionPreserve at least one week of stats in the sym_console_table_stats and sym_node_host_stats tables.
Having these tables purged aggressively makes support snapshot useless for troubleshooting issues.
The purge behavior is controlled by the purge.stats.retention.minutes parameter. Current default is 10 days.
New minimum values it 10080 minutes (7 days).
Steps To ReproduceIn one case, parameter purge.stats.retention.minutes was set to just 1 hour impacting usefulness of the support snapshot (especially the summary report).
TagsNo tags attached.

Activities

pbelov

2025-08-07 15:49

manager   ~0003306

Included in the 3.16.5 release

Related Changesets

SymmetricDS: 3.16 49ee4d1c

2025-07-14 14:48:02

catherinequamme


Committer: GitHub Details Diff
0006971: Prevent aggressive purging of the sym_console_table_stats and sym_node_host_stats table (#310)

* 0006971: Prevent aggressive purging of the sym_console_table_stats, sym_node_host_stats
* Plus unit test class minimum for the purge stats parameter and added limiter to 2 other methods.
Affected Issues
0006971
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File
mod - symmetric-core/src/test/java/org/jumpmind/symmetric/service/impl/PurgeServiceTest.java Diff File

Issue History

Date Modified Username Field Change
2025-06-23 12:40 cquamme New Issue
2025-06-23 12:40 cquamme Status new => assigned
2025-06-23 12:40 cquamme Assigned To => cquamme
2025-06-23 13:06 cquamme Status assigned => acknowledged
2025-06-23 13:15 cquamme Additional Information Updated View Revisions
2025-06-23 14:32 cquamme Additional Information Updated View Revisions
2025-06-23 14:45 cquamme Status acknowledged => confirmed
2025-06-30 13:35 cquamme Summary Prevent agressive purging of the sym_console_table_stats and sym_node_host_stats table => Prevent aggressive purging of the sym_console_table_stats and sym_node_host_stats table
2025-07-01 15:13 pbelov Priority normal => high
2025-07-01 15:13 pbelov Steps to Reproduce Updated View Revisions
2025-07-01 15:16 pbelov Target Version 3.16.4 => 3.16.5
2025-07-07 12:47 cquamme Steps to Reproduce Updated View Revisions
2025-07-07 12:47 cquamme Additional Information Updated View Revisions
2025-07-07 17:24 cquamme Description Updated View Revisions
2025-07-07 17:37 cquamme Priority high => normal
2025-07-14 14:48 pbelov Status confirmed => resolved
2025-07-14 14:48 pbelov Fixed in Version => 3.16.5
2025-07-14 15:00 Changeset attached => SymmetricDS 3.16 49ee4d1c
2025-07-14 15:04 pbelov Summary Prevent aggressive purging of the sym_console_table_stats and sym_node_host_stats table => Preserve one week of stats in the sym_console_table_stats and sym_node_host_stats tables
2025-07-14 15:04 pbelov Description Updated View Revisions
2025-07-14 15:04 pbelov Steps to Reproduce Updated View Revisions
2025-07-14 15:04 pbelov Additional Information Updated View Revisions
2025-08-07 15:49 pbelov Note Added: 0003306
2025-08-07 15:49 pbelov Status resolved => closed