__ ____ __ _____ ___ __ ____ ______ --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \ --\___\_\____/_/ |_/_/|_/_/|_|\____/___/ 2022-03-16 12:13:01,029 INFO [io.deb.ser.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$207/0x000000084023c840@e044b4a' stream name mapper 2022-03-16 12:13:01,193 INFO [io.deb.ser.pub.PubSubChangeConsumer] (main) Using default PublisherBuilder 'io.debezium.server.pubsub.PubSubChangeConsumer$$Lambda$217/0x0000000840266840@1e6308a9' 2022-03-16 12:13:01,194 INFO [io.deb.ser.DebeziumServer] (main) Consumer 'io.debezium.server.pubsub.PubSubChangeConsumer' instantiated 2022-03-16 12:13:01,316 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-03-16 12:13:01,321 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2022-03-16 12:13:01,336 INFO [io.deb.emb.EmbeddedEngine$EmbeddedConfig] (main) EmbeddedConfig values: access.control.allow.methods = access.control.allow.origin = admin.listeners = null bootstrap.servers = [localhost:9092] client.dns.lookup = use_all_dns_ips config.providers = [] connector.client.config.override.policy = All header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter key.converter = class org.apache.kafka.connect.json.JsonConverter listeners = [http://:8083] metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 offset.flush.interval.ms = 0 offset.flush.timeout.ms = 5000 offset.storage.file.filename = tempiposct2v19/offsets.dat offset.storage.partitions = null offset.storage.replication.factor = null offset.storage.topic = plugin.path = null response.http.headers.config = rest.advertised.host.name = null rest.advertised.listener = null rest.advertised.port = null rest.extension.classes = [] ssl.cipher.suites = null ssl.client.auth = none ssl.enabled.protocols = [TLSv1.2, TLSv1.3] ssl.endpoint.identification.algorithm = https ssl.engine.factory.class = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.certificate.chain = null ssl.keystore.key = null ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLSv1.3 ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.certificates = null ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS task.shutdown.graceful.timeout.ms = 5000 topic.creation.enable = true topic.tracking.allow.reset = true topic.tracking.enable = true value.converter = class org.apache.kafka.connect.json.JsonConverter 2022-03-16 12:13:01,336 WARN [org.apa.kaf.con.run.WorkerConfig] (main) The worker has been configured with one or more internal converter properties ([internal.key.converter, internal.value.converter]). Support for these properties was deprecated in version 2.0 and removed in version 3.0, and specifying them will have no effect. Instead, an instance of the JsonConverter with schemas.enable set to false will be used. For more information, please visit http://kafka.apache.org/documentation/#upgrade and consult the upgrade notesfor the 3.0 release. 2022-03-16 12:13:01,337 WARN [org.apa.kaf.con.run.WorkerConfig] (main) Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results. 2022-03-16 12:13:01,340 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-03-16 12:13:01,341 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-03-16 12:13:01,344 INFO [io.deb.ser.DebeziumServer] (main) Engine executor started 2022-03-16 12:13:01,362 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file tempiposct2v19/offsets.dat 2022-03-16 12:13:01,508 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:13:01,510 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:13:01,510 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v19/FileDatabaseHistory.dat 2022-03-16 12:13:01,510 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:13:01,511 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:13:01,511 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:13:01,511 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:13:01,511 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:13:01,511 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:13:01,511 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:13:01,512 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:13:01,512 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v19/offsets.dat 2022-03-16 12:13:01,512 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:13:01,512 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:13:01,512 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:13:01,512 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:13:01,513 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:13:01,513 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:13:01,513 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.PTY_IM 2022-03-16 12:13:01,513 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:13:01,513 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:13:01,513 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:13:01,513 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:13:01,637 INFO [io.quarkus] (main) debezium-server-dist 1.8.0.Final on JVM (powered by Quarkus 2.5.0.Final) started in 2.571s. Listening on: http://0.0.0.0:7071 2022-03-16 12:13:01,638 INFO [io.quarkus] (main) Profile prod activated. 2022-03-16 12:13:01,639 INFO [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health, vertx] 2022-03-16 12:13:02,805 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 12:13:03,019 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) No previous offsets found 2022-03-16 12:13:03,019 INFO [io.deb.con.ora.OracleConnectorTask] (pool-7-thread-1) Connector started for the first time, database history recovery will not be executed 2022-03-16 12:13:03,036 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 12:13:03,038 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:13:03,053 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:13:03,055 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:13:03,061 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) No previous offset has been found. 2022-03-16 12:13:03,061 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) According to the connector configuration both schema and data will be snapshot. 2022-03-16 12:13:03,061 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 1 - Preparing 2022-03-16 12:13:03,062 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 2 - Determining captured tables 2022-03-16 12:13:14,514 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 3 - Locking captured tables [AMCTPRD.TOS_USR.PTY_IM] 2022-03-16 12:13:14,567 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 4 - Determining snapshot offset 2022-03-16 12:13:14,796 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) No latest table SCN could be resolved, defaulting to current SCN 2022-03-16 12:13:14,832 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 5 - Reading structure of captured tables 2022-03-16 12:13:24,243 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 6 - Persisting schema history 2022-03-16 12:13:27,920 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 7 - Snapshotting data 2022-03-16 12:13:27,922 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshotting contents of 1 tables while still in transaction 2022-03-16 12:13:27,922 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exporting data from table 'AMCTPRD.TOS_USR.PTY_IM' (1 of 1 tables) 2022-03-16 12:13:27,926 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) For table 'AMCTPRD.TOS_USR.PTY_IM' using select statement: 'SELECT "ID", "VERSION", "CMPNY_CD", "PTY_CD", "SHIPPING_AGENT_FLG", "CTR_OPR_FLG", "FRWDR_AGENT_FLG", "CONSHIP_FLG", "HAUL_FLG", "CASH_PTY_FLG", "SEND_EDI_FLG", "DEL_FLG", "INT_EXT_USER_IND", "CRG_AGENT_FLG", "STVDR_FLG", "CSNR_FLG", "SEND_EMAIL_FLG", "SEND_FAX_FLG", "PTY_NM", "ADDR_1", "ADDR_2", "ADDR_3", "ADDR_4", "TEL_NO", "PO_BOX", "FAX_NO", "MOBILE_NO", "EMAIL_ADDR", "CONTACT_PRSN_NM", "CRNCY_CD", "LN_RMRK", "EDI_PTY_CD", "BANK_ACCNT_NO", "BANK_NM", "BANK_EMAIL_ADDR", "BANK_GURANTEE", "DOC_REF_NO", "DOC_S_RMRK", "CRDT_LIMIT", "CRDT_TERM_CD", "CRDT_TERM", "DOC_EXPIRY_DATE", "ADT_INS_DTTM", "ADT_UPD_DTTM", "CSTM_FLG", "MAIN_PTY_CD", "LINE_FLG", "PTY_CLR", "PTY_RESIDENCE_IND", "PTY_ACCT_CD", "TEL_NO_2", "CNTCT_PRSN_NM", "SAP_ACCT_CD", "MARK_DOC_VLDTY_FLG", "INVC_RQRD_FLG", "ADT_VER_STAMP", "ADT_INS_USR_CD", "ADT_UPD_USR_CD", "ADT_FUNCTION_CD", "ADT_MODULE_CD", "ADT_INS_USER_NM", "ADT_UPD_USER_NM", "ADT_TXN_CD", "ADT_TXN_NO", "ADT_INS_EXT_USR_FLG", "ADT_UPD_EXT_USR_FLG", "RFR_CONTRCTR_ID", "RAIL_OPR_FLG", "LOCL_AGENT_FLG", "DEPOT_OPR_FLG", "BANK_CD", "RENTAL_PTY_FLG", "OTH_EMAIL_ADDR", "PAN_NO", "TAN_NO", "SRV_TAX_EXMPT_FLG", "CMPNY_ADDR_1", "CMPNY_ADDR_2", "CMPNY_ADDR_3", "CMPNY_ADDR_4", "CMPNY_PO_BOX", "FINANCIAL_PTY_CD", "PCS_PTY_CD", "PCS_SNDR_CD", "NOTIFY_PTY_FLG", "BASE_STS_SEPARATE_FLG", "FE_IND_SEPARATE_FLG", "PO_BOX_ZIP", "PO_BOX_STATE", "PO_BOX_CITY", "L_RMRK", "CRG_HNDL_INVC_IND", "PYMNT_MODE", "CHECK_LIMIT", "STATE", "COUNTRY", "CMPNY_STATE", "CMPNY_COUNTRY", "LEGAL_ENTITY", "CNTRY_CD", "CMPNY_CNTRY_CD", "MISCPTY_HAULIER_FLG", "SEZ_FLG", "PTY_TYPE", "GSTIN", "GST_STATE_CD", "COMPETITOR_FLG", "LOCL_AGENT_CD", "PD_PTY_FLG", "EXTRA_ADDR", "VAT_CNTRY_CD", "VAT_COUNTRY" FROM "TOS_USR"."PTY_IM" AS OF SCN 126217329847' 2022-03-16 12:13:28,095 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 1 records sent during previous 00:00:26.707, last recorded offset: {snapshot=true, scn=126217329847, snapshot_completed=false} 2022-03-16 12:13:36,590 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 2048 records sent during previous 00:00:08.495, last recorded offset: {snapshot=true, scn=126217329847, snapshot_completed=false} 2022-03-16 12:13:36,591 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished exporting 18456 records for table 'AMCTPRD.TOS_USR.PTY_IM'; total duration '00:00:08.669' 2022-03-16 12:13:36,615 INFO [io.deb.pip.sou.AbstractSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot - Final stage 2022-03-16 12:13:36,616 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=126217329847]] 2022-03-16 12:13:36,622 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:13:36,624 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming ANTLR Tool version 4.8 used for code generation does not match the current runtime version 4.9.2 ANTLR Runtime version 4.8 used for parser compilation does not match the current runtime version 4.9.2 ANTLR Tool version 4.8 used for code generation does not match the current runtime version 4.9.2 ANTLR Runtime version 4.8 used for parser compilation does not match the current runtime version 4.9.2 2022-03-16 12:14:56,974 ERROR [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Got exception when starting mining session.: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217342796', endScn => '126217351467', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217342796', endScn => '126217351467', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:14:56,977 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Mining session stopped due to the {}: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217342796', endScn => '126217351467', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217342796', endScn => '126217351467', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:14:56,977 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Producer failure: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217342796', endScn => '126217351467', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217342796', endScn => '126217351467', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:14:56,978 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126217342796, endScn=126217351467 2022-03-16 12:14:56,978 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126217351467, oldestScn=126217342793, committedScn=126217342796, offsetScn=126217329847, logMinerQueryCount=1, totalProcessedRows=4125, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT7.170441S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT7.170441S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT7.170441S, totalBatchProcessingDuration=PT1M0.231891S, lastBatchProcessingDuration=PT1M0.231891S, maxBatchProcessingThroughput=0, currentLogFileName=[+FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | CURRENT], switchCounter=1430, batchSize=20000, millisecondToSleepBetweenMiningQuery=1400, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT33.54583S, lastStartLogMiningSessionDuration=PT33.54583S, maxStartLogMiningSessionDuration=PT33.54583S, totalProcessTime=PT1M0.231891S, minBatchProcessTime=PT1M0.231891S, maxBatchProcessTime=PT1M0.231891S, totalResultSetNextTime=PT0.000839S, lagFromTheSource=DurationPT1M9.044638S, maxLagFromTheSourceDuration=PT1M39.592007S, minLagFromTheSourceDuration=PT1M9.044047S, lastCommitDuration=PT0.000003S, maxCommitDuration=PT0S, activeTransactions=1, rolledBackTransactions=0, committedTransactions=2044, abandonedTransactionIds=[], rolledbackTransactionIds=[], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=13852784, miningSessionUserGlobalAreaMaxMemory=25762544, miningSessionProcessGlobalAreaMemory=47001704, miningSessionProcessGlobalAreaMaxMemory=47001704} 2022-03-16 12:14:56,979 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126217342792] 2022-03-16 12:14:56,979 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 12:14:56,979 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 12:14:57,252 WARN [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 2022-03-16 12:14:57,287 INFO [io.deb.jdb.JdbcConnection] (pool-11-thread-1) Connection gracefully closed 2022-03-16 12:14:57,290 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Retrieable exception thrown, connector will be restarted: org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:38) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) ... 9 more Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217342796', endScn => '126217351467', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217342796', endScn => '126217351467', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:14:57,291 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:14:59,291 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:15:01,292 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:15:03,292 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:15:05,293 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:15:07,294 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v19/FileDatabaseHistory.dat 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:15:07,295 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v19/offsets.dat 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.PTY_IM 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:15:07,296 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:15:07,666 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 12:15:07,704 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126217329847] 2022-03-16 12:15:07,705 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 12:15:07,727 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 21 ms 2022-03-16 12:15:07,731 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 12:15:07,731 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:15:07,733 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:15:07,733 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:15:07,733 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 12:15:07,734 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126217329847]] 2022-03-16 12:15:07,734 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:15:07,734 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 2022-03-16 12:16:40,176 ERROR [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Got exception when starting mining session.: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217392845', endScn => '126217408454', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217392845', endScn => '126217408454', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:16:40,177 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Mining session stopped due to the {}: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217392845', endScn => '126217408454', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217392845', endScn => '126217408454', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:16:40,177 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Producer failure: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217392845', endScn => '126217408454', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217392845', endScn => '126217408454', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:16:40,178 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126217392845, endScn=126217408454 2022-03-16 12:16:40,179 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126217408454, oldestScn=126217391827, committedScn=126217392845, offsetScn=126217347618, logMinerQueryCount=3, totalProcessedRows=27941, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT23.032709S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT4.472209S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT13.720029S, totalBatchProcessingDuration=PT1M10.977665S, lastBatchProcessingDuration=PT7.396941S, maxBatchProcessingThroughput=0, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | CURRENT], switchCounter=1442, batchSize=22000, millisecondToSleepBetweenMiningQuery=600, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT34.317192S, lastStartLogMiningSessionDuration=PT0.042426S, maxStartLogMiningSessionDuration=PT34.223329S, totalProcessTime=PT1M10.977665S, minBatchProcessTime=PT7.396941S, maxBatchProcessTime=PT55.489111S, totalResultSetNextTime=PT3.862412S, lagFromTheSource=DurationPT1M46.108936S, maxLagFromTheSourceDuration=PT3M7.189794S, minLagFromTheSourceDuration=PT1M46.108333S, lastCommitDuration=PT0.000002S, maxCommitDuration=PT0S, activeTransactions=1, rolledBackTransactions=37, committedTransactions=13782, abandonedTransactionIds=[], rolledbackTransactionIds=[1a001c00728b2100, 1b000700a2f61800, 090000008af44a00, 04002100fca12200, 29000200827f0000, 0800110031144300, 02001400a9e84000, 25000700b5d10100, 09001e00f1f34a00, 28001c00549b0000, 0700200082d43800, 1d00020083b10e00, 0100060078fc4500, 2600170007550100, 0300110009fe3900, 09001d00c4f34a00, 13001500b0452d00, 05000a00b0a22b00, 2600120007550100, 0900070077f34a00, 0800180024144300, 2700020018d30000, 240020002e300400, 1d0013003eb10e00, 1c000800fc581000, 29000900867f0000, 0900190063f44a00, 03001300b2fd3900, 0400080012a22200, 0900060079f34a00, 09000100eaf34a00, 1b000b0043f71800, 0900040082f44a00, 05001500bca22b00, 070004005ad43800, 1a001b00968b2100, 1a000f00998b2100], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=7733168, miningSessionUserGlobalAreaMaxMemory=18158016, miningSessionProcessGlobalAreaMemory=36008712, miningSessionProcessGlobalAreaMaxMemory=36008712} 2022-03-16 12:16:40,179 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126217391826] 2022-03-16 12:16:40,179 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 12:16:40,179 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 12:16:40,417 WARN [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 2022-03-16 12:16:40,443 INFO [io.deb.jdb.JdbcConnection] (pool-12-thread-1) Connection gracefully closed 2022-03-16 12:16:40,444 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Retrieable exception thrown, connector will be restarted: org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:38) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) ... 9 more Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217392845', endScn => '126217408454', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217392845', endScn => '126217408454', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:16:40,445 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:16:42,446 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:16:44,446 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:16:46,447 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:16:48,447 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:16:50,449 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:16:50,449 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:16:50,449 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v19/FileDatabaseHistory.dat 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:16:50,450 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v19/offsets.dat 2022-03-16 12:16:50,451 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:16:50,451 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:16:50,451 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:16:50,451 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:16:50,451 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:16:50,451 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:16:50,451 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.PTY_IM 2022-03-16 12:16:50,451 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:16:50,452 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:16:50,452 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:16:50,452 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:16:50,765 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 12:16:50,797 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126217329847] 2022-03-16 12:16:50,797 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 12:16:50,808 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 10 ms 2022-03-16 12:16:50,811 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 12:16:50,811 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:16:50,812 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:16:50,812 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:16:50,813 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 12:16:50,813 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126217329847]] 2022-03-16 12:16:50,813 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:16:50,813 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 2022-03-16 12:19:10,609 ERROR [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Got exception when starting mining session.: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217464840', endScn => '126217471382', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217464840', endScn => '126217471382', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:19:10,610 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Mining session stopped due to the {}: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217464840', endScn => '126217471382', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217464840', endScn => '126217471382', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:19:10,610 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Producer failure: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217464840', endScn => '126217471382', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217464840', endScn => '126217471382', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:19:10,610 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126217464840, endScn=126217471382 2022-03-16 12:19:10,611 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126217471382, oldestScn=-1, committedScn=126217464840, offsetScn=126217439845, logMinerQueryCount=6, totalProcessedRows=60668, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT49.819569S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT7.879279S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT13.92014S, totalBatchProcessingDuration=PT1M56.08804S, lastBatchProcessingDuration=PT8.494793S, maxBatchProcessingThroughput=0, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | CURRENT], switchCounter=1453, batchSize=25000, millisecondToSleepBetweenMiningQuery=200, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT35.01096S, lastStartLogMiningSessionDuration=PT0.045406S, maxStartLogMiningSessionDuration=PT34.764669S, totalProcessTime=PT1M56.08804S, minBatchProcessTime=PT6.280784S, maxBatchProcessTime=PT1M9.803685S, totalResultSetNextTime=PT7.901105S, lagFromTheSource=DurationPT2M4.980516S, maxLagFromTheSourceDuration=PT5M6.362651S, minLagFromTheSourceDuration=PT2M4.980293S, lastCommitDuration=PT0.000001S, maxCommitDuration=PT0S, activeTransactions=0, rolledBackTransactions=77, committedTransactions=29939, abandonedTransactionIds=[], rolledbackTransactionIds=[1b000700a2f61800, 090000008af44a00, 04002100fca12200, 0900130033f44a00, 090008005df44a00, 28001200569b0000, 09001200eef34a00, 09000b0018f54a00, 0800110031144300, 01001c00bafb4500, 25001f00c1d10100, 07001e00ead43800, 09001e00f1f34a00, 28001c00549b0000, 0100060078fc4500, 0300110009fe3900, 26001e000c550100, 280020005e9b0000, 13001500b0452d00, 05000a00b0a22b00, 2600120007550100, 02000c0052e94000, 12001600493d2e00, 0900190063f44a00, 03001300b2fd3900, 1d000e0057b10e00, 03000d009cfd3900, 05000f00d7a22b00, 07000000bed43800, 0900060079f34a00, 09000100eaf34a00, 1b000b0043f71800, 0900040082f44a00, 05001500bca22b00, 09000d002ff44a00, 09000600ccf34a00, 11001b007e6c2f00, 09000f002cf44a00, 07000f0053d53800, 1a001c00728b2100, 09000700caf34a00, 29000200827f0000, 1a0006008f8b2100, 02001400a9e84000, 080004005b144300, 25000700b5d10100, 0700130095d43800, 0700200082d43800, 09000a00caf44a00, 1d00020083b10e00, 0600010096f13400, 28000c005a9b0000, 2600170007550100, 1b00080008f71800, 04001c0023a22200, 09001d00c4f34a00, 0900070077f34a00, 0800180024144300, 2700020018d30000, 230006009d600900, 240020002e300400, 1d0013003eb10e00, 1c000800fc581000, 08001600c7134300, 1c001000a7581000, 0900080083f44a00, 29000900867f0000, 29000400997f0000, 09001600a0f44a00, 1d001d0079b10e00, 0400080012a22200, 1d00180059b10e00, 0d000500323c2900, 070004005ad43800, 1a001b00968b2100, 1a000f00998b2100, 290015009e7f0000], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=7735728, miningSessionUserGlobalAreaMaxMemory=18160320, miningSessionProcessGlobalAreaMemory=35074152, miningSessionProcessGlobalAreaMaxMemory=35074152} 2022-03-16 12:19:10,611 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126217464840] 2022-03-16 12:19:10,611 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 12:19:10,611 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 12:19:11,094 WARN [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 2022-03-16 12:19:11,126 INFO [io.deb.jdb.JdbcConnection] (pool-13-thread-1) Connection gracefully closed 2022-03-16 12:19:11,126 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Retrieable exception thrown, connector will be restarted: org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:38) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) ... 9 more Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217464840', endScn => '126217471382', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217464840', endScn => '126217471382', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:19:11,128 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:19:13,128 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:19:15,129 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:19:17,129 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:19:19,130 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v19/FileDatabaseHistory.dat 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:19:21,132 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v19/offsets.dat 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.PTY_IM 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:19:21,133 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:19:21,450 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 12:19:21,480 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126217329847] 2022-03-16 12:19:21,480 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 12:19:21,484 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 3 ms 2022-03-16 12:19:21,488 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 12:19:21,488 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:19:21,489 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:19:21,489 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:19:21,489 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 12:19:21,489 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126217329847]] 2022-03-16 12:19:21,489 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:19:21,489 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 2022-03-16 12:23:58,771 INFO [io.deb.con.ora.OracleStreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The connector is now using the maximum batch size 100000 when querying the LogMiner view. This could be indicative of large SCN gaps 2022-03-16 12:24:00,478 INFO [io.deb.con.ora.OracleStreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The connector is now using the maximum batch size 100000 when querying the LogMiner view. This could be indicative of large SCN gaps 2022-03-16 12:24:00,614 ERROR [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Got exception when starting mining session.: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126217941279', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126217941279', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:24:00,614 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Mining session stopped due to the {}: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126217941279', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126217941279', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:24:00,614 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Producer failure: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126217941279', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126217941279', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:24:00,615 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126217564572, endScn=126217941279 2022-03-16 12:24:00,615 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126217941279, oldestScn=126217564566, committedScn=126217564567, offsetScn=126217545831, logMinerQueryCount=81, totalProcessedRows=109921, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT1M34.767608S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT0.226069S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT14.680104S, totalBatchProcessingDuration=PT4M0.118764S, lastBatchProcessingDuration=PT0.632406S, maxBatchProcessingThroughput=0, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | CURRENT], switchCounter=1471, batchSize=100000, millisecondToSleepBetweenMiningQuery=0, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT1M5.962519S, lastStartLogMiningSessionDuration=PT0.041272S, maxStartLogMiningSessionDuration=PT32.695783S, totalProcessTime=PT4M0.118764S, minBatchProcessTime=PT0.574934S, maxBatchProcessTime=PT55.404271S, totalResultSetNextTime=PT25.120159S, lagFromTheSource=DurationPT3M0.59942S, maxLagFromTheSourceDuration=PT7M22.518674S, minLagFromTheSourceDuration=PT2M59.45142S, lastCommitDuration=PT0S, maxCommitDuration=PT0.007516S, activeTransactions=2, rolledBackTransactions=214, committedTransactions=54187, abandonedTransactionIds=[], rolledbackTransactionIds=[0400140068a22200, 090000008af44a00, 0900130033f44a00, 09001200eef34a00, 0800110031144300, 27001d002bd30000, 07001e00ead43800, 0900160050f54a00, 05001500d8a22b00, 0900060086f44a00, 28001c00549b0000, 2700080031d30000, 24000a0061300400, 280020005e9b0000, 0900120093f44a00, 0600100070f23400, 14000000c7833100, 09000100eef44a00, 0900120098f44a00, 01001e0069fc4500, 08001c0067144300, 0900190063f44a00, 09000a0088f54a00, 29000300ba7f0000, 0400180004a22200, 07000000bed43800, 0700090073d53800, 07000f0053d53800, 09000700caf34a00, 29000200827f0000, 07000c002cd53800, 1c000a00a1581000, 2600200018550100, 29001f00b27f0000, 01000b00f9fc4500, 09000a00caf44a00, 1d00020083b10e00, 28000c005a9b0000, 1c000a0097581000, 240018006e300400, 0900100041f54a00, 04001c0023a22200, 020002003fe94000, 01001d00edfc4500, 1a0002009d8b2100, 09000200c4f54a00, 1c000800fc581000, 08001600c7134300, 29000900867f0000, 23000f00a9600900, 09001600a0f44a00, 09000c00a6f44a00, 070004005ad43800, 1a001b00968b2100, 280012006a9b0000, 29000800bd7f0000, 0600210060f23400, 0900070088f44a00, 29001a00bb7f0000, 1b000700a2f61800, 28001200569b0000, 090020008cf54a00, 09000d008cf44a00, 0700140066d53800, 09001e00f1f34a00, 26000b001a550100, 25002100d5d10100, 08001f0016144300, 070006009cd53800, 1b0003002af71800, 0100060078fc4500, 0300110009fe3900, 1d000a0092b10e00, 13001500b0452d00, 1a0002008d8b2100, 06001e0045f23400, 09000500fef44a00, 25000a00dbd10100, 08001200f2134300, 0900060079f34a00, 0100010084fc4500, 1b000b0043f71800, 09000d002ff44a00, 23001500ba600900, 29000700a47f0000, 11001b007e6c2f00, 23000500b5600900, 02001400a9e84000, 070006009dd53800, 25000700b5d10100, 09001b0080f54a00, 0900090091f54a00, 0900130015f54a00, 0700200082d43800, 0600010096f13400, 040020007ea22200, 0600020078f23400, 06000b004df13400, 020002004fe94000, 1a000500388b2100, 230006009d600900, 1d001d0079b10e00, 02001800bfe84000, 1d00180059b10e00, 0d000500323c2900, 0900190073f54a00, 23000c00cf600900, 090008005df44a00, 05001800c9a22b00, 09000b0018f54a00, 25001f00c1d10100, 0100110063fc4500, 0200150092e94000, 2600120007550100, 0900040031f54a00, 0400000043a22200, 02000c0052e94000, 03001300b2fd3900, 03000d009cfd3900, 2400190060300400, 04001d001aa22200, 05000f00d7a22b00, 25000600c9d10100, 1a001f00548b2100, 09000100eaf34a00, 0900040082f44a00, 09000600ccf34a00, 1c000b000f591000, 03001200cbfd3900, 28000f00719b0000, 09000e00eaf44a00, 1a0006008f8b2100, 1d00070082b10e00, 080004005b144300, 06001c0031f23400, 23001c0076600900, 1b0017000af71800, 260020001a550100, 1b00200035f71800, 14000800ae833100, 06000600e3f13400, 020013001ee94000, 240020002e300400, 2700200032d30000, 07000e0063d53800, 010011005dfc4500, 0900080083f44a00, 1c000500e9581000, 29000400997f0000, 0900130090f44a00, 0400080012a22200, 01001b0098fc4500, 1a0007009c8b2100, 01000500bbfc4500, 01000e0099fc4500, 23001000a8600900, 0100020076fc4500, 08001a00e9124300, 1a000f00998b2100, 29000700b47f0000, 04002100fca12200, 29001800b07f0000, 0100030030fd4500, 09001d00d5f44a00, 01001c00bafb4500, 01000500b9fc4500, 1d0019003db10e00, 03000700e7fd3900, 2700090030d30000, 26001e000c550100, 09001400b9f44a00, 05000a00b0a22b00, 0600030096f13400, 080011005b144300, 12001600493d2e00, 09001700eaf44a00, 1d000e0057b10e00, 08001500fc134300, 03002100fdfd3900, 09001b007bf54a00, 05001500bca22b00, 05001f001fa32b00, 25001400d2d10100, 09000300ddf44a00, 090018006ef54a00, 09000f002cf44a00, 0900020064f54a00, 1a001c00728b2100, 090016005ef54a00, 280010006f9b0000, 080019005f134300, 23001f00a4600900, 240015005e300400, 05001e00e2a22b00, 28001600649b0000, 0700130095d43800, 29000c00c07f0000, 29001300c07f0000, 2600170007550100, 1b00080008f71800, 0900200079f54a00, 09001d00c4f34a00, 1d0018006cb10e00, 09000900c9f54a00, 0900070077f34a00, 0800180024144300, 25000e00d3d10100, 2700020018d30000, 1d0013003eb10e00, 2700210038d30000, 1c001000a7581000, 090011008af44a00, 09001500f2f44a00, 290015009e7f0000], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=7997304, miningSessionUserGlobalAreaMaxMemory=19927480, miningSessionProcessGlobalAreaMemory=76361832, miningSessionProcessGlobalAreaMaxMemory=76361832} 2022-03-16 12:24:00,615 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126217564565] 2022-03-16 12:24:00,615 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 12:24:00,615 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 12:24:01,055 WARN [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 2022-03-16 12:24:01,081 INFO [io.deb.jdb.JdbcConnection] (pool-14-thread-1) Connection gracefully closed 2022-03-16 12:24:01,082 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Retrieable exception thrown, connector will be restarted: org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:38) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) ... 9 more Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126217941279', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126217941279', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:24:01,083 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:24:03,083 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:24:05,084 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:24:07,085 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:24:09,086 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:24:11,087 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v19/FileDatabaseHistory.dat 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:24:11,089 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v19/offsets.dat 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.PTY_IM 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:24:11,090 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:24:11,440 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 12:24:11,469 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126217329847] 2022-03-16 12:24:11,469 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 12:24:11,474 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 5 ms 2022-03-16 12:24:11,479 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 12:24:11,479 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:24:11,480 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:24:11,480 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:24:11,481 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 12:24:11,481 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126217329847]] 2022-03-16 12:24:11,481 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:24:11,481 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 2022-03-16 12:28:54,787 INFO [io.deb.con.ora.OracleStreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The connector is now using the maximum batch size 100000 when querying the LogMiner view. This could be indicative of large SCN gaps 2022-03-16 12:28:57,103 INFO [io.deb.con.ora.OracleStreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The connector is now using the maximum batch size 100000 when querying the LogMiner view. This could be indicative of large SCN gaps 2022-03-16 12:28:57,260 ERROR [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Got exception when starting mining session.: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126218101160', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126218101160', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:28:57,261 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Mining session stopped due to the {}: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126218101160', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126218101160', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:28:57,261 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Producer failure: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126218101160', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126218101160', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:28:57,261 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126217564572, endScn=126218101160 2022-03-16 12:28:57,261 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126218101160, oldestScn=126217564566, committedScn=126217564567, offsetScn=126217545831, logMinerQueryCount=81, totalProcessedRows=109921, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT1M32.342419S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT0.211294S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT13.494409S, totalBatchProcessingDuration=PT4M7.653016S, lastBatchProcessingDuration=PT0.624759S, maxBatchProcessingThroughput=0, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | CURRENT], switchCounter=1489, batchSize=100000, millisecondToSleepBetweenMiningQuery=0, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT1M7.278638S, lastStartLogMiningSessionDuration=PT0.040663S, maxStartLogMiningSessionDuration=PT34.231241S, totalProcessTime=PT4M7.653016S, minBatchProcessTime=PT0.614S, maxBatchProcessTime=PT1M3.497196S, totalResultSetNextTime=PT24.258817S, lagFromTheSource=DurationPT7M50.621141S, maxLagFromTheSourceDuration=PT12M15.702802S, minLagFromTheSourceDuration=PT7M2.78268S, lastCommitDuration=PT0S, maxCommitDuration=PT0.006894S, activeTransactions=2, rolledBackTransactions=214, committedTransactions=54187, abandonedTransactionIds=[], rolledbackTransactionIds=[0400140068a22200, 090000008af44a00, 0900130033f44a00, 09001200eef34a00, 0800110031144300, 27001d002bd30000, 07001e00ead43800, 0900160050f54a00, 05001500d8a22b00, 0900060086f44a00, 28001c00549b0000, 2700080031d30000, 24000a0061300400, 280020005e9b0000, 0900120093f44a00, 0600100070f23400, 14000000c7833100, 09000100eef44a00, 0900120098f44a00, 01001e0069fc4500, 08001c0067144300, 0900190063f44a00, 09000a0088f54a00, 29000300ba7f0000, 0400180004a22200, 07000000bed43800, 0700090073d53800, 07000f0053d53800, 09000700caf34a00, 29000200827f0000, 07000c002cd53800, 1c000a00a1581000, 2600200018550100, 29001f00b27f0000, 01000b00f9fc4500, 09000a00caf44a00, 1d00020083b10e00, 28000c005a9b0000, 1c000a0097581000, 240018006e300400, 0900100041f54a00, 04001c0023a22200, 020002003fe94000, 01001d00edfc4500, 1a0002009d8b2100, 09000200c4f54a00, 1c000800fc581000, 08001600c7134300, 29000900867f0000, 23000f00a9600900, 09001600a0f44a00, 09000c00a6f44a00, 070004005ad43800, 1a001b00968b2100, 280012006a9b0000, 29000800bd7f0000, 0600210060f23400, 0900070088f44a00, 29001a00bb7f0000, 1b000700a2f61800, 28001200569b0000, 090020008cf54a00, 09000d008cf44a00, 0700140066d53800, 09001e00f1f34a00, 26000b001a550100, 25002100d5d10100, 08001f0016144300, 070006009cd53800, 1b0003002af71800, 0100060078fc4500, 0300110009fe3900, 1d000a0092b10e00, 13001500b0452d00, 1a0002008d8b2100, 06001e0045f23400, 09000500fef44a00, 25000a00dbd10100, 08001200f2134300, 0900060079f34a00, 0100010084fc4500, 1b000b0043f71800, 09000d002ff44a00, 23001500ba600900, 29000700a47f0000, 11001b007e6c2f00, 23000500b5600900, 02001400a9e84000, 070006009dd53800, 25000700b5d10100, 09001b0080f54a00, 0900090091f54a00, 0900130015f54a00, 0700200082d43800, 0600010096f13400, 040020007ea22200, 0600020078f23400, 06000b004df13400, 020002004fe94000, 1a000500388b2100, 230006009d600900, 1d001d0079b10e00, 02001800bfe84000, 1d00180059b10e00, 0d000500323c2900, 0900190073f54a00, 23000c00cf600900, 090008005df44a00, 05001800c9a22b00, 09000b0018f54a00, 25001f00c1d10100, 0100110063fc4500, 0200150092e94000, 2600120007550100, 0900040031f54a00, 0400000043a22200, 02000c0052e94000, 03001300b2fd3900, 03000d009cfd3900, 2400190060300400, 04001d001aa22200, 05000f00d7a22b00, 25000600c9d10100, 1a001f00548b2100, 09000100eaf34a00, 0900040082f44a00, 09000600ccf34a00, 1c000b000f591000, 03001200cbfd3900, 28000f00719b0000, 09000e00eaf44a00, 1a0006008f8b2100, 1d00070082b10e00, 080004005b144300, 06001c0031f23400, 23001c0076600900, 1b0017000af71800, 260020001a550100, 1b00200035f71800, 14000800ae833100, 06000600e3f13400, 020013001ee94000, 240020002e300400, 2700200032d30000, 07000e0063d53800, 010011005dfc4500, 0900080083f44a00, 1c000500e9581000, 29000400997f0000, 0900130090f44a00, 0400080012a22200, 01001b0098fc4500, 1a0007009c8b2100, 01000500bbfc4500, 01000e0099fc4500, 23001000a8600900, 0100020076fc4500, 08001a00e9124300, 1a000f00998b2100, 29000700b47f0000, 04002100fca12200, 29001800b07f0000, 0100030030fd4500, 09001d00d5f44a00, 01001c00bafb4500, 01000500b9fc4500, 1d0019003db10e00, 03000700e7fd3900, 2700090030d30000, 26001e000c550100, 09001400b9f44a00, 05000a00b0a22b00, 0600030096f13400, 080011005b144300, 12001600493d2e00, 09001700eaf44a00, 1d000e0057b10e00, 08001500fc134300, 03002100fdfd3900, 09001b007bf54a00, 05001500bca22b00, 05001f001fa32b00, 25001400d2d10100, 09000300ddf44a00, 090018006ef54a00, 09000f002cf44a00, 0900020064f54a00, 1a001c00728b2100, 090016005ef54a00, 280010006f9b0000, 080019005f134300, 23001f00a4600900, 240015005e300400, 05001e00e2a22b00, 28001600649b0000, 0700130095d43800, 29000c00c07f0000, 29001300c07f0000, 2600170007550100, 1b00080008f71800, 0900200079f54a00, 09001d00c4f34a00, 1d0018006cb10e00, 09000900c9f54a00, 0900070077f34a00, 0800180024144300, 25000e00d3d10100, 2700020018d30000, 1d0013003eb10e00, 2700210038d30000, 1c001000a7581000, 090011008af44a00, 09001500f2f44a00, 290015009e7f0000], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=7996728, miningSessionUserGlobalAreaMaxMemory=19927184, miningSessionProcessGlobalAreaMemory=78672648, miningSessionProcessGlobalAreaMaxMemory=78672648} 2022-03-16 12:28:57,261 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126217564565] 2022-03-16 12:28:57,261 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 12:28:57,262 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 12:28:57,549 WARN [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 2022-03-16 12:28:57,584 INFO [io.deb.jdb.JdbcConnection] (pool-15-thread-1) Connection gracefully closed 2022-03-16 12:28:57,585 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Retrieable exception thrown, connector will be restarted: org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:38) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1411) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:408) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:167) ... 9 more Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126218101160', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126217564572', endScn => '126218101160', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 24 more 2022-03-16 12:28:57,588 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:28:59,588 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:29:01,589 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:29:03,589 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:29:05,590 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:29:07,591 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:29:07,591 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:29:07,591 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v19/FileDatabaseHistory.dat 2022-03-16 12:29:07,591 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:29:07,591 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:29:07,591 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v19/offsets.dat 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.PTY_IM 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:29:07,592 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:29:07,914 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 2022-03-16 12:29:07,940 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126217329847] 2022-03-16 12:29:07,940 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 12:29:07,943 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 3 ms 2022-03-16 12:29:07,946 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 2022-03-16 12:29:07,947 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:29:07,948 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:29:07,948 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:29:07,948 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 12:29:07,948 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126217329847]] 2022-03-16 12:29:07,949 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:29:07,949 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming