Loading...

Details

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 1.9.7.Final, 2.0.0.Final
Affects Version/s: 1.9.3.Final
Component/s: oracle-connector
Labels:
None

Blocked:
False
Blocked Reason:
None
Ready:
False
Target Release:

2.0.GA

SFDC Cases Counter:
SFDC Cases Links:

Description

{"log":"[2022-06-20 07:05:32,542] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper)\n","stream":"stdout","time":"2022-06-20T07:05:32.544027755Z"}
{"log":"java.sql.SQLException: ORA-01289: cannot add duplicate logfile /app/idx2/myserver/onlinelog/redo01b.log\n","stream":"stdout","time":"2022-06-20T07:05:32.544061601Z"}
{"log":"ORA-06512: at \"SYS.DBMS_LOGMNR\", line 82\n","stream":"stdout","time":"2022-06-20T07:05:32.544067959Z"}
{"log":"ORA-06512: at line 1\n","stream":"stdout","time":"2022-06-20T07:05:32.544072475Z"}
{"log":"\n","stream":"stdout","time":"2022-06-20T07:05:32.544076589Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)\n","stream":"stdout","time":"2022-06-20T07:05:32.544092896Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)\n","stream":"stdout","time":"2022-06-20T07:05:32.544096506Z"}
{"log":"\u0009at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)\n","stream":"stdout","time":"2022-06-20T07:05:32.544101819Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)\n","stream":"stdout","time":"2022-06-20T07:05:32.54410478Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)\n","stream":"stdout","time":"2022-06-20T07:05:32.544107919Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)\n","stream":"stdout","time":"2022-06-20T07:05:32.544110721Z"}
{"log":"\u0009at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)\n","stream":"stdout","time":"2022-06-20T07:05:32.544113375Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)\n","stream":"stdout","time":"2022-06-20T07:05:32.544116096Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)\n","stream":"stdout","time":"2022-06-20T07:05:32.544131453Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)\n","stream":"stdout","time":"2022-06-20T07:05:32.544134347Z"}
{"log":"\u0009at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)\n","stream":"stdout","time":"2022-06-20T07:05:32.544136967Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)\n","stream":"stdout","time":"2022-06-20T07:05:32.544139613Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerHelper.executeCallableStatement(LogMinerHelper.java:217)\n","stream":"stdout","time":"2022-06-20T07:05:32.544142344Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerHelper.setLogFilesForMining(LogMinerHelper.java:87)\n","stream":"stdout","time":"2022-06-20T07:05:32.54414504Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.initializeRedoLogsForMining(LogMinerStreamingChangeEventSource.java:346)\n","stream":"stdout","time":"2022-06-20T07:05:32.544149979Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:198)\n","stream":"stdout","time":"2022-06-20T07:05:32.544154541Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:60)\n","stream":"stdout","time":"2022-06-20T07:05:32.544191097Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174)\n","stream":"stdout","time":"2022-06-20T07:05:32.544196696Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141)\n","stream":"stdout","time":"2022-06-20T07:05:32.544201754Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)\n","stream":"stdout","time":"2022-06-20T07:05:32.544206094Z"}
{"log":"\u0009at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n","stream":"stdout","time":"2022-06-20T07:05:32.544210106Z"}
{"log":"\u0009at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n","stream":"stdout","time":"2022-06-20T07:05:32.544212834Z"}
{"log":"\u0009at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n","stream":"stdout","time":"2022-06-20T07:05:32.544215469Z"}
{"log":"\u0009at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n","stream":"stdout","time":"2022-06-20T07:05:32.544218185Z"}
{"log":"\u0009at java.base/java.lang.Thread.run(Thread.java:829)\n","stream":"stdout","time":"2022-06-20T07:05:32.544220798Z"}
{"log":"Caused by: Error : 1289, Position : 0, Sql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME =\u003e '/app/idx2/myserver/onlinelog/redo01b.log', OPTIONS =\u003e DBMS_LOGMNR.ADDFILE);END;, OriginalSql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME =\u003e '/app/idx2/myserver/onlinelog/redo01b.log', OPTIONS =\u003e DBMS_LOGMNR.ADDFILE);END;, Error Msg = ORA-01289: cannot add duplicate logfile /app/idx2/myserver/onlinelog/redo01b.log\n","stream":"stdout","time":"2022-06-20T07:05:32.544223597Z"}
{"log":"ORA-06512: at \"SYS.DBMS_LOGMNR\", line 82\n","stream":"stdout","time":"2022-06-20T07:05:32.544227842Z"}
{"log":"ORA-06512: at line 1\n","stream":"stdout","time":"2022-06-20T07:05:32.544232571Z"}
{"log":"\n","stream":"stdout","time":"2022-06-20T07:05:32.54423673Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)\n","stream":"stdout","time":"2022-06-20T07:05:32.544240631Z"}
{"log":"\u0009... 27 more\n","stream":"stdout","time":"2022-06-20T07:05:32.544244782Z"}
{"log":"[2022-06-20 07:05:32,543] ERROR Producer failure (io.debezium.pipeline.ErrorHandler)\n","stream":"stdout","time":"2022-06-20T07:05:32.544306935Z"}
{"log":"java.sql.SQLException: ORA-01289: cannot add duplicate logfile /app/idx2/myserver/onlinelog/redo01b.log\n","stream":"stdout","time":"2022-06-20T07:05:32.544339201Z"}
{"log":"ORA-06512: at \"SYS.DBMS_LOGMNR\", line 82\n","stream":"stdout","time":"2022-06-20T07:05:32.544344478Z"}
{"log":"ORA-06512: at line 1\n","stream":"stdout","time":"2022-06-20T07:05:32.544348958Z"}
{"log":"\n","stream":"stdout","time":"2022-06-20T07:05:32.544352808Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)\n","stream":"stdout","time":"2022-06-20T07:05:32.544356536Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)\n","stream":"stdout","time":"2022-06-20T07:05:32.544360289Z"}
{"log":"\u0009at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)\n","stream":"stdout","time":"2022-06-20T07:05:32.544364087Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)\n","stream":"stdout","time":"2022-06-20T07:05:32.544367915Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)\n","stream":"stdout","time":"2022-06-20T07:05:32.544371891Z"}
{"log":"\u0009at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)\n","stream":"stdout","time":"2022-06-20T07:05:32.54437563Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)\n","stream":"stdout","time":"2022-06-20T07:05:32.544379674Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)\n","stream":"stdout","time":"2022-06-20T07:05:32.544383441Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)\n","stream":"stdout","time":"2022-06-20T07:05:32.544387115Z"}
{"log":"\u0009at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)\n","stream":"stdout","time":"2022-06-20T07:05:32.544390963Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)\n","stream":"stdout","time":"2022-06-20T07:05:32.54439504Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)\n","stream":"stdout","time":"2022-06-20T07:05:32.54439899Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)\n","stream":"stdout","time":"2022-06-20T07:05:32.544402584Z"}
{"log":"\u0009at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)\n","stream":"stdout","time":"2022-06-20T07:05:32.544406102Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)\n","stream":"stdout","time":"2022-06-20T07:05:32.54440995Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerHelper.executeCallableStatement(LogMinerHelper.java:217)\n","stream":"stdout","time":"2022-06-20T07:05:32.544414292Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerHelper.setLogFilesForMining(LogMinerHelper.java:87)\n","stream":"stdout","time":"2022-06-20T07:05:32.54441842Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.initializeRedoLogsForMining(LogMinerStreamingChangeEventSource.java:346)\n","stream":"stdout","time":"2022-06-20T07:05:32.544422583Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:198)\n","stream":"stdout","time":"2022-06-20T07:05:32.544426683Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:60)\n","stream":"stdout","time":"2022-06-20T07:05:32.544431763Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174)\n","stream":"stdout","time":"2022-06-20T07:05:32.544435861Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141)\n","stream":"stdout","time":"2022-06-20T07:05:32.544448508Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)\n","stream":"stdout","time":"2022-06-20T07:05:32.544452837Z"}
{"log":"\u0009at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n","stream":"stdout","time":"2022-06-20T07:05:32.544457043Z"}
{"log":"\u0009at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n","stream":"stdout","time":"2022-06-20T07:05:32.544460785Z"}
{"log":"\u0009at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n","stream":"stdout","time":"2022-06-20T07:05:32.544464562Z"}
{"log":"\u0009at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n","stream":"stdout","time":"2022-06-20T07:05:32.544468232Z"}
{"log":"\u0009at java.base/java.lang.Thread.run(Thread.java:829)\n","stream":"stdout","time":"2022-06-20T07:05:32.544471808Z"}
{"log":"Caused by: Error : 1289, Position : 0, Sql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME =\u003e '/app/idx2/myserver/onlinelog/redo01b.log', OPTIONS =\u003e DBMS_LOGMNR.ADDFILE);END;, OriginalSql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME =\u003e '/app/idx2/myserver/onlinelog/redo01b.log', OPTIONS =\u003e DBMS_LOGMNR.ADDFILE);END;, Error Msg = ORA-01289: cannot add duplicate logfile /app/idx2/myserver/onlinelog/redo01b.log\n","stream":"stdout","time":"2022-06-20T07:05:32.544475785Z"}
{"log":"ORA-06512: at \"SYS.DBMS_LOGMNR\", line 82\n","stream":"stdout","time":"2022-06-20T07:05:32.544480778Z"}
{"log":"ORA-06512: at line 1\n","stream":"stdout","time":"2022-06-20T07:05:32.544484463Z"}
{"log":"\n","stream":"stdout","time":"2022-06-20T07:05:32.544488244Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)\n","stream":"stdout","time":"2022-06-20T07:05:32.544491997Z"}
{"log":"\u0009... 27 more\n","stream":"stdout","time":"2022-06-20T07:05:32.544495999Z"}
{"log":"[2022-06-20 07:05:32,544] INFO startScn=524692465411, endScn=524692473731 (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource)\n","stream":"stdout","time":"2022-06-20T07:05:32.544526409Z"}
{"log":"[2022-06-20 07:05:32,544] INFO Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=524692473731, oldestScn=524692439388, committedScn=524692465406, offsetScn=524692439387, logMinerQueryCount=13290, totalProcessedRows=539627, totalCapturedDmlCount=163467, totalDurationOfFetchingQuery=PT1H7M51.122174S, lastCapturedDmlCount=109114, lastDurationOfFetchingQuery=PT1.639187S, maxCapturedDmlCount=109114, maxDurationOfFetchingQuery=PT7.452539S, totalBatchProcessingDuration=PT1H20M45.616976S, lastBatchProcessingDuration=PT24.790008S, maxBatchProcessingThroughput=4402, currentLogFileName=[/app/idx2/myserver/onlinelog/redo05b.log, /app/data2/myserver/onlinelog/redo05a.log], minLogFilesMined=2, maxLogFilesMined=2, redoLogStatus=[/app/data2/myserver/onlinelog/redo04a.log | ACTIVE, /app/idx2/myserver/onlinelog/redo04b.log | ACTIVE, /app/data2/myserver/onlinelog/redo05a.log | CURRENT, /app/idx2/myserver/onlinelog/redo05b.log | CURRENT, /app/idx2/myserver/onlinelog/redo01b.log | INACTIVE, /app/idx2/myserver/onlinelog/redo02b.log | INACTIVE, /app/data2/myserver/onlinelog/redo02a.log | INACTIVE, /app/idx2/myserver/onlinelog/redo03b.log | INACTIVE, /app/data2/myserver/onlinelog/redo01a.log | INACTIVE, /app/data2/myserver/onlinelog/redo03a.log | INACTIVE], switchCounter=7, batchSize=50000, millisecondToSleepBetweenMiningQuery=2800, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT8.353934S, totalStartLogMiningSessionDuration=PT2M26.910489S, lastStartLogMiningSessionDuration=PT0.044202S, maxStartLogMiningSessionDuration=PT1.256308S, totalProcessTime=PT1H20M45.616976S, minBatchProcessTime=PT0.060747S, maxBatchProcessTime=PT24.790008S, totalResultSetNextTime=PT20.298428S, lagFromTheSource=DurationPT25.075182S, maxLagFromTheSourceDuration=PT9H23M25.61245S, minLagFromTheSourceDuration=PT0.217739S, lastCommitDuration=PT0.000002S, maxCommitDuration=PT0.018156S, activeTransactions=12, rolledBackTransactions=641, committedTransactions=187408, abandonedTransactionIds={}, rolledbackTransactionIds={03001c003a3e2300=03001c003a3e2300, 210021004cb32600=210021004cb32600, 62001a0006a51800=62001a0006a51800, 5f000a001b181a00=5f000a001b181a00, 67002000d96f1600=67002000d96f1600, 3c00090046222b00=3c00090046222b00, 67002100016d1600=67002100016d1600, 02001f0026a32a00=02001f0026a32a00, 44001200de512800=44001200de512800, 3600070029ee1b00=3600070029ee1b00}, registeredDmlCount=163467, committedDmlCount=27, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=2097104, miningSessionUserGlobalAreaMaxMemory=4194208, miningSessionProcessGlobalAreaMemory=150452680, miningSessionProcessGlobalAreaMaxMemory=168999368} (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource)\n","stream":"stdout","time":"2022-06-20T07:05:32.544679942Z"}
{"log":"[2022-06-20 07:05:32,544] INFO Offsets: OracleOffsetContext [scn=524692439387, commit_scn=524692461962] (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource)\n","stream":"stdout","time":"2022-06-20T07:05:32.544700794Z"}
{"log":"[2022-06-20 07:05:32,544] INFO Finished streaming (io.debezium.pipeline.ChangeEventSourceCoordinator)\n","stream":"stdout","time":"2022-06-20T07:05:32.544705091Z"}
{"log":"[2022-06-20 07:05:32,544] INFO Connected metrics set to 'false' (io.debezium.pipeline.ChangeEventSourceCoordinator)\n","stream":"stdout","time":"2022-06-20T07:05:32.544749131Z"}
{"log":"[2022-06-20 07:05:32,770] INFO WorkerSourceTask{id=kafka-connect-src-01-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask)\n","stream":"stdout","time":"2022-06-20T07:05:32.77105528Z"}
{"log":"[2022-06-20 07:05:32,771] ERROR WorkerSourceTask{id=kafka-connect-src-01-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask)\n","stream":"stdout","time":"2022-06-20T07:05:32.771670338Z"}
{"log":"org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.\n","stream":"stdout","time":"2022-06-20T07:05:32.771688667Z"}
{"log":"\u0009at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:50)\n","stream":"stdout","time":"2022-06-20T07:05:32.771693647Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:222)\n","stream":"stdout","time":"2022-06-20T07:05:32.771698693Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:60)\n","stream":"stdout","time":"2022-06-20T07:05:32.771703338Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174)\n","stream":"stdout","time":"2022-06-20T07:05:32.771707739Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141)\n","stream":"stdout","time":"2022-06-20T07:05:32.771712072Z"}
{"log":"\u0009at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)\n","stream":"stdout","time":"2022-06-20T07:05:32.771715142Z"}
{"log":"\u0009at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n","stream":"stdout","time":"2022-06-20T07:05:32.771717913Z"}
{"log":"\u0009at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n","stream":"stdout","time":"2022-06-20T07:05:32.771720547Z"}
{"log":"\u0009at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n","stream":"stdout","time":"2022-06-20T07:05:32.771730692Z"}
{"log":"\u0009at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n","stream":"stdout","time":"2022-06-20T07:05:32.771733659Z"}
{"log":"\u0009at java.base/java.lang.Thread.run(Thread.java:829)\n","stream":"stdout","time":"2022-06-20T07:05:32.771736343Z"}
{"log":"Caused by: java.sql.SQLException: ORA-01289: cannot add duplicate logfile /app/idx2/myserver/onlinelog/redo01b.log\n","stream":"stdout","time":"2022-06-20T07:05:32.771739055Z"}
{"log":"ORA-06512: at \"SYS.DBMS_LOGMNR\", line 82\n","stream":"stdout","time":"2022-06-20T07:05:32.771741815Z"}
{"log":"ORA-06512: at line 1\n","stream":"stdout","time":"2022-06-20T07:05:32.771744631Z"}
{"log":"\n","stream":"stdout","time":"2022-06-20T07:05:32.771747166Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)\n","stream":"stdout","time":"2022-06-20T07:05:32.77174968Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)\n","stream":"stdout","time":"2022-06-20T07:05:32.771752497Z"}
{"log":"\u0009at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)\n","stream":"stdout","time":"2022-06-20T07:05:32.771755215Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)\n","stream":"stdout","time":"2022-06-20T07:05:32.771757851Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)\n","stream":"stdout","time":"2022-06-20T07:05:32.771760454Z"}
{"log":"\u0009at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)\n","stream":"stdout","time":"2022-06-20T07:05:32.771763048Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)\n","stream":"stdout","time":"2022-06-20T07:05:32.77176655Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)\n","stream":"stdout","time":"2022-06-20T07:05:32.771769318Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)\n","stream":"stdout","time":"2022-06-20T07:05:32.771771952Z"}
{"log":"\u0009at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)\n","stream":"stdout","time":"2022-06-20T07:05:32.771774658Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)\n","stream":"stdout","time":"2022-06-20T07:05:32.771777402Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)\n","stream":"stdout","time":"2022-06-20T07:05:32.771780834Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)\n","stream":"stdout","time":"2022-06-20T07:05:32.771785196Z"}
{"log":"\u0009at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)\n","stream":"stdout","time":"2022-06-20T07:05:32.771789441Z"}
{"log":"\u0009at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)\n","stream":"stdout","time":"2022-06-20T07:05:32.771793297Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerHelper.executeCallableStatement(LogMinerHelper.java:217)\n","stream":"stdout","time":"2022-06-20T07:05:32.771797691Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerHelper.setLogFilesForMining(LogMinerHelper.java:87)\n","stream":"stdout","time":"2022-06-20T07:05:32.771800548Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.initializeRedoLogsForMining(LogMinerStreamingChangeEventSource.java:346)\n","stream":"stdout","time":"2022-06-20T07:05:32.771803208Z"}
{"log":"\u0009at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:198)\n","stream":"stdout","time":"2022-06-20T07:05:32.771806016Z"}
{"log":"\u0009... 9 more\n","stream":"stdout","time":"2022-06-20T07:05:32.771808744Z"}
{"log":"Caused by: Error : 1289, Position : 0, Sql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME =\u003e '/app/idx2/myserver/onlinelog/redo01b.log', OPTIONS =\u003e DBMS_LOGMNR.ADDFILE);END;, OriginalSql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME =\u003e '/app/idx2/myserver/onlinelog/redo01b.log', OPTIONS =\u003e DBMS_LOGMNR.ADDFILE);END;, Error Msg = ORA-01289: cannot add duplicate logfile /app/idx2/myserver/onlinelog/redo01b.log\n","stream":"stdout","time":"2022-06-20T07:05:32.771813406Z"}
{"log":"ORA-06512: at \"SYS.DBMS_LOGMNR\", line 82\n","stream":"stdout","time":"2022-06-20T07:05:32.771817361Z"}
{"log":"ORA-06512: at line 1\n","stream":"stdout","time":"2022-06-20T07:05:32.771820018Z"}
{"log":"\n","stream":"stdout","time":"2022-06-20T07:05:32.77182257Z"}
{"log":"\u0009at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)\n","stream":"stdout","time":"2022-06-20T07:05:32.771825136Z"}
{"log":"\u0009... 27 more\n","stream":"stdout","time":"2022-06-20T07:05:32.771828839Z"}

cc ccranfor@redhat.com

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

archived_log_all_cols.xlsx
2022/06/21 3:01 PM
123 kB
toop toop
archived_log_some_cols_dailybkps.xlsx
2022/06/21 3:01 PM
46 kB
toop toop

ORA-01289: cannot add duplicate logfile

Details

Description

Attachments

Attachments

Activity

People

Dates