|Anonymous | Login | Signup for a new account|
|My View | View Issues | Change Log | Roadmap | Summary | Ranking | Repositories|
|View Issue Details|
|ID||Project||Category||Date Submitted||Last Update|
|0002942||SymmetricDS||Improvement||2016-12-14 14:57||2016-12-30 08:10|
|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.
|Issue Community Support|
This issue is already marked as resolved.
If you feel that is not the case, please reopen it and explain why.
|Supporters:||No one explicitly supports this issue yet.|
|Opponents:||No one explicitly opposes this issue yet.|
SymmetricDS: 3.8 494871eb
Timestamp: 2016-12-14 16:27:33
|0002942: Make sym_data_gap regeneration more robust|
|mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java|
|mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataServiceSqlMap.java|
|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|