Rahul Kumar created PHOENIX-8059:
------------------------------------

             Summary: PhoenixSyncTableTool fails when --to-time is older than 
max lookback
                 Key: PHOENIX-8059
                 URL: https://issues.apache.org/jira/browse/PHOENIX-8059
             Project: Phoenix
          Issue Type: Improvement
    Affects Versions: 5.2.3, 5.4.0, 5.3.3
            Reporter: Rahul Kumar
            Assignee: Rahul Kumar
             Fix For: 5.2.3, 5.4.0, 5.3.3


Description:

{{PhoenixSyncTableTool}} fails during query plan generation when {{--to-time}} 
is older than the Phoenix max lookback age. The tool sets the current SCN to 
{{endTime}} ({{{}PhoenixConfigurationUtil.setCurrentScnValue(configuration, 
endTime){}}}). A scan at that SCN is rejected once {{endTime}} falls outside 
the lookback window.

The intended run uses {{--from-time 0}} and {{--to-time}} of about one hour 
ago. If a job runs for several days and has to be re-run, that same {{endTime}} 
is often past max lookback, and the tool should still be able to scan that 
range.

Change

Stop setting the current SCN to {{endTime}} in 
{{{}PhoenixSyncTableTool.setPhoenixSyncTableToolConfiguration{}}}. Time bounds 
stay on the scan via {{--from-time}} / {{{}--to-time{}}}.

Test

{{PhoenixSyncTableToolIT.testSyncTableSucceedsWhenEndTimeOlderThanMaxLookbackAge}}
 lowers max lookback to 5 seconds, waits until {{toTime}} is outside that 
window, and checks that the tool exits 0 and the sync counters match.



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

Reply via email to