streamingccl: stream ingestion job should have retry mechanism before pausing on error and during cancelation #83450
Description
Stream ingestion job should retry ingesting after retry-able error either relying on job system retry or retry by itself and should retry clearing ranges when being canceled.
Jira issue: CRDB-17075
Epic CRDB-10147