我在使用flinkcdc-2.4.2采集oracle19c的过程中,遇到这个问题,大家有遇到过的吗?Caused by: io.debezium.DebeziumException: Oracle failed to re-construct redo SQL 'delete from "SMESPROD"."TBLVEHICLEPRDRELATION" where "COL 1" = HEXTORAW('0056003300320033003100320030003300300032') and "COL 2" = HEXTORAW('0033002d00310030002d0030002d0030003500360033') and "COL 3" = HEXTORAW('0037006300640032003000320036003400620061006600360038006200380037') and "COL 4" IS NULL and "COL 5" = HEXTORAW('0031002d0031') and "COL 6" = HEXTORAW('30') and "COL 7" IS NULL and "COL 8" IS NULL and "COL 9" = HEXTORAW('00580030003000320030002d00300032') and "COL 10" = HEXTORAW('787b0719131013') and "COL 11" IS NULL and "COL 12" = HEXTORAW('77640101010101') and "COL 13" = HEXTORAW('003100300030003000300039003100380038') and "COL 14" = HEXTORAW('0051') and "COL 15" IS NULL and "COL 16" IS NULL and "COL 17" = HEXTORAW('00410030003900340030');'
at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleDataEvent(AbstractLogMinerEventProcessor.java:806) ~[ocean-1.0-jar-with-dependencies.jar:?]
at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:321) ~[ocean-1.0-jar-with-dependencies.jar:?]
at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:262) ~[ocean-1.0-jar-with-dependencies.jar:?]
at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:198) ~[ocean-1.0-jar-with-dependencies.jar:?]
at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:247) ~[ocean-1.0-jar-with-dependencies.jar:?]
... 9 more
https://issues.redhat.com/browse/DBZ-5215?jql=text%20~%20%22failed%20to%20re-construct%20redo%20SQL%22 可以看一下这个issue,不接受truncate信息即可, CDC有配置信息 ,此回答整理自钉群“Flink CDC 社区”
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
实时计算Flink版是阿里云提供的全托管Serverless Flink云服务,基于 Apache Flink 构建的企业级、高性能实时大数据处理系统。提供全托管版 Flink 集群和引擎,提高作业开发运维效率。