-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
None
-
False
I am using debezuim-oracle-connector 1.9.7-final with oracle 19c but the same error Exception ORA-00310 always occurs again and again every few days .
The jdbc version is ojdbc8.jar.
I have seen same issue in DBZ-4230 and the issue was fixed by version 1.7.2-final, I don`t understand why it still coccurs in a new version 1.9.7-final?
The config file of the connector is:
{ "connector.class":"io.debezium.connector.oracle.OracleConnector", "tasks.max": "1", "database.server.name": "", "database.hostname": "", "database.port": "1521", "database.user": "", "database.password": "", "database.dbname": "mes", "table.include.list": "table1,table2", "database.history.kafka.bootstrap.servers": "", "database.history.kafka.topic": "topic", "decimal.handling.mode": "string", "log.mining.strategy": "online_catalog", "snapshot.mode": "schema_only", "database.history.store.only.captured.tables.ddl": "true", "database.history.skip.unparseable.ddl": "true" }
The Exception log is:
[2022-12-21 06:03:46,784] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:117)java.sql.SQLException: ORA-00310: archived log contains sequence 35415; sequence 35413 requiredORA-00334: archived log: '+MES01/MES/redo01.log' at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:185) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:210) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:60) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)Caused by: Error : 310, Position : 0, Sql = SELECT SCN, SQL_REDO, OPERATION_CODE, TIMESTAMP, XID, , Error Msg = ORA-00310: archived log contains sequence 35415; sequence 35413 requiredORA-00334: archived log: '+MES01/MES/redo01.log' at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ... 25 more[2022-12-21 06:03:46,785] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:35)java.sql.SQLException: ORA-00310: archived log contains sequence 35415; sequence 35413 requiredORA-00334: archived log: '+MES01/MES/redo01.log' at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:185) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:210) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:60) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)Caused by: Error : 310, Position : 0, Sql = SELECT SCN, SQL_REDO, OPERATION_CODE, TIMESTAMP, XID, Error Msg = ORA-00310: archived log contains sequence 35415; sequence 35413 requiredORA-00334: archived log: '+MES01/MES/redo01.log' at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ... 25 more[2022-12-21 06:03:46,785] INFO startScn=16948153037, endScn=16948169336 (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:225)[2022-12-21 06:03:46,785] INFO Connected metrics set to 'false' (io.debezium.pipeline.ChangeEventSourceCoordinator:236)[2022-12-21 06:03:47,083] WARN Going to restart connector after 10 sec. after a retriable exception (io.debezium.connector.common.BaseSourceTask:240)[2022-12-21 06:03:47,140] INFO Connection gracefully closed (io.debezium.jdbc.JdbcConnection:962)[2022-12-21 06:03:47,140] INFO [Producer clientId=ordos-dbhistory] Closing the Kafka producer with timeoutMillis = 30000 ms. (org.apache.kafka.clients.producer.KafkaProducer:1139)[2022-12-21 06:03:47,143] ERROR WorkerSourceTask{id=ordos_bat_wip_cell4-0} Task threw an uncaught and unrecoverable exception (org.apache.kaf: