2023-09-05 10:14:45.567 [tongcdc-task-td1] INFO io.debezium.config.CommonConnectorConfig - Loading the custom source info struct maker plugin: io.debezium.connector.oracle.OracleSourceInfoStructMaker 2023-09-05 10:14:45.792 [tongcdc-task-td1] INFO io.debezium.connector.oracle.OracleConnection - Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.10.0.0.0 2023-09-05 10:14:45.795 [pool-6-thread-1] INFO io.debezium.jdbc.JdbcConnection - Connection gracefully closed 2023-09-05 10:14:45.812 [tongcdc-task-td1] INFO org.apache.kafka.connect.storage.FileOffsetBackingStore - Starting FileOffsetBackingStore with file /data/debezium/cdc/td1/offsets.dat 2023-09-05 10:14:45.825 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - Starting OracleConnectorTask with configuration: 2023-09-05 10:14:45.825 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - connector.class = io.debezium.connector.oracle.OracleConnector 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - snapshot.locking.mode = none 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - log.mining.buffer.drop.on.stop = false 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - max.queue.size = 81920 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - schema.include.list = TEST_CDC1,TEST_CDC2 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - internal.log.mining.read.only = false 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - topic.heartbeat.prefix = __debezium_heartbeat 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - log.mining.strategy = online_catalog 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - include.schema.changes = true 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - schema.history.internal.store.only.captured.tables.ddl = true 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - schema.history.internal.file.filename = /data/debezium/cdc/td1/history/schema.dat 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - tombstones.on.delete = false 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - unavailable.value.placeholder = __debezium_value 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - topic.prefix = td1 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - offset.storage.file.filename = /data/debezium/cdc/td1/offsets.dat 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - poll.interval.ms = 100 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - lob.enabled = true 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - errors.retry.delay.initial.ms = 300 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - log.mining.archive.log.only.mode = false 2023-09-05 10:14:45.826 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - value.converter = org.apache.kafka.connect.json.JsonConverter 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - key.converter = org.apache.kafka.connect.json.JsonConverter 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - database.user = C##TEST 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - database.dbname = ORCL 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - custom.retriable.exception = .*(ORA-00600|ORA-01289|ORA-01291|ORA-31603|ORA-26824|ORA-26876|Invalid value: null used for required field: "typeName")(.|\s)* 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - database.pdb.name = PDB1 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - database.connection.adapter = logminer 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - log.mining.buffer.type = memory 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - internal.log.mining.transaction.snapshot.boundary.mode = all 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - offset.flush.timeout.ms = 5000 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - errors.retry.delay.max.ms = 10000 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - event.processing.failure.handling.mode = fail 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - schema.history.internal.skip.unparseable.ddl = true 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - log.mining.restart.connection = true 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - database.port = 1521 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - offset.flush.interval.ms = 5000 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - schema.history.internal = io.debezium.storage.file.history.FileSchemaHistory 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - log.mining.session.max.ms = 1800000 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - errors.max.retries = -1 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - database.hostname = 10.10.93.27 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - database.password = ******** 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - name = td1 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - log.mining.batch.size.default = 100000 2023-09-05 10:14:45.827 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - max.batch.size = 20480 2023-09-05 10:14:45.828 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - skipped.operations = none 2023-09-05 10:14:45.828 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - table.include.list = TEST_CDC1.AB01,TEST_CDC2.BG00,TEST_CDC1.AC02,TEST_CDC1.AB02,TEST_CDC1.AC01,TEST_CDC2.AC99,TEST_CDC2.AE97,TEST_CDC1.ICC2,TEST_CDC2.AB99,TEST_CDC2.AE99,TEST_CDC1.AC20,TEST_CDC1.ACDB,TEST_CDC2.AE98,TEST_CDC1.LCN1,TEST_CDC1.AE06,TEST_CDC1.AE07,TEST_CDC1.AC04,TEST_CDC1.AE01,TEST_CDC1.AC05,TEST_CDC1.AE03,TEST_CDC2.AF00,TEST_CDC1.AB36,TEST_CDC1.ABN1,TEST_CDC1.AC35,TEST_CDC1.AE32,TEST_CDC1.AB32,TEST_CDC1.LBA8,TEST_CDC1.AAB2,TEST_CDC1.JC02,TEST_CDC1.ICN1,TEST_CDC1.JC04,TEST_CDC1.ABN2,TEST_CDC1.AE36 2023-09-05 10:14:45.828 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - snapshot.mode = schema_only 2023-09-05 10:14:45.828 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - Attempting to start task 2023-09-05 10:14:45.829 [tongcdc-task-td1] INFO io.debezium.config.CommonConnectorConfig - Loading the custom source info struct maker plugin: io.debezium.connector.oracle.OracleSourceInfoStructMaker 2023-09-05 10:14:45.830 [tongcdc-task-td1] INFO io.debezium.config.CommonConnectorConfig - Loading the custom topic naming strategy plugin: io.debezium.schema.SchemaTopicNamingStrategy 2023-09-05 10:14:46.119 [tongcdc-task-td1] INFO io.debezium.connector.oracle.OracleConnection - Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.10.0.0.0 2023-09-05 10:14:46.383 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - No previous offsets found 2023-09-05 10:14:46.384 [tongcdc-task-td1] INFO io.debezium.connector.oracle.OracleConnectorTask - Connector started for the first time, database schema history recovery will not be executed 2023-09-05 10:14:46.393 [tongcdc-task-td1] INFO io.debezium.util.Threads - Requested thread factory for connector OracleConnector, id = td1 named = SignalProcessor 2023-09-05 10:14:46.408 [tongcdc-task-td1] INFO io.debezium.util.Threads - Requested thread factory for connector OracleConnector, id = td1 named = change-event-source-coordinator 2023-09-05 10:14:46.410 [tongcdc-task-td1] INFO io.debezium.util.Threads - Creating thread debezium-oracleconnector-td1-change-event-source-coordinator 2023-09-05 10:14:46.411 [tongcdc-task-td1] INFO io.debezium.pipeline.signal.SignalProcessor - SignalProcessor started. Scheduling it every 5000ms 2023-09-05 10:14:46.412 [tongcdc-task-td1] INFO io.debezium.util.Threads - Creating thread debezium-oracleconnector-td1-SignalProcessor 2023-09-05 10:14:46.412 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - Successfully started task 2023-09-05 10:14:46.414 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.pipeline.ChangeEventSourceCoordinator - Metrics registered 2023-09-05 10:14:46.415 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.pipeline.ChangeEventSourceCoordinator - Context created 2023-09-05 10:14:46.420 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.connector.oracle.OracleSnapshotChangeEventSource - No previous offset has been found. 2023-09-05 10:14:46.420 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.connector.oracle.OracleSnapshotChangeEventSource - According to the connector configuration only schema will be snapshot. 2023-09-05 10:14:46.425 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Snapshot step 1 - Preparing 2023-09-05 10:14:46.425 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Snapshot step 2 - Determining captured tables 2023-09-05 10:14:49.697 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC2.AE99 to the list of capture schema tables 2023-09-05 10:14:49.697 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC2.AE97 to the list of capture schema tables 2023-09-05 10:14:49.697 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC2.AE98 to the list of capture schema tables 2023-09-05 10:14:49.699 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC2.AF00 to the list of capture schema tables 2023-09-05 10:14:49.700 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AE32 to the list of capture schema tables 2023-09-05 10:14:49.700 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AE36 to the list of capture schema tables 2023-09-05 10:14:49.700 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AE07 to the list of capture schema tables 2023-09-05 10:14:49.701 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AE06 to the list of capture schema tables 2023-09-05 10:14:49.701 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AE01 to the list of capture schema tables 2023-09-05 10:14:49.701 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AE03 to the list of capture schema tables 2023-09-05 10:14:49.701 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.ICN1 to the list of capture schema tables 2023-09-05 10:14:49.702 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.LCN1 to the list of capture schema tables 2023-09-05 10:14:49.702 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.ICC2 to the list of capture schema tables 2023-09-05 10:14:49.702 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.ACDB to the list of capture schema tables 2023-09-05 10:14:49.702 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AC20 to the list of capture schema tables 2023-09-05 10:14:49.702 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.ABN2 to the list of capture schema tables 2023-09-05 10:14:49.702 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.ABN1 to the list of capture schema tables 2023-09-05 10:14:49.703 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AC01 to the list of capture schema tables 2023-09-05 10:14:49.703 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AC02 to the list of capture schema tables 2023-09-05 10:14:49.703 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AC05 to the list of capture schema tables 2023-09-05 10:14:49.703 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AC04 to the list of capture schema tables 2023-09-05 10:14:49.703 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AC35 to the list of capture schema tables 2023-09-05 10:14:49.703 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.LBA8 to the list of capture schema tables 2023-09-05 10:14:49.704 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AB02 to the list of capture schema tables 2023-09-05 10:14:49.704 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AB01 to the list of capture schema tables 2023-09-05 10:14:49.704 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AB32 to the list of capture schema tables 2023-09-05 10:14:49.704 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AB36 to the list of capture schema tables 2023-09-05 10:14:49.704 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC2.AB99 to the list of capture schema tables 2023-09-05 10:14:49.705 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.AAB2 to the list of capture schema tables 2023-09-05 10:14:49.705 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.JC02 to the list of capture schema tables 2023-09-05 10:14:49.705 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC1.JC04 to the list of capture schema tables 2023-09-05 10:14:49.705 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC2.AC99 to the list of capture schema tables 2023-09-05 10:14:49.706 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Adding table PDB1.TEST_CDC2.BG00 to the list of capture schema tables 2023-09-05 10:14:49.719 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Snapshot step 3 - Locking captured tables [PDB1.TEST_CDC1.AB01, PDB1.TEST_CDC2.BG00, PDB1.TEST_CDC1.AC02, PDB1.TEST_CDC1.AB02, PDB1.TEST_CDC1.AC01, PDB1.TEST_CDC2.AC99, PDB1.TEST_CDC2.AE97, PDB1.TEST_CDC1.ICC2, PDB1.TEST_CDC2.AB99, PDB1.TEST_CDC2.AE99, PDB1.TEST_CDC1.AC20, PDB1.TEST_CDC1.ACDB, PDB1.TEST_CDC2.AE98, PDB1.TEST_CDC1.LCN1, PDB1.TEST_CDC1.AE06, PDB1.TEST_CDC1.AE07, PDB1.TEST_CDC1.AC04, PDB1.TEST_CDC1.AE01, PDB1.TEST_CDC1.AC05, PDB1.TEST_CDC1.AE03, PDB1.TEST_CDC2.AF00, PDB1.TEST_CDC1.AB36, PDB1.TEST_CDC1.ABN1, PDB1.TEST_CDC1.AC35, PDB1.TEST_CDC1.AE32, PDB1.TEST_CDC1.AB32, PDB1.TEST_CDC1.LBA8, PDB1.TEST_CDC1.AAB2, PDB1.TEST_CDC1.JC02, PDB1.TEST_CDC1.ICN1, PDB1.TEST_CDC1.JC04, PDB1.TEST_CDC1.ABN2, PDB1.TEST_CDC1.AE36] 2023-09-05 10:14:49.719 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.connector.oracle.OracleSnapshotChangeEventSource - Schema locking was disabled in connector configuration 2023-09-05 10:14:49.720 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Snapshot step 4 - Determining snapshot offset 2023-09-05 10:14:49.915 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.AbstractStreamingAdapter - No latest table SCN could be resolved, defaulting to current SCN 2023-09-05 10:14:50.152 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Consulting V$TRANSACTION and transaction logs for resolving snapshot offset. 2023-09-05 10:14:53.026 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Querying transaction logs, please wait... 2023-09-05 10:16:33.671 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction 'c700210024a50500' started at SCN '2748885056087' 2023-09-05 10:16:33.671 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '32020a00bdc20000' started at SCN '2748885056059' 2023-09-05 10:16:33.671 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '970012009b900400' started at SCN '2748885056097' 2023-09-05 10:16:33.672 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction 'f7010b00e6550000' started at SCN '2748885056436' 2023-09-05 10:16:33.672 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction 'fd01060053540000' started at SCN '2748885056190' 2023-09-05 10:16:33.672 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '4f03210052400000' started at SCN '2748885056177' 2023-09-05 10:16:33.672 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '0d031600d64d0000' started at SCN '2748885032964' 2023-09-05 10:16:33.672 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '58030a00bd3f0000' started at SCN '2748884859037' 2023-09-05 10:16:33.916 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '7d00070085410000' started at SCN '2748885025461' 2023-09-05 10:16:33.916 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '1a000e00e44c0000' started at SCN '2748884974752' 2023-09-05 10:16:33.916 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '43001800165f0000' started at SCN '2748885026222' 2023-09-05 10:16:39.354 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction 'bb011100644b0000' started at SCN '2748885049435' 2023-09-05 10:16:39.354 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '80010e001e4e0000' started at SCN '2748885000997' 2023-09-05 10:16:39.354 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '61001400fe430000' started at SCN '2748885042423' 2023-09-05 10:16:39.354 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction 'fe011200ae490000' started at SCN '2748885035188' 2023-09-05 10:16:39.354 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '50030c00784a0000' started at SCN '2748885034704' 2023-09-05 10:16:39.354 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '19001700b6d40100' started at SCN '2748884989982' 2023-09-05 10:16:39.354 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '130016003cef0400' started at SCN '2748884891650' 2023-09-05 10:16:39.354 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '400004008c4f0000' started at SCN '2748884168692' 2023-09-05 10:16:42.283 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '1600090054490000' started at SCN '2748884174297' 2023-09-05 10:16:42.284 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '5d01010021460000' started at SCN '2748884168845' 2023-09-05 10:16:42.284 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '38030000893c0000' started at SCN '2748884168806' 2023-09-05 10:16:42.284 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '74000000d8530000' started at SCN '2748884168694' 2023-09-05 10:16:42.284 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Transaction '53001d00604c0000' started at SCN '2748884324155' 2023-09-05 10:16:42.475 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction d201160013fb0100, starting at SCN 2748884999045 2023-09-05 10:16:42.475 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 490203003bb00000, starting at SCN 2748884973391 2023-09-05 10:16:42.475 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction c00014000b4d0600, starting at SCN 2748884406501 2023-09-05 10:16:42.475 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction a3001a0029e60400, starting at SCN 2748885051649 2023-09-05 10:16:42.475 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction ea01130058b20100, starting at SCN 2748884701737 2023-09-05 10:16:42.475 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction ca011e00a1890100, starting at SCN 2748885036001 2023-09-05 10:16:42.475 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 1d011600e7e50300, starting at SCN 0 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 05010400d0430500, starting at SCN 2748884939823 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 6802030007850000, starting at SCN 2748884929314 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction b100170096900400, starting at SCN 2748884977860 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 0201060007cf0300, starting at SCN 2748885056397 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 0a010b00c4060600, starting at SCN 2748884957222 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction c700210024a50500, starting at SCN 2748885056087 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 32020a00bdc20000, starting at SCN 2748885056059 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 970012009b900400, starting at SCN 2748885056097 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction f7010b00e6550000, starting at SCN 2748885056436 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction fd01060053540000, starting at SCN 2748885056190 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 4f03210052400000, starting at SCN 2748885056177 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 0d031600d64d0000, starting at SCN 2748885032964 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 58030a00bd3f0000, starting at SCN 2748884859037 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 7d00070085410000, starting at SCN 2748885025461 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 1a000e00e44c0000, starting at SCN 2748884974752 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 43001800165f0000, starting at SCN 2748885026222 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction bb011100644b0000, starting at SCN 2748885049435 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 80010e001e4e0000, starting at SCN 2748885000997 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 61001400fe430000, starting at SCN 2748885042423 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction fe011200ae490000, starting at SCN 2748885035188 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 50030c00784a0000, starting at SCN 2748885034704 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 19001700b6d40100, starting at SCN 2748884989982 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 130016003cef0400, starting at SCN 2748884891650 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 400004008c4f0000, starting at SCN 2748884168692 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 1600090054490000, starting at SCN 2748884174297 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 5d01010021460000, starting at SCN 2748884168845 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 38030000893c0000, starting at SCN 2748884168806 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 74000000d8530000, starting at SCN 2748884168694 2023-09-05 10:16:42.476 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.connector.oracle.logminer.LogMinerAdapter - Found in-progress transaction 53001d00604c0000, starting at SCN 2748884324155 2023-09-05 10:16:42.484 [pool-7-thread-1] INFO io.debezium.jdbc.JdbcConnection - Connection gracefully closed 2023-09-05 10:16:42.484 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Snapshot step 5 - Reading structure of captured tables 2023-09-05 10:16:42.484 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.connector.oracle.OracleSnapshotChangeEventSource - Only captured tables schema should be captured, capturing: [PDB1.TEST_CDC1.AB01, PDB1.TEST_CDC2.BG00, PDB1.TEST_CDC1.AC02, PDB1.TEST_CDC1.AB02, PDB1.TEST_CDC1.AC01, PDB1.TEST_CDC2.AC99, PDB1.TEST_CDC2.AE97, PDB1.TEST_CDC1.ICC2, PDB1.TEST_CDC2.AB99, PDB1.TEST_CDC2.AE99, PDB1.TEST_CDC1.AC20, PDB1.TEST_CDC1.ACDB, PDB1.TEST_CDC2.AE98, PDB1.TEST_CDC1.LCN1, PDB1.TEST_CDC1.AE06, PDB1.TEST_CDC1.AE07, PDB1.TEST_CDC1.AC04, PDB1.TEST_CDC1.AE01, PDB1.TEST_CDC1.AC05, PDB1.TEST_CDC1.AE03, PDB1.TEST_CDC2.AF00, PDB1.TEST_CDC1.AB36, PDB1.TEST_CDC1.ABN1, PDB1.TEST_CDC1.AC35, PDB1.TEST_CDC1.AE32, PDB1.TEST_CDC1.AB32, PDB1.TEST_CDC1.LBA8, PDB1.TEST_CDC1.AAB2, PDB1.TEST_CDC1.JC02, PDB1.TEST_CDC1.ICN1, PDB1.TEST_CDC1.JC04, PDB1.TEST_CDC1.ABN2, PDB1.TEST_CDC1.AE36] 2023-09-05 10:16:51.340 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Snapshot step 6 - Persisting schema history 2023-09-05 10:16:51.341 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC2.AB99 2023-09-05 10:16:54.985 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 1 database changes 2023-09-05 10:16:54.990 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC2.AC99 2023-09-05 10:16:55.087 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - 1 records sent during previous 00:02:09.264, last recorded offset of {server=td1} partition is {snapshot_pending_tx=d201160013fb0100:2748884999045,490203003bb00000:2748884973391,c00014000b4d0600:2748884406501,a3001a0029e60400:2748885051649,ea01130058b20100:2748884701737,ca011e00a1890100:2748885036001,1d011600e7e50300:0,05010400d0430500:2748884939823,6802030007850000:2748884929314,b100170096900400:2748884977860,0201060007cf0300:2748885056397,0a010b00c4060600:2748884957222,c700210024a50500:2748885056087,32020a00bdc20000:2748885056059,970012009b900400:2748885056097,f7010b00e6550000:2748885056436,fd01060053540000:2748885056190,4f03210052400000:2748885056177,0d031600d64d0000:2748885032964,58030a00bd3f0000:2748884859037,7d00070085410000:2748885025461,1a000e00e44c0000:2748884974752,43001800165f0000:2748885026222,bb011100644b0000:2748885049435,80010e001e4e0000:2748885000997,61001400fe430000:2748885042423,fe011200ae490000:2748885035188,50030c00784a0000:2748885034704,19001700b6d40100:2748884989982,130016003cef0400:2748884891650,400004008c4f0000:2748884168692,1600090054490000:2748884174297,5d01010021460000:2748884168845,38030000893c0000:2748884168806,74000000d8530000:2748884168694,53001d00604c0000:2748884324155, snapshot_scn=2748885056445, snapshot=true, scn=2748885056445, snapshot_completed=false} 2023-09-05 10:16:57.916 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 2 database changes 2023-09-05 10:16:57.917 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC2.AE97 2023-09-05 10:17:01.158 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 3 database changes 2023-09-05 10:17:01.158 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC2.AE98 2023-09-05 10:17:04.323 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 4 database changes 2023-09-05 10:17:04.324 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC2.AE99 2023-09-05 10:17:07.469 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 5 database changes 2023-09-05 10:17:07.469 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC2.AF00 2023-09-05 10:17:09.577 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 6 database changes 2023-09-05 10:17:09.577 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC2.BG00 2023-09-05 10:17:11.043 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 7 database changes 2023-09-05 10:17:11.044 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AAB2 2023-09-05 10:17:12.610 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 8 database changes 2023-09-05 10:17:12.610 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AB01 2023-09-05 10:17:13.898 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AB02 2023-09-05 10:17:15.556 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 10 database changes 2023-09-05 10:17:15.557 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AB32 2023-09-05 10:17:17.556 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 11 database changes 2023-09-05 10:17:17.556 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AB36 2023-09-05 10:17:19.254 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 12 database changes 2023-09-05 10:17:19.254 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.ABN1 2023-09-05 10:17:21.104 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 13 database changes 2023-09-05 10:17:21.104 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.ABN2 2023-09-05 10:17:21.149 [tongcdc-task-td1] INFO io.debezium.connector.common.BaseSourceTask - 12 records sent during previous 00:00:26.062, last recorded offset of {server=td1} partition is {snapshot_pending_tx=d201160013fb0100:2748884999045,490203003bb00000:2748884973391,c00014000b4d0600:2748884406501,a3001a0029e60400:2748885051649,ea01130058b20100:2748884701737,ca011e00a1890100:2748885036001,1d011600e7e50300:0,05010400d0430500:2748884939823,6802030007850000:2748884929314,b100170096900400:2748884977860,0201060007cf0300:2748885056397,0a010b00c4060600:2748884957222,c700210024a50500:2748885056087,32020a00bdc20000:2748885056059,970012009b900400:2748885056097,f7010b00e6550000:2748885056436,fd01060053540000:2748885056190,4f03210052400000:2748885056177,0d031600d64d0000:2748885032964,58030a00bd3f0000:2748884859037,7d00070085410000:2748885025461,1a000e00e44c0000:2748884974752,43001800165f0000:2748885026222,bb011100644b0000:2748885049435,80010e001e4e0000:2748885000997,61001400fe430000:2748885042423,fe011200ae490000:2748885035188,50030c00784a0000:2748885034704,19001700b6d40100:2748884989982,130016003cef0400:2748884891650,400004008c4f0000:2748884168692,1600090054490000:2748884174297,5d01010021460000:2748884168845,38030000893c0000:2748884168806,74000000d8530000:2748884168694,53001d00604c0000:2748884324155, snapshot_scn=2748885056445, snapshot=true, scn=2748885056445, snapshot_completed=false} 2023-09-05 10:17:23.151 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 14 database changes 2023-09-05 10:17:23.152 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AC01 2023-09-05 10:17:24.975 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 15 database changes 2023-09-05 10:17:24.976 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AC02 2023-09-05 10:17:26.904 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 16 database changes 2023-09-05 10:17:26.904 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AC04 2023-09-05 10:17:28.123 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AC05 2023-09-05 10:17:29.806 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 18 database changes 2023-09-05 10:17:29.806 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AC20 2023-09-05 10:17:31.441 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 19 database changes 2023-09-05 10:17:31.441 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AC35 2023-09-05 10:17:32.753 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 20 database changes 2023-09-05 10:17:32.754 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.ACDB 2023-09-05 10:17:33.903 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AE01 2023-09-05 10:17:34.956 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 22 database changes 2023-09-05 10:17:34.956 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AE03 2023-09-05 10:17:36.066 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AE06 2023-09-05 10:17:37.190 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 24 database changes 2023-09-05 10:17:37.190 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AE07 2023-09-05 10:17:38.369 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 25 database changes 2023-09-05 10:17:38.369 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AE32 2023-09-05 10:17:39.905 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.AE36 2023-09-05 10:17:41.153 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 27 database changes 2023-09-05 10:17:41.153 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.ICC2 2023-09-05 10:17:42.355 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 28 database changes 2023-09-05 10:17:42.356 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.ICN1 2023-09-05 10:17:43.552 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.JC02 2023-09-05 10:17:44.618 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 30 database changes 2023-09-05 10:17:44.619 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.JC04 2023-09-05 10:17:45.512 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.LBA8 2023-09-05 10:17:46.643 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.relational.history.SchemaHistoryMetrics - Already applied 32 database changes 2023-09-05 10:17:46.643 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Capturing structure of table PDB1.TEST_CDC1.LCN1 2023-09-05 10:17:47.500 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.relational.RelationalSnapshotChangeEventSource - Snapshot step 7 - Skipping snapshotting of data 2023-09-05 10:17:47.503 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.pipeline.source.AbstractSnapshotChangeEventSource - Snapshot - Final stage 2023-09-05 10:17:47.506 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.pipeline.source.AbstractSnapshotChangeEventSource - Snapshot completed 2023-09-05 10:17:47.506 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.pipeline.ChangeEventSourceCoordinator - Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=2748885056445, commit_scn=[]]] 2023-09-05 10:17:47.512 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.pipeline.ChangeEventSourceCoordinator - Connected metrics set to 'true' 2023-09-05 10:17:47.512 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO io.debezium.pipeline.ChangeEventSourceCoordinator - Starting streaming 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction d201160013fb0100 was pending across snapshot boundary. Start SCN = 2748884999045, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 490203003bb00000 was pending across snapshot boundary. Start SCN = 2748884973391, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction c00014000b4d0600 was pending across snapshot boundary. Start SCN = 2748884406501, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction a3001a0029e60400 was pending across snapshot boundary. Start SCN = 2748885051649, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction ea01130058b20100 was pending across snapshot boundary. Start SCN = 2748884701737, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction ca011e00a1890100 was pending across snapshot boundary. Start SCN = 2748885036001, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 1d011600e7e50300 was pending across snapshot boundary. Start SCN = 0, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] WARN i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 1d011600e7e50300 was still ongoing while snapshot was taken, but is no longer completely recorded in the archive logs. Events will be lost. Oldest SCN in logs = 2735421691226, TX start SCN = 0 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 05010400d0430500 was pending across snapshot boundary. Start SCN = 2748884939823, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 6802030007850000 was pending across snapshot boundary. Start SCN = 2748884929314, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction b100170096900400 was pending across snapshot boundary. Start SCN = 2748884977860, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 0201060007cf0300 was pending across snapshot boundary. Start SCN = 2748885056397, snapshot SCN = 2748885056445 2023-09-05 10:17:47.759 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 0a010b00c4060600 was pending across snapshot boundary. Start SCN = 2748884957222, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction c700210024a50500 was pending across snapshot boundary. Start SCN = 2748885056087, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 32020a00bdc20000 was pending across snapshot boundary. Start SCN = 2748885056059, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 970012009b900400 was pending across snapshot boundary. Start SCN = 2748885056097, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction f7010b00e6550000 was pending across snapshot boundary. Start SCN = 2748885056436, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction fd01060053540000 was pending across snapshot boundary. Start SCN = 2748885056190, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 4f03210052400000 was pending across snapshot boundary. Start SCN = 2748885056177, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 0d031600d64d0000 was pending across snapshot boundary. Start SCN = 2748885032964, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 58030a00bd3f0000 was pending across snapshot boundary. Start SCN = 2748884859037, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 7d00070085410000 was pending across snapshot boundary. Start SCN = 2748885025461, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 1a000e00e44c0000 was pending across snapshot boundary. Start SCN = 2748884974752, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 43001800165f0000 was pending across snapshot boundary. Start SCN = 2748885026222, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction bb011100644b0000 was pending across snapshot boundary. Start SCN = 2748885049435, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 80010e001e4e0000 was pending across snapshot boundary. Start SCN = 2748885000997, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 61001400fe430000 was pending across snapshot boundary. Start SCN = 2748885042423, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction fe011200ae490000 was pending across snapshot boundary. Start SCN = 2748885035188, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 50030c00784a0000 was pending across snapshot boundary. Start SCN = 2748885034704, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 19001700b6d40100 was pending across snapshot boundary. Start SCN = 2748884989982, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 130016003cef0400 was pending across snapshot boundary. Start SCN = 2748884891650, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 400004008c4f0000 was pending across snapshot boundary. Start SCN = 2748884168692, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 1600090054490000 was pending across snapshot boundary. Start SCN = 2748884174297, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 5d01010021460000 was pending across snapshot boundary. Start SCN = 2748884168845, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 38030000893c0000 was pending across snapshot boundary. Start SCN = 2748884168806, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 74000000d8530000 was pending across snapshot boundary. Start SCN = 2748884168694, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Transaction 53001d00604c0000 was pending across snapshot boundary. Start SCN = 2748884324155, snapshot SCN = 2748885056445 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Setting commit SCN to 2748885056444 (snapshot SCN - 1) to ensure we don't double-emit events from pre-snapshot transactions. 2023-09-05 10:17:47.760 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Resetting start SCN from 2748885056445 (snapshot SCN) to 2735421691226 (start of oldest complete pending transaction) 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Redo Log Group Sizes: 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Group #7: 2147483648 bytes 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Group #8: 2147483648 bytes 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Group #9: 2147483648 bytes 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Group #10: 2147483648 bytes 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Group #11: 2147483648 bytes 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Group #12: 2147483648 bytes 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Group #13: 2147483648 bytes 2023-09-05 10:18:00.003 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - Group #14: 2147483648 bytes 2023-09-05 10:21:44.142 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - starting mining session, startScn=2735421691225, endSnc=2735421791225 2023-09-05 10:22:09.491 [debezium-oracleconnector-td1-change-event-source-coordinator] INFO i.d.c.oracle.logminer.LogMinerStreamingChangeEventSource - starting mining session, startScn=2735421691225, endSnc=2748886601307