| Description | Each time a gap is detected we should select count(*) from sym_data where data_id > lastDataId and data_id < dataId to verify that data does not exist so we can officially call the gap a gap. We should also implement a method on the database dialect to check to see if there are pending transactions since before we made our initial routing query for data. If there are no pending transactions, then we can assume that the gap is a true gap and we can go ahead and skip it. On Oracle you can view pending transactions using the v$transaction view's start_time column. For RAC, the view is gv$transaction. Of course, for this feature to work the database id has to have access to the view. |
|---|