View Issue Details

IDProjectCategoryView StatusLast Update
0002942SymmetricDSImprovementpublic2016-12-30 08:10
ReportermmichalekAssigned Tommichalek 
PrioritynormalSeverityminorReproducibilitysometimes
Status closedResolutionfixed 
Product Version3.8.0 
Target Version3.8.12Fixed in Version3.8.12 
Summary0002942: Make sym_data_gap regeneration more robust
DescriptionIn some situations where a node has invalid entries in sym_data_gap, it is fair to truncate that table and let SymmetricDS regenerate the entries as needed. It's possible that data_id's in sym_data are out of range from sym_data_event at that point, and also out of range from the default starting data gap (0..50000000).

This change will consider both the maximum data_id in sym_data_event and the minimum data_id in sym_data when generating the new, initial data_gap.

For a concrete example, we saw a situation where the min(data_id) of sym_data was over 79439130, plus there were no entries in sym_data_event in this case. When truncating sym_data_gap in that case, it was regenerated with the default 0..50000000, and was too low to see the actual data in the sym_data table. Manual intervention was required to update the gap to start at the minimum data_id of sym_data.

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 494871eb

2016-12-14 16:27:33

mmichalek

Details Diff
0002942: Make sym_data_gap regeneration more robust
0002942
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataServiceSqlMap.java Diff File

Issue History

Date Modified Username Field Change
2016-12-14 14:57 mmichalek New Issue
2016-12-14 14:57 mmichalek Status new => assigned
2016-12-14 14:57 mmichalek Assigned To => mmichalek
2016-12-14 16:32 mmichalek Status assigned => resolved
2016-12-14 16:32 mmichalek Resolution open => fixed
2016-12-14 16:32 mmichalek Fixed in Version => 3.8.12
2016-12-14 17:00 mmichalek Changeset attached => SymmetricDS 3.8 494871eb
2016-12-30 08:10 chenson Status resolved => closed