15:16:07 WARN [io.qu.ru.co.ConfigRecorder] (main) Build time property cannot be changed at runtime: - quarkus.log.min-level was 'DEBUG' at build time and is now 'TRACE' 15:16:08 INFO [io.de.se.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$211/0x0000000840239040@538cd0f2' stream name mapper 15:16:08 INFO [io.de.se.pu.PubSubChangeConsumer] (main) Using default PublisherBuilder 'io.debezium.server.pubsub.PubSubChangeConsumer$$Lambda$221/0x000000084025d840@2b97cc1f' 15:16:08 INFO [io.de.se.DebeziumServer] (main) Consumer 'io.debezium.server.pubsub.PubSubChangeConsumer' instantiated 15:16:08 INFO [or.ap.ka.co.js.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 15:16:08 INFO [or.ap.ka.co.js.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 15:16:08 INFO [io.de.em.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 = tempiposct2v72/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 15:16:08 WARN [or.ap.ka.co.ru.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. 15:16:08 WARN [or.ap.ka.co.ru.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. 15:16:08 INFO [or.ap.ka.co.js.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 15:16:08 INFO [or.ap.ka.co.js.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 15:16:08 INFO [io.de.se.DebeziumServer] (main) Engine executor started 15:16:08 INFO [or.ap.ka.co.st.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file tempiposct2v72/offsets.dat 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v72/FileDatabaseHistory.dat 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.user = ******* 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.dbname = ******* 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.server.name = ******* 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.port = 1521 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v72/offsets.dat 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.hostname = ******* 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.password = ******** 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) name = pubsub 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.PTY_IM 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 15:16:08 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 15:16:08 INFO [io.quarkus] (main) debezium-server-dist 1.8.0.Final on JVM (powered by Quarkus 2.5.0.Final) started in 2.899s. Listening on: http://0.0.0.0:7071 15:16:08 INFO [io.quarkus] (main) Profile prod activated. 15:16:08 INFO [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health, vertx] 15:16:09 INFO [io.de.co.or.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 15:16:10 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) No previous offsets found 15:16:10 INFO [io.de.co.or.OracleConnectorTask] (pool-7-thread-1) Connector started for the first time, database history recovery will not be executed 15:16:10 INFO [io.de.ut.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 15:16:10 INFO [io.de.ut.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 15:16:10 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 15:16:10 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 15:16:10 INFO [io.de.co.or.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) No previous offset has been found. 15:16:10 INFO [io.de.co.or.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) According to the connector configuration both schema and data will be snapshot. 15:16:10 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 1 - Preparing 15:16:10 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 2 - Determining captured tables 15:16:23 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 3 - Locking captured tables [AMCTPRD.TOS_USR.PTY_IM] 15:16:23 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 4 - Determining snapshot offset 15:16:23 INFO [io.de.co.or.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) No latest table SCN could be resolved, defaulting to current SCN 15:16:23 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 5 - Reading structure of captured tables 15:16:34 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 6 - Persisting schema history 15:16:37 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 7 - Snapshotting data 15:16:37 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshotting contents of 1 tables while still in transaction 15:16:37 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exporting data from table 'AMCTPRD.TOS_USR.PTY_IM' (1 of 1 tables) 15:16:37 INFO [io.de.re.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 126394469503' 15:16:37 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) 334 records sent during previous 00:00:29.269, last recorded offset: {snapshot=true, scn=126394469503, snapshot_completed=false} 15:16:44 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) 2048 records sent during previous 00:00:06.295, last recorded offset: {snapshot=true, scn=126394469503, snapshot_completed=false} 15:16:45 INFO [io.de.re.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished exporting 18465 records for table 'AMCTPRD.TOS_USR.PTY_IM'; total duration '00:00:08.515' 15:16:46 INFO [io.de.pi.so.AbstractSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot - Final stage 15:16:46 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=126394469503]] 15:16:46 INFO [io.de.pi.me.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 15:16:46 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 15:16:46 WARN [io.de.co.or.lo.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting SCN 126394469503 is not yet in archive logs, waiting for archive log switch. 15:17:55 INFO [io.de.co.or.lo.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting SCN 126394469503 is now available in archive logs, log mining unpaused. 15:19:12 ERROR [io.de.co.or.lo.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 => '126394489500', endScn => '126394509123', 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 => '126394489500', endScn => '126394509123', 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 15:19:12 ERROR [io.de.co.or.lo.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 => '126394489500', endScn => '126394509123', 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 => '126394489500', endScn => '126394509123', 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 15:19:12 ERROR [io.de.pi.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 => '126394489500', endScn => '126394509123', 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 => '126394489500', endScn => '126394509123', 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 15:19:12 INFO [io.de.co.or.lo.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126394489500, endScn=126394509123 15:19:12 INFO [io.de.co.or.lo.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126394509123, oldestScn=126394489473, committedScn=126394489498, offsetScn=126394469503, logMinerQueryCount=1, totalProcessedRows=6967, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT2.019014S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT2.019014S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT2.019014S, totalBatchProcessingDuration=PT54.074618S, lastBatchProcessingDuration=PT54.074618S, maxBatchProcessingThroughput=0, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745, +DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | CURRENT], switchCounter=512, batchSize=20000, millisecondToSleepBetweenMiningQuery=1000, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT36.154869S, lastStartLogMiningSessionDuration=PT36.154869S, maxStartLogMiningSessionDuration=PT36.154869S, totalProcessTime=PT54.074618S, minBatchProcessTime=PT54.074618S, maxBatchProcessTime=PT54.074618S, totalResultSetNextTime=PT0.00135S, lagFromTheSource=DurationPT1M34.003968S, maxLagFromTheSourceDuration=PT2M47.877135S, minLagFromTheSourceDuration=PT1M34.003632S, lastCommitDuration=PT0.000002S, maxCommitDuration=PT0S, activeTransactions=2, rolledBackTransactions=4, committedTransactions=3478, abandonedTransactionIds=[], rolledbackTransactionIds=[0f00140094f03000, 13000000decf2d00, 0b00100031051e00, 0e0018008b7c2b00], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=13948624, miningSessionUserGlobalAreaMaxMemory=25828064, miningSessionProcessGlobalAreaMemory=43152136, miningSessionProcessGlobalAreaMaxMemory=43152136} 15:19:12 INFO [io.de.co.or.lo.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126394489472] 15:19:12 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 15:19:12 INFO [io.de.pi.me.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 15:19:13 WARN [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Going to restart connector after 10 sec. after a retriable exception 15:19:13 INFO [io.de.jd.JdbcConnection] (pool-11-thread-1) Connection gracefully closed 15:19:13 INFO [io.de.em.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 => '126394489500', endScn => '126394509123', 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 => '126394489500', endScn => '126394509123', 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 15:19:13 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 15:19:15 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 15:19:17 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 15:19:19 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 15:19:21 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v72/FileDatabaseHistory.dat 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.user = ******* 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.dbname = ******* 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.server.name = ******* 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.port = 1521 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v72/offsets.dat 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.hostname = ******** 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.password = ******** 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) name = pubsub 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.PTY_IM 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 15:19:23 INFO [io.de.co.or.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 15:19:23 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126394469503] 15:19:23 INFO [io.de.re.hi.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 15:19:23 INFO [io.de.re.hi.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 23 ms 15:19:23 INFO [io.de.ut.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = AMCTPRD named = change-event-source-coordinator 15:19:23 INFO [io.de.ut.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 15:19:23 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 15:19:23 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 15:19:23 INFO [io.de.co.or.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 15:19:23 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126394469503]] 15:19:23 INFO [io.de.pi.me.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 15:19:23 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 15:19:28 INFO [io.de.se.DebeziumServer] (Shutdown thread) Received request to stop the engine 15:19:28 INFO [io.de.em.EmbeddedEngine] (Shutdown thread) Stopping the embedded engine 15:19:28 INFO [io.de.em.EmbeddedEngine] (Shutdown thread) Waiting for PT5M for connector to stop 15:19:28 INFO [io.de.em.EmbeddedEngine] (pool-7-thread-1) Stopping the task and engine 15:19:28 INFO [io.de.co.co.BaseSourceTask] (pool-7-thread-1) Stopping down connector 15:19:35 INFO [io.de.co.or.lo.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126394469503, endScn=null 15:19:35 INFO [io.de.co.or.lo.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=null, oldestScn=null, committedScn=null, offsetScn=null, logMinerQueryCount=0, totalProcessedRows=0, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT0S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT0S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT0S, totalBatchProcessingDuration=PT0S, lastBatchProcessingDuration=PT0S, maxBatchProcessingThroughput=0, currentLogFileName=[+DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745, +DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745], minLogFilesMined=4, maxLogFilesMined=4, redoLogStatus=[+DATA/AMCTPRD/ONLINELOG/group_5.269.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_7.263.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_7.271.1032380745 | ACTIVE, +FRA/AMCTPRD/ONLINELOG/group_5.261.1032380745 | ACTIVE, +DATA/AMCTPRD/ONLINELOG/group_8.272.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_8.264.1032380745 | CURRENT, +DATA/AMCTPRD/ONLINELOG/group_6.270.1032380745 | CURRENT, +FRA/AMCTPRD/ONLINELOG/group_6.262.1032380745 | CURRENT], switchCounter=0, batchSize=20000, millisecondToSleepBetweenMiningQuery=1000, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT0S, lastStartLogMiningSessionDuration=PT0S, maxStartLogMiningSessionDuration=PT0S, totalProcessTime=PT0S, minBatchProcessTime=PT0S, maxBatchProcessTime=PT0S, totalResultSetNextTime=PT0S, lagFromTheSource=DurationPT0S, maxLagFromTheSourceDuration=PT0S, minLagFromTheSourceDuration=PT0S, lastCommitDuration=PT0S, maxCommitDuration=PT0S, activeTransactions=0, rolledBackTransactions=0, committedTransactions=0, abandonedTransactionIds=[], rolledbackTransactionIds=[], registeredDmlCount=0, committedDmlCount=0, errorCount=0, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=0, miningSessionUserGlobalAreaMaxMemory=0, miningSessionProcessGlobalAreaMemory=0, miningSessionProcessGlobalAreaMaxMemory=0} 15:19:35 INFO [io.de.co.or.lo.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126394469503] 15:19:35 INFO [io.de.pi.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 15:19:35 INFO [io.de.pi.me.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 15:19:35 INFO [io.de.jd.JdbcConnection] (pool-12-thread-1) Connection gracefully closed 15:19:35 INFO [or.ap.ka.co.st.FileOffsetBackingStore] (pool-7-thread-1) Stopped FileOffsetBackingStore 15:19:35 INFO [io.de.se.ConnectorLifecycle] (pool-7-thread-1) Connector completed: success = 'true', message = 'Connector 'io.debezium.connector.oracle.OracleConnector' completed normally.', error = 'null' 15:19:35 INFO [io.quarkus] (Shutdown thread) debezium-server-dist stopped in 6.649s