[FLINK-34780] [Bug] Oracle cdc repeatedly consumes snapshot data and does not consume binlog data

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Flink CDC
• Labels: github-import
• Assignee: Unassigned
• Reporter: Flink CDC Issue Import
• Created: 20/Mar/24 09:20
• Updated: 20/Mar/24 09:20

Description

1. 1. 1. Search before asking

• [X] I searched in the [issues|https://github.com/ververica/flink-cdc-connectors/issues) and found nothing similar.

1. 1. 1. Flink version

1.13.5

1. 1. 1. Flink CDC version

2.1.1

1. 1. 1. Database and its version

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
and
Non-CDB

1. 1. 1. Minimal reproduce step

I follow the steps on the official website (https://ververica.github.io/flink-cdc-connectors/release-2.1/content/connectors/oracle-cdc.html], everything is ok

1. 1. 1. What did you expect to see?

I expect the oracle cdc consume snapshot data only once and continus consume binlog data

1. 1. 1. What did you see instead?

when I consume the oracle data with flink sql client, it return all null value, when I consume the oracle data with datastream api ,it consumes snapshot data repeatedly and does not consume binlog data, what happened?

1. 1. 1. Anything else?

no

1. 1. 1. Are you willing to submit a PR?

• [ ] I'm willing to submit a PR!

---------------- Imported from GitHub ----------------
Url: https://github.com/apache/flink-cdc/issues/1982
Created by: GeniusTian
Labels: bug,
Created at: Fri Mar 10 17:58:35 CST 2023
State: open