[FLINK-35211] when synchronize LOB fields using oracle cdc, an error occurs

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Component/s: Flink CDC

Environment

Flink 18.1 

Oracle12c

Oracle cdc 3.0.1

• Assignee: Unassigned
• Reporter: wangsw
• Created: 23/Apr/24 01:54
• Updated: 23/Apr/24 05:08

Description

Caused by: java.sql.SQLException: ORA-01291: 缺失日志文件
ORA-06512: 在 "SYS.DBMS_LOGMNR", line 58
ORA-06512: 在 line 1oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823)
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778)
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303)
io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1446)
io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:677)
io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:244) 

when synchronize LOB fields using oracle cdc 3.0.1 , an error occurs. 

I checked that the debezium version of CDC is 1.9.7.Final. When I used the same version of debezium and the same configuration to synchronize LOB data, the error did not occur, so I am asking for help.

Please view flink sql in the attachment。

Without adding parameter 'debezium.lob.enabled' = 'true', the error does not occur.