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)