首页 > 数据库 >oracle错误记录

oracle错误记录

时间:2024-03-26 11:49:16浏览次数:27  
标签:flink java 错误 记录 cdc connector oracle 2.4

2024-03-26 08:15:08,530 INFO  org.apache.flink.kafka.shaded.org.apache.kafka.common.metrics.Metrics [] - Metrics reporters closed 2024-03-26 08:15:08,531 INFO  org.apache.flink.kafka.shaded.org.apache.kafka.common.utils.AppInfoParser [] - App info kafka.producer for producer-112 unregistered 2024-03-26 08:15:08,531 INFO  org.apache.flink.connector.base.source.reader.SourceReaderBase [] - Closing Source Reader. 2024-03-26 08:15:08,531 INFO  org.apache.flink.connector.base.source.reader.fetcher.SplitFetcher [] - Shutting down split fetcher 0 2024-03-26 08:15:08,698 INFO  com.ververica.cdc.connectors.base.source.reader.IncrementalSourceSplitReader [] - Close current fetcher com.ververica.cdc.connectors.base.source.reader.external.IncrementalSourceStreamFetcher 2024-03-26 08:15:08,804 INFO  io.debezium.jdbc.JdbcConnection                              [] - Connection gracefully closed 2024-03-26 08:15:08,863 ERROR io.debezium.connector.oracle.logminer.LogMinerHelper         [] - Mining session stopped due to the java.sql.SQLException: ORA-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
2024-03-26 08:15:08,863 ERROR io.debezium.pipeline.ErrorHandler                            [] - Producer failure java.sql.SQLException: ORA-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:193) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:247) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at com.ververica.cdc.connectors.oracle.source.reader.fetch.OracleStreamFetchTask$RedoLogSplitReadTask.execute(OracleStreamFetchTask.java:134) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at com.ververica.cdc.connectors.oracle.source.reader.fetch.OracleStreamFetchTask.execute(OracleStreamFetchTask.java:72) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at com.ververica.cdc.connectors.base.source.reader.external.IncrementalSourceStreamFetcher.lambda$submitTask$0(IncrementalSourceStreamFetcher.java:89) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]     at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]     at java.lang.Thread.run(Thread.java:834) [?:?] Caused by: oracle.jdbc.OracleDatabaseException: ORA-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[flink-sql-connector-oracle-cdc-2.4.1.jar:2.4.1]     ... 24 more 2024-03-26 08:15:08,864 INFO  io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource [] - startScn=3425138973, endScn=3425141574

标签:flink,java,错误,记录,cdc,connector,oracle,2.4
From: https://www.cnblogs.com/zjb480/p/18096274

相关文章

  • 笔试错题记录
    一、Linux相关1.Linux删除变量的命令——unset       二、MySQL1.各种类型的索引全文索引效率低下,只适合模糊搜索;  2.MySQL中的枚举类型                  三、设计模式 1.浏览器的事件模型使用了哪种设......
  • Centos 7.8 安装Oracle 19.3指南
    原文出处:https://zhuanlan.zhihu.com/p/670286778?安装环境java-versionopenjdkversion"1.8.0_242"OpenJDKRuntimeEnvironment(build1.8.0_242-b08)OpenJDK64-BitServerVM(build25.242-b08,mixedmode)cat/etc/centos-releaseCentOSLinuxrelease......
  • ORACLE 在缺少主键ID的情况下删除重复数据,只保留一行
    有时候因未进行数据验证或其他特殊场景,导致数据表中出现重复的数据,需要对重复数据进行删除,并且只保留其中一条。一、当数据表存在主键时,可使用ROW_NUMBER进行排序后删除,参考脚本如下:  删除带有主键的重复数据DELETEFROMDUPLICATES_TABLEWHEREIDIN(SELECTID......
  • Oracle与MySQL的差异和对比
    Oracle与MySQL的差异和对比:配套hands-on参考脚本。方便客户针对培训课件内容进行动手实践,加强理解。-----------------------------------主题:Oracle与MySQL的差异和对比--一、MySQL的基础特性--二、重要特性差异对比--三、性能对比和优化技巧--------------......
  • 一些好用的小众软件记录
    1.电脑(Windows):搜索:everythingPDF阅读:SumatraPDF录屏生成gif:screentogif视频播放器:vlcRSS广播订阅:vlc网页视频下载:neatdownloadmanager密码管理:keepassSQLite可视化:dbbrowserSQL工具:dbeaver2.手机(安卓)广播:podcastgoPDF阅读:readera综......
  • Blazor学习记录五_组件生命周期_____
    15.组件生成周期,已由ComponentBase默认实现1.设置参数前SetParameterAsync2.初始化OnInitialized/OnInitializedAsync3.设置参数后OnParameterSet/OnParameterAsync4.通知组件渲染StateHasChanged5.组件渲染呈现后OnAfterRender/OnRenderAsync6.组件删除前DisPose......
  • pve 下的群晖虚拟机硬盘空间扩容的记录
    pve下,105号群晖虚拟机,btrfs系统,sata硬盘。虚拟机容量硬盘130G,扩展至140G,还需要命令行和网页存储管理器界面操作,以实现扩容的目的。df-hFilesystemSizeUsedAvailUse%Mountedon/dev/md07.9G1.8G6.0G23%/devtmpfs......
  • Debian配置记录
    找到了官方的debian12镜像,安装配置采用nat模式(学校网络不支持虚拟机桥接),第一次装失败,选择了桥接模式,无法启动DHCP配置第二次装失败,原因是安装最后一步选择了不将GRUB启动引导器安装到主引导记录上,安装完成启动只剩黑屏上一个光标。第二次选择安装位置为/dev/sda安装成功过程中......
  • vue自定义指令及常用自定义指令#记录
    一、什么是自定义指令在vue官方文档中是这样描述的,自定义指令主要是为了重用涉及普通元素的底层DOM访问的逻辑。自定义指令主要分为全局自定义指令和局部自定义指令。二、自定义指令相关参数Vue2.X钩子函数:bind:自定义指令绑定到DOM后调用。只调用一次,指令第一次绑定到元素......
  • vue2和vue3的主要区别#记录
    一、 vue2和vue3的区别1、vue2和vue3双向数据绑定原理发生了改变vue2 的双向数据绑定是利用ES5的一个API Object.definePropert()对数据进行劫持结合发布订阅模式的方式来实现的。vue3 中使用了es6的 ProxyAPI对数据代理。相比于vue2.x,使用proxy的优势如下de......