debezium / debezium/dbz

Restart LOB mining based on the oldest LOB-based transaction in cache, not oldest transaction in cache. [DBZ-7894]

Open
#1,288 0 comments 0 reactions 0 assignees View on GitHub
component/oracle-connector migrated-from-jira type/enhancement
Dominant language
HTML
Stars
6
Forks
8
Avg merge
2d 19h
Merged PRs (30d)
1

Description

Migrated from [DBZ-7894](https://issues.redhat.com/browse/DBZ-7894)

h2. Which use case/requirement will be addressed by the proposed feature?

 

In the method *MemoryLogMinerEventProcessor#calculateNewStartScn:

 

That LOB is enabled and the transaction cache is empty indicates that the last mining session did not capture any START event between the last startSCN and the last endSCN. So we can begin the next mining session from where we left off just like the way that the LOB is disabled rather than the maxCommittedScn. If we use the maxCommittedScn, the maxCommittedScn could _remain unchanged for a long period of time in the case of not capturing any event_ {_}for a long period of time, which increases the possibility of "{_}ORA-01291: _missing log file"._ 

 

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.