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.