tun0 interface is not up, will try again in 1 second tun0 interface is not up, will try again in 1 second tun0 interface is not up, will try again in 1 second dev tun0 proto kernel scope link src 10. Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF8 __ ____ __ _____ ___ __ ____ ______ --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \ --\___\_\____/_/ |_/_/|_/_/|_|\____/___/ 2022-02-10 22:06:59,170 INFO [io.deb.ser.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$204/0x0000000840253040@9f6e406' stream name mapper 2022-02-10 22:06:59,267 INFO [io.deb.ser.red.RedisStreamChangeConsumer] (main) Using default Jedis 'redis.clients.jedis.Jedis@69b2f8e5' 2022-02-10 22:06:59,267 INFO [io.deb.ser.DebeziumServer] (main) Consumer 'io.debezium.server.redis.RedisStreamChangeConsumer' instantiated 2022-02-10 22:06:59,670 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-02-10 22:06:59,674 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2022-02-10 22:06:59,684 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 = None header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter internal.key.converter = class org.apache.kafka.connect.json.JsonConverter internal.value.converter = class org.apache.kafka.connect.json.JsonConverter key.converter = class org.apache.kafka.connect.json.JsonConverter listeners = null 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 = data/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 = [] rest.host.name = null rest.port = 8083 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-02-10 22:06:59,685 INFO [org.apa.kaf.con.run.WorkerConfig] (main) Worker configuration property 'internal.key.converter' is deprecated and may be removed in an upcoming release. The specified value 'org.apache.kafka.connect.json.JsonConverter' matches the default, so this property can be safely removed from the worker configuration. 2022-02-10 22:06:59,685 INFO [org.apa.kaf.con.run.WorkerConfig] (main) Worker configuration property 'internal.value.converter' is deprecated and may be removed in an upcoming release. The specified value 'org.apache.kafka.connect.json.JsonConverter' matches the default, so this property can be safely removed from the worker configuration. 2022-02-10 22:06:59,685 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-02-10 22:06:59,690 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-02-10 22:06:59,690 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-02-10 22:06:59,692 INFO [io.deb.ser.DebeziumServer] (main) Engine executor started 2022-02-10 22:06:59,797 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file data/offsets.dat 2022-02-10 22:07:00,389 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-02-10 22:07:00,391 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-02-10 22:07:00,467 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = data/db_history.dat 2022-02-10 22:07:00,467 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = dbzuser 2022-02-10 22:07:00,467 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = dev 2022-02-10 22:07:00,468 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tasks.max = 1 2022-02-10 22:07:00,468 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.destination.name = LOG_ARCHIVE_DEST_1 2022-02-10 22:07:00,469 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = dev 2022-02-10 22:07:00,469 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) event.processing.failure.handling.mode = warn 2022-02-10 22:07:00,470 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) internal.log.mining.dml.parser = legacy 2022-02-10 22:07:00,470 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.strategy = online_catalog 2022-02-10 22:07:00,471 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-02-10 22:07:00,471 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-02-10 22:07:00,471 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-02-10 22:07:00,471 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = data/offsets.dat 2022-02-10 22:07:00,471 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) column.exclude.list = GREENGO.PUB_SERVICE_AREAS.AREA_GEOM,GREENGO.PUB_PARKING_PLACES.AREA_GEOM 2022-02-10 22:07:00,472 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.11.250.101 2022-02-10 22:07:00,472 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-02-10 22:07:00,473 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = redis 2022-02-10 22:07:00,474 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) lob.enabled = true 2022-02-10 22:07:00,474 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.skip.unparseable.ddl = true 2022-02-10 22:07:00,474 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = GREENGO.PUB_VEHICLES,GREENGO.PUB_VEHICLE_TYPES,GREENGO.PUB_SERVICE_AREAS,GREENGO.PUB_PARKING_PLACES,GREENGO.PUB_CHARGERS,GREENGO.PUB_PARTNERS,GREENGO.COR_PARAMETER_VALUES,GREENGO.COM_INBOXES,GREENGO.PAY_BALANCES,GREENGO.PUB_PARTNER_BANK_CARDS,GREENGO.SAL_BALANCES,GREENGO.SAL_CONTRACT_PERSONS,GREENGO.SAL_CONTRACTS,GREENGO.SAL_RADAR,GREENGO.SAL_RENTAL_CANCELLATIONS,GREENGO.PUB_PARTNER_DOCUMENTS,GREENGO.SAL_CONTRACT_VEHICLES,GREENGO.COR_LOOKUP_VALUES,GREENGO.PUB_PARTNER_ADDRESSES,GREENGO.PUB_PARTNER_ACCEPTANCES 2022-02-10 22:07:00,475 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-02-10 22:07:00,475 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = schema_only 2022-02-10 22:07:00,672 INFO [io.quarkus] (main) debezium-server-dist 1.7.2.Final on JVM (powered by Quarkus 2.0.0.Final) started in 8.402s. Listening on: http://0.0.0.0:8080 2022-02-10 22:07:00,675 INFO [io.quarkus] (main) Profile prod activated. 2022-02-10 22:07:00,675 INFO [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health] 2022-02-10 22:07:04,193 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 2022-02-10 22:07:04,674 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@18415: OracleOffsetContext [scn=4591515566] 2022-02-10 22:07:04,675 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-02-10 22:07:04,988 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 20 change(s) in 312 ms 2022-02-10 22:07:05,279 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = dev named = change-event-source-coordinator 2022-02-10 22:07:05,281 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-dev-change-event-source-coordinator 2022-02-10 22:07:05,290 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Metrics registered 2022-02-10 22:07:05,371 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Context created 2022-02-10 22:07:05,380 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=4591515566]] 2022-02-10 22:07:05,386 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-dev-change-event-source-coordinator) Connected metrics set to 'true' 2022-02-10 22:07:05,386 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Starting streaming 2022-02-10 22:07:05,673 TRACE [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-dev-change-event-source-coordinator) Oldest SCN in logs is '4593966310' 2022-02-10 22:07:05,674 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-dev-change-event-source-coordinator) Mining session stopped due to the {}: io.debezium.DebeziumException: Online REDO LOG files or archive log files do not contain the offset scn 4591515566. Please perform a new snapshot. at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:116) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127) 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) 2022-02-10 22:07:05,680 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-dev-change-event-source-coordinator) Producer failure: io.debezium.DebeziumException: Online REDO LOG files or archive log files do not contain the offset scn 4591515566. Please perform a new snapshot. at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:116) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127) 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) 2022-02-10 22:07:05,681 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-dev-change-event-source-coordinator) startScn=4591515566, endScn=null 2022-02-10 22:07:05,681 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-dev-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=null, oldestScn=null, committedScn=null, offsetScn=null, logMinerQueryCount=0, totalProcessedRows=0, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT0S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT0S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT0S, totalBatchProcessingDuration=PT0S, lastBatchProcessingDuration=PT0S, maxBatchProcessingThroughput=0, currentLogFileName=[], minLogFilesMined=0, maxLogFilesMined=0, redoLogStatus=[], switchCounter=0, batchSize=20000, millisecondToSleepBetweenMiningQuery=1000, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT0S, lastStartLogMiningSessionDuration=PT0S, maxStartLogMiningSessionDuration=PT0S, totalProcessTime=PT0S, minBatchProcessTime=PT0S, maxBatchProcessTime=PT0S, totalResultSetNextTime=PT0S, lagFromTheSource=DurationPT0S, maxLagFromTheSourceDuration=PT0S, minLagFromTheSourceDuration=PT0S, lastCommitDuration=PT0S, maxCommitDuration=PT0S, activeTransactions=0, rolledBackTransactions=0, committedTransactions=0, abandonedTransactionIds=[], rolledbackTransactionIds=[], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=0, miningSessionUserGlobalAreaMaxMemory=0, miningSessionProcessGlobalAreaMemory=0, miningSessionProcessGlobalAreaMaxMemory=0} 2022-02-10 22:07:05,681 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-dev-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=4591515566] 2022-02-10 22:07:05,682 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Finished streaming 2022-02-10 22:07:05,682 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-dev-change-event-source-coordinator) Connected metrics set to 'false' 2022-02-10 22:07:05,787 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Stopping down connector 2022-02-10 22:07:05,811 INFO [io.deb.jdb.JdbcConnection] (pool-8-thread-1) Connection gracefully closed 2022-02-10 22:07:05,868 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Stopped FileOffsetBackingStore 2022-02-10 22:07:05,869 INFO [io.deb.ser.ConnectorLifecycle] (pool-7-thread-1) Connector completed: success = 'false', message = 'Error while trying to run connector class 'io.debezium.connector.oracle.OracleConnector'', error = '{}': org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:182) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127) 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: io.debezium.DebeziumException: Online REDO LOG files or archive log files do not contain the offset scn 4591515566. Please perform a new snapshot. at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:116) ... 8 more 2022-02-10 22:07:05,890 INFO [io.deb.ser.DebeziumServer] (main) Received request to stop the engine 2022-02-10 22:07:05,891 INFO [io.deb.emb.EmbeddedEngine] (main) Stopping the embedded engine 2022-02-10 22:07:05,977 INFO [io.quarkus] (main) debezium-server-dist stopped in 0.108s unable to retrieve container logs for cri-o://b1d69e3971c4ca250bd54fbc067c1e8a15894a208c8585c7dc150658aa82fb48 unable to retrieve container logs for cri-o://b1d69e3971c4ca250bd54fbc067c1e8a15894a208c8585c7dc150658aa82fb48 tun0 interface is not up, will try again in 1 second tun0 interface is not up, will try again in 1 second tun0 interface is not up, will try again in 1 second dev tun0 proto kernel scope link src 10. Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF8 __ ____ __ _____ ___ __ ____ ______ --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \ --\___\_\____/_/ |_/_/|_/_/|_|\____/___/ 2022-02-10 22:12:22,094 INFO [io.deb.ser.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$204/0x0000000840253040@70807224' stream name mapper 2022-02-10 22:12:22,197 INFO [io.deb.ser.red.RedisStreamChangeConsumer] (main) Using default Jedis 'redis.clients.jedis.Jedis@25c5e994' 2022-02-10 22:12:22,197 INFO [io.deb.ser.DebeziumServer] (main) Consumer 'io.debezium.server.redis.RedisStreamChangeConsumer' instantiated 2022-02-10 22:12:22,575 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-02-10 22:12:22,578 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2022-02-10 22:12:22,587 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 = None header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter internal.key.converter = class org.apache.kafka.connect.json.JsonConverter internal.value.converter = class org.apache.kafka.connect.json.JsonConverter key.converter = class org.apache.kafka.connect.json.JsonConverter listeners = null 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 = data/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 = [] rest.host.name = null rest.port = 8083 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-02-10 22:12:22,588 INFO [org.apa.kaf.con.run.WorkerConfig] (main) Worker configuration property 'internal.key.converter' is deprecated and may be removed in an upcoming release. The specified value 'org.apache.kafka.connect.json.JsonConverter' matches the default, so this property can be safely removed from the worker configuration. 2022-02-10 22:12:22,588 INFO [org.apa.kaf.con.run.WorkerConfig] (main) Worker configuration property 'internal.value.converter' is deprecated and may be removed in an upcoming release. The specified value 'org.apache.kafka.connect.json.JsonConverter' matches the default, so this property can be safely removed from the worker configuration. 2022-02-10 22:12:22,588 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-02-10 22:12:22,590 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-02-10 22:12:22,591 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2022-02-10 22:12:22,668 INFO [io.deb.ser.DebeziumServer] (main) Engine executor started 2022-02-10 22:12:22,692 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file data/offsets.dat 2022-02-10 22:12:23,180 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2022-02-10 22:12:23,182 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2022-02-10 22:12:23,182 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = data/db_history.dat 2022-02-10 22:12:23,182 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = dbzuser 2022-02-10 22:12:23,182 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = dev 2022-02-10 22:12:23,182 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tasks.max = 1 2022-02-10 22:12:23,183 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.destination.name = LOG_ARCHIVE_DEST_1 2022-02-10 22:12:23,183 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = dev 2022-02-10 22:12:23,183 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) event.processing.failure.handling.mode = warn 2022-02-10 22:12:23,183 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) internal.log.mining.dml.parser = legacy 2022-02-10 22:12:23,183 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.strategy = online_catalog 2022-02-10 22:12:23,183 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1521 2022-02-10 22:12:23,184 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2022-02-10 22:12:23,184 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2022-02-10 22:12:23,184 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = data/offsets.dat 2022-02-10 22:12:23,184 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) column.exclude.list = GREENGO.PUB_SERVICE_AREAS.AREA_GEOM,GREENGO.PUB_PARKING_PLACES.AREA_GEOM 2022-02-10 22:12:23,187 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 10.11.250.101 2022-02-10 22:12:23,187 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2022-02-10 22:12:23,187 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = redis 2022-02-10 22:12:23,188 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) lob.enabled = true 2022-02-10 22:12:23,188 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.skip.unparseable.ddl = true 2022-02-10 22:12:23,188 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = GREENGO.PUB_VEHICLES,GREENGO.PUB_VEHICLE_TYPES,GREENGO.PUB_SERVICE_AREAS,GREENGO.PUB_PARKING_PLACES,GREENGO.PUB_CHARGERS,GREENGO.PUB_PARTNERS,GREENGO.COR_PARAMETER_VALUES,GREENGO.COM_INBOXES,GREENGO.PAY_BALANCES,GREENGO.PUB_PARTNER_BANK_CARDS,GREENGO.SAL_BALANCES,GREENGO.SAL_CONTRACT_PERSONS,GREENGO.SAL_CONTRACTS,GREENGO.SAL_RADAR,GREENGO.SAL_RENTAL_CANCELLATIONS,GREENGO.PUB_PARTNER_DOCUMENTS,GREENGO.SAL_CONTRACT_VEHICLES,GREENGO.COR_LOOKUP_VALUES,GREENGO.PUB_PARTNER_ADDRESSES,GREENGO.PUB_PARTNER_ACCEPTANCES 2022-02-10 22:12:23,188 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2022-02-10 22:12:23,188 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = schema_only 2022-02-10 22:12:23,682 INFO [io.quarkus] (main) debezium-server-dist 1.7.2.Final on JVM (powered by Quarkus 2.0.0.Final) started in 8.610s. Listening on: http://0.0.0.0:8080 2022-02-10 22:12:23,684 INFO [io.quarkus] (main) Profile prod activated. 2022-02-10 22:12:23,684 INFO [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health] 2022-02-10 22:12:27,095 INFO [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 2022-02-10 22:12:27,584 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@18415: OracleOffsetContext [scn=4591515566] 2022-02-10 22:12:27,584 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2022-02-10 22:12:27,968 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 20 change(s) in 383 ms 2022-02-10 22:12:28,274 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = dev named = change-event-source-coordinator 2022-02-10 22:12:28,276 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-dev-change-event-source-coordinator 2022-02-10 22:12:28,286 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Metrics registered 2022-02-10 22:12:28,288 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Context created 2022-02-10 22:12:28,374 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=4591515566]] 2022-02-10 22:12:28,380 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-dev-change-event-source-coordinator) Connected metrics set to 'true' 2022-02-10 22:12:28,380 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Starting streaming 2022-02-10 22:12:28,678 TRACE [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-dev-change-event-source-coordinator) Oldest SCN in logs is '4593966310' 2022-02-10 22:12:28,679 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-dev-change-event-source-coordinator) Mining session stopped due to the {}: io.debezium.DebeziumException: Online REDO LOG files or archive log files do not contain the offset scn 4591515566. Please perform a new snapshot. at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:116) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127) 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) 2022-02-10 22:12:28,681 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-dev-change-event-source-coordinator) Producer failure: io.debezium.DebeziumException: Online REDO LOG files or archive log files do not contain the offset scn 4591515566. Please perform a new snapshot. at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:116) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127) 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) 2022-02-10 22:12:28,681 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-dev-change-event-source-coordinator) startScn=4591515566, endScn=null 2022-02-10 22:12:28,687 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-dev-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=null, oldestScn=null, committedScn=null, offsetScn=null, logMinerQueryCount=0, totalProcessedRows=0, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT0S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT0S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT0S, totalBatchProcessingDuration=PT0S, lastBatchProcessingDuration=PT0S, maxBatchProcessingThroughput=0, currentLogFileName=[], minLogFilesMined=0, maxLogFilesMined=0, redoLogStatus=[], switchCounter=0, batchSize=20000, millisecondToSleepBetweenMiningQuery=1000, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT0S, lastStartLogMiningSessionDuration=PT0S, maxStartLogMiningSessionDuration=PT0S, totalProcessTime=PT0S, minBatchProcessTime=PT0S, maxBatchProcessTime=PT0S, totalResultSetNextTime=PT0S, lagFromTheSource=DurationPT0S, maxLagFromTheSourceDuration=PT0S, minLagFromTheSourceDuration=PT0S, lastCommitDuration=PT0S, maxCommitDuration=PT0S, activeTransactions=0, rolledBackTransactions=0, committedTransactions=0, abandonedTransactionIds=[], rolledbackTransactionIds=[], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=0, miningSessionUserGlobalAreaMaxMemory=0, miningSessionProcessGlobalAreaMemory=0, miningSessionProcessGlobalAreaMaxMemory=0} 2022-02-10 22:12:28,687 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-dev-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=4591515566] 2022-02-10 22:12:28,687 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-dev-change-event-source-coordinator) Finished streaming 2022-02-10 22:12:28,688 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-dev-change-event-source-coordinator) Connected metrics set to 'false' 2022-02-10 22:12:28,781 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Stopping down connector 2022-02-10 22:12:28,810 INFO [io.deb.jdb.JdbcConnection] (pool-8-thread-1) Connection gracefully closed 2022-02-10 22:12:28,868 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Stopped FileOffsetBackingStore 2022-02-10 22:12:28,869 INFO [io.deb.ser.ConnectorLifecycle] (pool-7-thread-1) Connector completed: success = 'false', message = 'Error while trying to run connector class 'io.debezium.connector.oracle.OracleConnector'', error = '{}': org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:182) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127) 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: io.debezium.DebeziumException: Online REDO LOG files or archive log files do not contain the offset scn 4591515566. Please perform a new snapshot. at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:116) ... 8 more 2022-02-10 22:12:28,882 INFO [io.deb.ser.DebeziumServer] (main) Received request to stop the engine 2022-02-10 22:12:28,883 INFO [io.deb.emb.EmbeddedEngine] (main) Stopping the embedded engine 2022-02-10 22:12:28,975 INFO [io.quarkus] (main) debezium-server-dist stopped in 0.106s