debezium / debezium/dbz

LogFileCollector exception is misleading when Oracle ARC is slow to archive

Open
#2,601 0 comments 0 reactions 1 assignee Claimed by @Naros View on GitHub
component/oracle-connector type/bug
Dominant language
HTML
Stars
6
Forks
8
Avg merge
2d 19h
Merged PRs (30d)
1

Description

When the Oracle ARC process is slow to archive a log, this often leads to the message:

> None of the log files contain offset SCN: , re-snapshot is required.

We recently fixed the _deleted log_ use case in #1532; however, we did not update the last exception message to provide more context on why the log could not be found, since the goal of #1532 was to differentiate deleted logs from missing ones.

I propose the log message to shift to:

> None of the log files contain offset SCN: after {} attempts. This could be due to a slow archiver process in the database. Please consider raising {} (the default is {}) if this continues. If a connector restart does not eventually solve the issue, and the expected log can no longer be resolved, a re-snapshot is required.

This informs the user that we retried X times, directs them to the internal property to increase it if the issue persists, and notes that a re-snapshot might be required if the issue persists because a log file is in an unexpected (non-deleted) state.

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.