View Revisions: Issue #952
|Summary||0000952: Data can be skipped due to aggressive purge on some platforms|
|Revision||2012-12-12 20:46 by chenson|
|Description||MySQL uses the max data_id as the next data_id.
If rows 5,6,7,8,9,10 are purged and the next data_id was going to be 11, sym_data_gap would have a gap of 11 to 50,000. The next data_id inserted will be 5 because 5-10 have been purged. data_ids 5-10 will never be routed.
Maybe the solution is to never purge the last data_id?
|Revision||2012-12-12 20:34 by chenson|
|Description||Some database platforms (mysql) will insert data_ids that are one greater than the last. Bad for combo of purge and data_gap.
Never purge the last data_id.