__ ____ __ _____ ___ __ ____ ______ --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \ --\___\_\____/_/ |_/_/|_/_/|_|\____/___/ 2022-03-16 12:43:36,123 INFO [io.deb.ser.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$207/0x000000084023c840@e044b4a' stream name mapper 2022-03-16 12:43:36,248 INFO [io.deb.ser.pub.PubSubChangeConsumer] (main) Using default PublisherBuilder 'io.debezium.server.pubsub.PubSubChangeConsumer$$Lambda$217/0x0000000840266840@1e6308a9' 2022-03-16 12:43:36,248 INFO [io.deb.ser.DebeziumServer] (main) Consumer 'io.debezium.server.pubsub.PubSubChangeConsumer' instantiated 2022-03-16 12:43:36,374 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:43:36,380 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:43:36,394 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 = tempiposct2v20/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:43:36,394 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:43:36,395 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:43:36,399 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:43:36,400 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:43:36,403 INFO [io.deb.ser.DebeziumServer] (main) Engine executor started 2022-03-16 12:43:36,419 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file tempiposct2v20/offsets.dat 2022-03-16 12:43:36,559 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:43:36,566 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:43:36,567 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v20/FileDatabaseHistory.dat 2022-03-16 12:43:36,567 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:43:36,567 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:43:36,567 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:43:36,568 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:43:36,568 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:43:36,568 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:43:36,568 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:43:36,568 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:43:36,568 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v20/offsets.dat 2022-03-16 12:43:36,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:43:36,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:43:36,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:43:36,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:43:36,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:43:36,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:43:36,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.VOYCTRDTLS_O 2022-03-16 12:43:36,570 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:43:36,570 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:43:36,570 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:43:36,570 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:43:36,740 INFO [io.quarkus] (main) debezium-server-dist 1.8.0.Final on JVM (powered by Quarkus 2.5.0.Final) started in 2.499s. Listening on: http://0.0.0.0:7071 2022-03-16 12:43:36,740 INFO [io.quarkus] (main) Profile prod activated. 2022-03-16 12:43:36,741 INFO [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health, vertx] 2022-03-16 12:43:37,664 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:43:37,836 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) No previous offsets found 2022-03-16 12:43:37,837 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:43:37,854 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:43:37,855 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:43:37,869 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:43:37,870 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:43:37,875 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) No previous offset has been found. 2022-03-16 12:43:37,876 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:43:37,876 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 1 - Preparing 2022-03-16 12:43:37,877 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 2 - Determining captured tables 2022-03-16 12:43:48,735 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 3 - Locking captured tables [AMCTPRD.TOS_USR.VOYCTRDTLS_O] 2022-03-16 12:43:48,788 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 4 - Determining snapshot offset 2022-03-16 12:43:48,964 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:43:49,000 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 5 - Reading structure of captured tables 2022-03-16 12:43:56,523 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 6 - Persisting schema history 2022-03-16 12:43:59,407 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 1 records sent during previous 00:00:22.962, last recorded offset: {snapshot=true, scn=126218534266, snapshot_completed=false} 2022-03-16 12:43:59,410 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot step 7 - Snapshotting data 2022-03-16 12:43:59,412 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:43:59,412 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exporting data from table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' (1 of 1 tables) 2022-03-16 12:43:59,415 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) For table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' using select statement: 'SELECT "CTR_NO", "DSCH_LD_LST_PRINT_FLG", "DSCH_LD_ROB_IND", "INT_VIA_NO", "LIFE_NO", "RESTOW_FLG", "RESTOW_TYPE", "VSL_BAY_NO", "VSL_ROW_NO", "VSL_SUB_TIER_NO", "VSL_TIER_NO", "WT_CAT_DEFN_CD", "WT_CAT", "DK_UD_IND", "ATHWART_STOWED_FLG", "CONFIRM_FLG", "MNF_DTTM", "ADT_INS_DTTM", "ADT_UPD_DTTM", "SHIP_CRN_FLG", "ADT_VER_STAMP", "ADT_INS_USR_CD", "ADT_UPD_USR_CD", "ADT_TXN_CD", "ADT_TXN_NO", "ADT_INS_EXT_USR_FLG", "ADT_UPD_EXT_USR_FLG", "INT_CTR_NO", "EQPT_IND", "INVC_PTY_CD", "RFR_INVC_PTY_CD", "INVC_BASE_STS" FROM "TOS_USR"."VOYCTRDTLS_O" AS OF SCN 126218534266' 2022-03-16 12:44:09,690 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 30723 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:00:10.277 2022-03-16 12:44:11,737 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 2048 records sent during previous 00:00:12.33, last recorded offset: {snapshot=true, scn=126218534266, snapshot_completed=false} 2022-03-16 12:44:19,777 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 73731 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:00:20.365 2022-03-16 12:44:29,946 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 116739 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:00:30.534 2022-03-16 12:44:40,132 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 157699 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:00:40.72 2022-03-16 12:44:50,333 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 204803 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:00:50.921 2022-03-16 12:44:51,650 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 2048 records sent during previous 00:00:39.913, last recorded offset: {snapshot=true, scn=126218534266, snapshot_completed=false} 2022-03-16 12:45:00,489 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 251907 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:01:01.077 2022-03-16 12:45:10,578 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 296963 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:01:11.166 2022-03-16 12:45:20,732 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 344067 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:01:21.32 2022-03-16 12:45:30,998 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 391171 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:01:31.586 2022-03-16 12:45:41,341 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 438275 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:01:41.929 2022-03-16 12:45:51,674 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 485379 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:01:52.262 2022-03-16 12:46:01,833 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 532483 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:02:02.421 2022-03-16 12:46:11,467 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 2048 records sent during previous 00:01:19.816, last recorded offset: {snapshot=true, scn=126218534266, snapshot_completed=false} 2022-03-16 12:46:11,894 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 579587 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:02:12.482 2022-03-16 12:46:22,015 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 628739 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:02:22.603 2022-03-16 12:46:32,090 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 677891 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:02:32.678 2022-03-16 12:46:42,194 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 724995 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:02:42.782 2022-03-16 12:46:52,252 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 772099 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:02:52.84 2022-03-16 12:47:02,552 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 821251 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:03:03.14 2022-03-16 12:47:12,754 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 868355 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:03:13.342 2022-03-16 12:47:23,050 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 917507 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:03:23.638 2022-03-16 12:47:33,194 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 964611 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:03:33.782 2022-03-16 12:47:43,482 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1013763 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:03:44.07 2022-03-16 12:47:53,525 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1060000 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:03:54.113 2022-03-16 12:48:03,682 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1105923 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:04:04.27 2022-03-16 12:48:13,968 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1153027 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:04:14.556 2022-03-16 12:48:24,326 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1200131 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:04:24.914 2022-03-16 12:48:34,467 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1245187 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:04:35.055 2022-03-16 12:48:44,830 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1290243 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:04:45.418 2022-03-16 12:48:51,480 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 2048 records sent during previous 00:02:40.014, last recorded offset: {snapshot=true, scn=126218534266, snapshot_completed=false} 2022-03-16 12:48:54,878 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1334000 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:04:55.466 2022-03-16 12:49:04,880 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1380000 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:05:05.468 2022-03-16 12:49:14,934 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1422000 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:05:15.522 2022-03-16 12:49:25,275 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1466371 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:05:25.863 2022-03-16 12:49:35,606 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1511427 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:05:36.194 2022-03-16 12:49:45,610 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1558000 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:05:46.198 2022-03-16 12:49:55,672 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1601539 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:05:56.26 2022-03-16 12:50:06,337 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1646595 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:06:06.924 2022-03-16 12:50:16,338 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1689071 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:06:16.926 2022-03-16 12:50:26,726 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1732611 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:06:27.314 2022-03-16 12:50:36,822 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1775619 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:06:37.41 2022-03-16 12:50:46,828 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1820675 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:06:47.416 2022-03-16 12:50:57,105 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1867779 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:06:57.693 2022-03-16 12:51:07,351 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1912835 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:07:07.938 2022-03-16 12:51:17,642 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Exported 1955843 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O' after 00:07:18.23 2022-03-16 12:51:24,090 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished exporting 1983936 records for table 'AMCTPRD.TOS_USR.VOYCTRDTLS_O'; total duration '00:07:24.678' 2022-03-16 12:51:24,114 INFO [io.deb.pip.sou.AbstractSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot - Final stage 2022-03-16 12:51:24,115 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=126218534266]] 2022-03-16 12:51:24,123 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:51:24,126 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 2022-03-16 12:52:55,331 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 => '126218695188', endScn => '126218721456', 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 => '126218695188', endScn => '126218721456', 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:52:55,333 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 => '126218695188', endScn => '126218721456', 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 => '126218695188', endScn => '126218721456', 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:52:55,334 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 => '126218695188', endScn => '126218721456', 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 => '126218695188', endScn => '126218721456', 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:52:55,335 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126218695188, endScn=126218721456 2022-03-16 12:52:55,335 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126218721456, oldestScn=126218695178, committedScn=126218695188, offsetScn=126218695039, logMinerQueryCount=7, totalProcessedRows=41587, totalCapturedDmlCount=99, totalDurationOfFetchingQuery=PT8.915666S, lastCapturedDmlCount=77, lastDurationOfFetchingQuery=PT1.03407S, maxCapturedDmlCount=77, maxDurationOfFetchingQuery=PT2.141936S, totalBatchProcessingDuration=PT1M7.254525S, lastBatchProcessingDuration=PT1.560211S, maxBatchProcessingThroughput=49, 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=1520, batchSize=27000, millisecondToSleepBetweenMiningQuery=200, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0.021767S, totalStartLogMiningSessionDuration=PT34.207802S, lastStartLogMiningSessionDuration=PT0.049716S, maxStartLogMiningSessionDuration=PT33.914879S, totalProcessTime=PT1M7.254525S, minBatchProcessTime=PT0.860425S, maxBatchProcessTime=PT57.528432S, totalResultSetNextTime=PT0.005723S, lagFromTheSource=DurationPT1M58.669385S, maxLagFromTheSourceDuration=PT8M53.389727S, minLagFromTheSourceDuration=PT1M58.662886S, lastCommitDuration=PT0.000001S, maxCommitDuration=PT0.011238S, activeTransactions=1, rolledBackTransactions=15, committedTransactions=20727, abandonedTransactionIds=[], rolledbackTransactionIds=[23000d004e600900, 09000b00b9f74a00, 12000a008c3d2e00, 11000300106d2f00, 110017001c6d2f00, 110013001c6d2f00, 02001600b1e94000, 0900010051f74a00, 25001e0025d20100, 110004003d6d2f00, 15001600ec762900, 15001c0096762900, 02000600a7e94000, 09001c004cf74a00, 06000000bef23400], registeredDmlCount=99, committedDmlCount=98, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=14023720, miningSessionUserGlobalAreaMaxMemory=25462448, miningSessionProcessGlobalAreaMemory=39154440, miningSessionProcessGlobalAreaMaxMemory=39154440} 2022-03-16 12:52:55,335 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126218695177] 2022-03-16 12:52:55,335 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 12:52:55,336 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 12:52:55,530 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:52:55,561 INFO [io.deb.jdb.JdbcConnection] (pool-11-thread-1) Connection gracefully closed 2022-03-16 12:52:55,566 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 => '126218695188', endScn => '126218721456', 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 => '126218695188', endScn => '126218721456', 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:52:55,568 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:52:57,568 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:52:59,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:53:01,569 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:53:03,571 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:53:05,572 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v20/FileDatabaseHistory.dat 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v20/offsets.dat 2022-03-16 12:53:05,573 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.VOYCTRDTLS_O 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:53:05,574 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:53:05,911 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:53:05,951 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126218695039] 2022-03-16 12:53:05,952 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 12:53:05,974 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:53:05,977 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:53:05,978 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:53:05,979 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:53:05,979 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:53:05,979 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 12:53:05,980 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126218695039]] 2022-03-16 12:53:05,980 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:53:05,981 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 2022-03-16 12:54:21,629 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 83 records sent during previous 00:05:30.149, last recorded offset: {commit_scn=126218706645, transaction_id=null, scn=126218705386} 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:55:00,611 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 => '126218781038', endScn => '126218784005', 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 => '126218781038', endScn => '126218784005', 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:55:00,612 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 => '126218781038', endScn => '126218784005', 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 => '126218781038', endScn => '126218784005', 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:55:00,612 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 => '126218781038', endScn => '126218784005', 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 => '126218781038', endScn => '126218784005', 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:55:00,612 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126218781038, endScn=126218784005 2022-03-16 12:55:00,613 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126218784005, oldestScn=126218780956, committedScn=126218781036, offsetScn=126218779962, logMinerQueryCount=4, totalProcessedRows=38903, totalCapturedDmlCount=386, totalDurationOfFetchingQuery=PT31.174795S, lastCapturedDmlCount=146, lastDurationOfFetchingQuery=PT7.610629S, maxCapturedDmlCount=146, maxDurationOfFetchingQuery=PT9.061484S, totalBatchProcessingDuration=PT1M30.695385S, lastBatchProcessingDuration=PT13.897349S, maxBatchProcessingThroughput=11, 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=1532, batchSize=22000, millisecondToSleepBetweenMiningQuery=200, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0.053538S, totalStartLogMiningSessionDuration=PT31.452055S, lastStartLogMiningSessionDuration=PT0.04627S, maxStartLogMiningSessionDuration=PT31.311077S, totalProcessTime=PT1M30.695385S, minBatchProcessTime=PT9.244383S, maxBatchProcessTime=PT56.217822S, totalResultSetNextTime=PT7.691388S, lagFromTheSource=DurationPT1M28.727114S, maxLagFromTheSourceDuration=PT3M25.264507S, minLagFromTheSourceDuration=PT1M27.004779S, lastCommitDuration=PT0.000001S, maxCommitDuration=PT0.002248S, activeTransactions=3, rolledBackTransactions=43, committedTransactions=19012, abandonedTransactionIds=[], rolledbackTransactionIds=[08001d00d1144300, 140000005a843100, 0d001f00cd3c2900, 2500200033d20100, 0900210045f74a00, 09000c009ff74a00, 27001d0088d30000, 090000000bf84a00, 09001c0094f74a00, 06000900cff23400, 29001c0079800000, 240013008e300400, 0900150065f74a00, 0900020037f84a00, 24000500d2300400, 24000000da300400, 28002100cd9b0000, 150015002b772900, 09001900e6f74a00, 03001a009cfe3900, 0300170095fe3900, 26000a007d550100, 07001b0068d53800, 09000300aff74a00, 02000a0042ea4000, 09000d005af74a00, 28000400cf9b0000, 07001100c7d53800, 050018002ba32b00, 09000700fbf64a00, 02001600b4e94000, 15001f00f0762900, 2900120079800000, 09001b0002f84a00, 2300050032610900, 08000e00e5144300, 080021006c144300, 01001700a5fd4500, 230006003e610900, 0100200023fe4500, 02001e0042e94000, 09001100fcf64a00, 09001700bef74a00], registeredDmlCount=386, committedDmlCount=385, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=7733480, miningSessionUserGlobalAreaMaxMemory=18157872, miningSessionProcessGlobalAreaMemory=31535208, miningSessionProcessGlobalAreaMaxMemory=31535208} 2022-03-16 12:55:00,613 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126218780955] 2022-03-16 12:55:00,613 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 12:55:00,613 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 12:55:00,794 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:55:00,819 INFO [io.deb.jdb.JdbcConnection] (pool-12-thread-1) Connection gracefully closed 2022-03-16 12:55:00,820 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 => '126218781038', endScn => '126218784005', 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 => '126218781038', endScn => '126218784005', 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:55:00,821 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:55:02,821 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:55:04,822 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:55:06,823 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:55:08,823 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:55:10,825 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:55:10,825 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v20/FileDatabaseHistory.dat 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:55:10,826 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v20/offsets.dat 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.VOYCTRDTLS_O 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:55:10,827 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:55:10,828 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:55:10,828 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:55:11,194 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:55:11,230 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126218779962] 2022-03-16 12:55:11,230 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 12:55:11,240 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 9 ms 2022-03-16 12:55:11,241 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:55:11,241 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:55:11,242 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:55:11,243 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:55:11,243 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 12:55:11,243 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126218779962]] 2022-03-16 12:55:11,243 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:55:11,243 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming 2022-03-16 12:56:35,965 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 => '126218842944', endScn => '126218854039', 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 => '126218842944', endScn => '126218854039', 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:56:35,967 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 => '126218842944', endScn => '126218854039', 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 => '126218842944', endScn => '126218854039', 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:56:35,968 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 => '126218842944', endScn => '126218854039', 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 => '126218842944', endScn => '126218854039', 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:56:35,968 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) startScn=126218842944, endScn=126218854039 2022-03-16 12:56:35,968 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=126218854039, oldestScn=126218842889, committedScn=126218842944, offsetScn=126218842707, logMinerQueryCount=3, totalProcessedRows=31640, totalCapturedDmlCount=261, totalDurationOfFetchingQuery=PT13.37962S, lastCapturedDmlCount=136, lastDurationOfFetchingQuery=PT1.587712S, maxCapturedDmlCount=136, maxDurationOfFetchingQuery=PT6.226497S, totalBatchProcessingDuration=PT1M10.161856S, lastBatchProcessingDuration=PT2.195521S, maxBatchProcessingThroughput=62, 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=1544, batchSize=22000, millisecondToSleepBetweenMiningQuery=600, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0.005934S, totalStartLogMiningSessionDuration=PT32.338453S, lastStartLogMiningSessionDuration=PT0.085076S, maxStartLogMiningSessionDuration=PT32.194819S, totalProcessTime=PT1M10.161856S, minBatchProcessTime=PT2.195521S, maxBatchProcessTime=PT1M1.03417S, totalResultSetNextTime=PT3.055662S, lagFromTheSource=DurationPT1M23.840123S, maxLagFromTheSourceDuration=PT2M51.560047S, minLagFromTheSourceDuration=PT1M23.840014S, lastCommitDuration=PT0S, maxCommitDuration=PT0.004642S, activeTransactions=1, rolledBackTransactions=40, committedTransactions=15290, abandonedTransactionIds=[], rolledbackTransactionIds=[090014007af74a00, 0200150020ea4000, 0900040071f84a00, 26001e0089550100, 29001b00a4800000, 01000f00b0fd4500, 040012005ea22200, 01001300e8fd4500, 0b0011004d7c1d00, 08001b00f7134300, 09000100bdf74a00, 07000c0091d53800, 07001a00fbd43800, 09000f00a9f74a00, 1c0020003e591000, 24000c00e0300400, 23000f0043610900, 2500060031d20100, 0900060048f74a00, 09001a00ccf74a00, 090016001ef84a00, 0300200088fe3900, 1a000700f58b2100, 28001d00df9b0000, 1d001a00fab10e00, 09000d00abf74a00, 28000000dc9b0000, 0600120002f33400, 28000f00e69b0000, 27000e0095d30000, 0c00020070a32300, 090009008bf84a00, 29000b0089800000, 1c00130059591000, 1b00100083f71800, 09001e00c4f74a00, 0900040054f84a00, 290010008d800000, 09001300b3f74a00, 09000a0048f84a00], registeredDmlCount=261, committedDmlCount=259, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=7733440, miningSessionUserGlobalAreaMaxMemory=18157872, miningSessionProcessGlobalAreaMemory=31879944, miningSessionProcessGlobalAreaMaxMemory=31879944} 2022-03-16 12:56:35,968 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=126218842888] 2022-03-16 12:56:35,968 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Finished streaming 2022-03-16 12:56:35,968 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'false' 2022-03-16 12:56:36,041 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:56:36,070 INFO [io.deb.jdb.JdbcConnection] (pool-13-thread-1) Connection gracefully closed 2022-03-16 12:56:36,070 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 => '126218842944', endScn => '126218854039', 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 => '126218842944', endScn => '126218854039', 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:56:36,072 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:56:38,072 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:56:40,073 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:56:42,074 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:56:44,074 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Awaiting end of restart backoff period after a retriable error 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = tempiposct2v20/FileDatabaseHistory.dat 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = DBZUSER 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = AMCTPRD 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = AMCTPRD 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-03-16 12:56:46,076 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = tempiposct2v20/offsets.dat 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) decimal.handling.mode = double 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.6.63.198 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = pubsub 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.log.only.mode = true 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.oracle.version = 12+ 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = TOS_USR.VOYCTRDTLS_O 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.key = json 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = initial 2022-03-16 12:56:46,077 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.key = json 2022-03-16 12:56:46,422 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:56:46,452 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@f5b1bfc5: OracleOffsetContext [scn=126218842707] 2022-03-16 12:56:46,453 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-03-16 12:56:46,456 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 1 change(s) in 2 ms 2022-03-16 12:56:46,457 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:56:46,457 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-AMCTPRD-change-event-source-coordinator 2022-03-16 12:56:46,458 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Metrics registered 2022-03-16 12:56:46,458 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Context created 2022-03-16 12:56:46,458 INFO [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) The previous offset has been found. 2022-03-16 12:56:46,458 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=126218842707]] 2022-03-16 12:56:46,458 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Connected metrics set to 'true' 2022-03-16 12:56:46,459 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-AMCTPRD-change-event-source-coordinator) Starting streaming