Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF8 __ ____ __ _____ ___ __ ____ ______ --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \ --\___\_\____/_/ |_/_/|_/_/|_|\____/___/ 2021-12-21 18:36:13,584 INFO [io.deb.ser.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$204/0x0000000840253040@70807224' stream name mapper 2021-12-21 18:36:13,680 INFO [io.deb.ser.red.RedisStreamChangeConsumer] (main) Using default Jedis 'redis.clients.jedis.Jedis@25c5e994' 2021-12-21 18:36:13,681 INFO [io.deb.ser.DebeziumServer] (main) Consumer 'io.debezium.server.redis.RedisStreamChangeConsumer' instantiated 2021-12-21 18:36:13,989 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2021-12-21 18:36:13,992 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2021-12-21 18:36:14,000 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 2021-12-21 18:36:14,000 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. 2021-12-21 18:36:14,000 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. 2021-12-21 18:36:14,073 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. 2021-12-21 18:36:14,075 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2021-12-21 18:36:14,076 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2021-12-21 18:36:14,078 INFO [io.deb.ser.DebeziumServer] (main) Engine executor started 2021-12-21 18:36:14,092 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file data/offsets.dat 2021-12-21 18:36:14,686 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration: 2021-12-21 18:36:14,688 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.oracle.OracleConnector 2021-12-21 18:36:14,772 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history.file.filename = data/db_history.dat 2021-12-21 18:36:14,773 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = c##dbzuser 2021-12-21 18:36:14,773 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.dbname = CDB$ROOT 2021-12-21 18:36:14,773 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tasks.max = 1 2021-12-21 18:36:14,773 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.pdb.name = PDB1 2021-12-21 18:36:14,774 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.archive.destination.name = LOG_ARCHIVE_DEST_1 2021-12-21 18:36:14,774 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.url = jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(FAILOVER = on)(LOAD_BALANCE = off)(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.13.4)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.10.3)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = xxpdb1))) 2021-12-21 18:36:14,774 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.server.name = xxpdb1 2021-12-21 18:36:14,774 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) event.processing.failure.handling.mode = warn 2021-12-21 18:36:14,774 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) internal.log.mining.dml.parser = legacy 2021-12-21 18:36:14,774 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) log.mining.strategy = online_catalog 2021-12-21 18:36:14,775 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2021-12-21 18:36:14,775 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) tombstones.on.delete = false 2021-12-21 18:36:14,775 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = data/offsets.dat 2021-12-21 18:36:14,775 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) column.exclude.list = APPLICATION.PUB_SERVICE_AREAS.AREA_GEOM,APPLICATION.PUB_PARKING_PLACES.AREA_GEOM 2021-12-21 18:36:14,775 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2021-12-21 18:36:14,775 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = redis 2021-12-21 18:36:14,775 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) lob.enabled = true 2021-12-21 18:36:14,776 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = APPLICATION.PUB_VEHICLES,APPLICATION.PUB_VEHICLE_TYPES,APPLICATION.PUB_SERVICE_AREAS,APPLICATION.PUB_PARKING_PLACES,APPLICATION.PUB_CHARGERS,APPLICATION.PUB_PARTNERS,APPLICATION.COR_PARAMETER_VALUES,APPLICATION.COM_INBOXES,APPLICATION.PAY_BALANCES,APPLICATION.PUB_PARTNER_BANK_CARDS,APPLICATION.SAL_BALANCES,APPLICATION.SAL_CONTRACT_PERSONS,APPLICATION.SAL_CONTRACTS,APPLICATION.SAL_RADAR,APPLICATION.SAL_RENTAL_CANCELLATIONS,APPLICATION.PUB_PARTNER_DOCUMENTS,APPLICATION.SAL_CONTRACT_VEHICLES,APPLICATION.COR_LOOKUP_VALUES,APPLICATION.PUB_PARTNER_ADDRESSES,APPLICATION.PUB_PARTNER_ACCEPTANCES 2021-12-21 18:36:14,776 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.history = io.debezium.relational.history.FileDatabaseHistory 2021-12-21 18:36:14,776 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) snapshot.mode = schema_only 2021-12-21 18:36:15,277 INFO [io.quarkus] (main) debezium-server-dist 1.7.2.Final on JVM (powered by Quarkus 2.0.0.Final) started in 8.292s. Listening on: http://0.0.0.0:8080 2021-12-21 18:36:15,277 INFO [io.quarkus] (main) Profile prod activated. 2021-12-21 18:36:15,278 INFO [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health] 2021-12-21 18:36:18,476 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 2021-12-21 18:36:18,979 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Found previous partition offset io.debezium.connector.oracle.OraclePartition@d394fc03: OracleOffsetContext [scn=21613381402] 2021-12-21 18:36:18,979 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Started database history recovery 2021-12-21 18:36:19,284 INFO [io.deb.rel.his.DatabaseHistoryMetrics] (pool-7-thread-1) Finished database history recovery of 20 change(s) in 304 ms 2021-12-21 18:36:19,581 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = xxpdb1 named = change-event-source-coordinator 2021-12-21 18:36:19,583 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-xxpdb1-change-event-source-coordinator 2021-12-21 18:36:19,590 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Metrics registered 2021-12-21 18:36:19,591 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Context created 2021-12-21 18:36:19,680 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=SKIPPED, offset=OracleOffsetContext [scn=21613381402]] 2021-12-21 18:36:19,684 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Connected metrics set to 'true' 2021-12-21 18:36:19,684 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Starting streaming 2021-12-21 18:36:51,794 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 2 records sent during previous 00:00:37.411, last recorded offset: {commit_scn=21613438459, transaction_id=null, scn=21613438457} 2021-12-21 18:38:16,765 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 5 records sent during previous 00:01:24.971, last recorded offset: {commit_scn=21613474506, transaction_id=null, scn=21613474341} 2021-12-21 18:39:12,893 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 3 records sent during previous 00:00:56.128, last recorded offset: {commit_scn=21613489977, transaction_id=null, scn=21613489886} 2021-12-21 18:41:32,178 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 3 records sent during previous 00:02:19.285, last recorded offset: {commit_scn=21613498359, transaction_id=null, scn=21613531175} 2021-12-21 18:46:56,846 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 9 records sent during previous 00:05:24.668, last recorded offset: {commit_scn=21613649700, transaction_id=null, scn=21613641511} 2021-12-21 18:57:53,705 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 20 records sent during previous 00:10:56.859, last recorded offset: {commit_scn=21613906005, transaction_id=null, scn=21613898587} 2021-12-21 19:19:50,916 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 61 records sent during previous 00:21:57.211, last recorded offset: {commit_scn=21614415434, transaction_id=null, scn=21614412569} 2021-12-21 19:31:18,866 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Mining session stopped due to the {}: java.lang.IllegalStateException: None of log files contains offset SCN: 21614709113, re-snapshot is required. at io.debezium.connector.oracle.logminer.LogMinerHelper.setLogFilesForMining(LogMinerHelper.java:94) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.initializeRedoLogsForMining(LogMinerStreamingChangeEventSource.java:251) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:158) 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) 2021-12-21 19:31:18,869 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Producer failure: java.lang.IllegalStateException: None of log files contains offset SCN: 21614709113, re-snapshot is required. at io.debezium.connector.oracle.logminer.LogMinerHelper.setLogFilesForMining(LogMinerHelper.java:94) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.initializeRedoLogsForMining(LogMinerStreamingChangeEventSource.java:251) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:158) 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) 2021-12-21 19:31:18,869 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) startScn=21614709113, endScn=21614713062 2021-12-21 19:31:18,870 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=21614713062, oldestScn=21614709114, committedScn=21614709646, offsetScn=21614700443, logMinerQueryCount=562, totalProcessedRows=1659619, totalCapturedDmlCount=243, totalDurationOfFetchingQuery=PT27M5.530417S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT10.761361S, maxCapturedDmlCount=6, maxDurationOfFetchingQuery=PT11.065174S, totalBatchProcessingDuration=PT28M6.688245S, lastBatchProcessingDuration=PT10.827719S, maxBatchProcessingThroughput=4, currentLogFileName=[+RECO/PROD1_FRA3JF/ONLINELOG/group_1.268.989799417], minLogFilesMined=1, maxLogFilesMined=1, redoLogStatus=[+RECO/PROD1_FRA3JF/ONLINELOG/group_3.270.989799433 | ACTIVE, +RECO/PROD1_FRA3JF/ONLINELOG/group_1.268.989799417 | CURRENT, +RECO/PROD1_FRA3JF/ONLINELOG/group_2.269.989799423 | INACTIVE], switchCounter=43, batchSize=20000, millisecondToSleepBetweenMiningQuery=3000, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0.040834S, totalStartLogMiningSessionDuration=PT7.023909S, lastStartLogMiningSessionDuration=PT0.010281S, maxStartLogMiningSessionDuration=PT0.080532S, totalProcessTime=PT28M6.688245S, minBatchProcessTime=PT0.3234S, maxBatchProcessTime=PT12.444325S, totalResultSetNextTime=PT19.180308S, lagFromTheSource=DurationPT10.930126S, maxLagFromTheSourceDuration=PT3M21.183016S, minLagFromTheSourceDuration=PT0.451283S, lastCommitDuration=PT0.000001S, maxCommitDuration=PT0.083713S, activeTransactions=1, rolledBackTransactions=1, committedTransactions=438184, abandonedTransactionIds=[], rolledbackTransactionIds=[210014007d8f0900], registeredDmlCount=243, committedDmlCount=128, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=3902560, miningSessionUserGlobalAreaMaxMemory=7335080, miningSessionProcessGlobalAreaMemory=567984072, miningSessionProcessGlobalAreaMaxMemory=614121416} 2021-12-21 19:31:18,870 INFO [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=21614709113] 2021-12-21 19:31:18,870 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Finished streaming 2021-12-21 19:31:18,870 INFO [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-xxpdb1-change-event-source-coordinator) Connected metrics set to 'false' 2021-12-21 19:31:19,300 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Stopping down connector 2021-12-21 19:31:19,306 INFO [io.deb.jdb.JdbcConnection] (pool-8-thread-1) Connection gracefully closed 2021-12-21 19:31:19,307 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Stopped FileOffsetBackingStore 2021-12-21 19:31:19,308 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: java.lang.IllegalStateException: None of log files contains offset SCN: 21614709113, re-snapshot is required. at io.debezium.connector.oracle.logminer.LogMinerHelper.setLogFilesForMining(LogMinerHelper.java:94) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.initializeRedoLogsForMining(LogMinerStreamingChangeEventSource.java:251) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:158) ... 8 more 2021-12-21 19:31:19,319 INFO [io.deb.ser.DebeziumServer] (main) Received request to stop the engine 2021-12-21 19:31:19,319 INFO [io.deb.emb.EmbeddedEngine] (main) Stopping the embedded engine 2021-12-21 19:31:19,332 INFO [io.quarkus] (main) debezium-server-dist stopped in 0.024s