View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002942 | SymmetricDS | Improvement | public | 2016-12-14 19:57 | 2016-12-30 13:10 |
| Reporter | mmichalek | Assigned To | mmichalek | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.0 | ||||
| Target Version | 3.8.12 | Fixed in Version | 3.8.12 | ||
| Summary | 0002942: Make sym_data_gap regeneration more robust | ||||
| Description | In 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. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.8 494871eb 2016-12-14 16:27:33 Details Diff |
0002942: Make sym_data_gap regeneration more robust |
Affected Issues 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 | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-12-14 19:57 | mmichalek | New Issue | |
| 2016-12-14 19:57 | mmichalek | Status | new => assigned |
| 2016-12-14 19:57 | mmichalek | Assigned To | => mmichalek |
| 2016-12-14 21:32 | mmichalek | Status | assigned => resolved |
| 2016-12-14 21:32 | mmichalek | Resolution | open => fixed |
| 2016-12-14 21:32 | mmichalek | Fixed in Version | => 3.8.12 |
| 2016-12-14 22:00 | mmichalek | Changeset attached | => SymmetricDS 3.8 494871eb |
| 2016-12-30 13:10 | chenson | Status | resolved => closed |