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

[wangsw (Jira)]

wangsw created FLINK-35211:
------------------------------

             Summary: when synchronize LOB fields using oracle cdc, an error 
occurs
                 Key: FLINK-35211
                 URL: https://issues.apache.org/jira/browse/FLINK-35211
             Project: Flink
          Issue Type: Bug
          Components: Flink CDC
         Environment: Flink 18.1 

Oracle cdc 3.0.1
            Reporter: wangsw
         Attachments: cdcOracleToPrint.sql

{code:java}
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)
 {code}
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.

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)