__ ____ __ _____ ___ __ ____ ______ --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \ --\___\_\____/_/ |_/_/|_/_/|_|\____/___/ 2023-04-25 14:19:47,816 DEBUG [org.jbo.logging] (main) Logging Provider: org.jboss.logging.JBossLogManagerProvider 2023-04-25 14:19:48,108 DEBUG [io.net.uti.int.log.InternalLoggerFactory] (main) Using SLF4J as the default logging framework 2023-04-25 14:19:48,109 DEBUG [io.net.uti.int.InternalThreadLocalMap] (main) -Dio.netty.threadLocalMap.stringBuilder.initialSize: 1024 2023-04-25 14:19:48,109 DEBUG [io.net.uti.int.InternalThreadLocalMap] (main) -Dio.netty.threadLocalMap.stringBuilder.maxSize: 4096 2023-04-25 14:19:48,113 DEBUG [io.qua.arc.impl] (main) ArC DI container initialized [beans=52, observers=4] 2023-04-25 14:19:48,135 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.IIOImageProvider() 2023-04-25 14:19:48,137 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.IIOImageProvider() 2023-04-25 14:19:48,138 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.IIOImageProvider() 2023-04-25 14:19:48,138 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.IIOImageProvider() 2023-04-25 14:19:48,139 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.sse.SseEventProvider() 2023-04-25 14:19:48,145 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.sse.SseEventProvider() 2023-04-25 14:19:48,146 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.sse.SseEventProvider() 2023-04-25 14:19:48,146 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.sse.SseEventProvider() 2023-04-25 14:19:48,146 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DefaultTextPlain() 2023-04-25 14:19:48,146 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DefaultTextPlain() 2023-04-25 14:19:48,146 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DefaultTextPlain() 2023-04-25 14:19:48,146 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DefaultTextPlain() 2023-04-25 14:19:48,146 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ReactiveStreamProvider() 2023-04-25 14:19:48,147 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.interceptors.CacheControlFeature() 2023-04-25 14:19:48,147 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.interceptors.CacheControlFeature() 2023-04-25 14:19:48,148 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.interceptors.ServerContentEncodingAnnotationFeature() 2023-04-25 14:19:48,148 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.FormUrlEncodedProvider() 2023-04-25 14:19:48,149 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.FormUrlEncodedProvider() 2023-04-25 14:19:48,149 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.CompletionStageProvider() 2023-04-25 14:19:48,149 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.interceptors.ClientContentEncodingAnnotationFeature() 2023-04-25 14:19:48,149 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DefaultNumberWriter() 2023-04-25 14:19:48,149 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DefaultNumberWriter() 2023-04-25 14:19:48,150 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.SourceProvider() 2023-04-25 14:19:48,150 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.SourceProvider() 2023-04-25 14:19:48,150 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.SourceProvider() 2023-04-25 14:19:48,150 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.SourceProvider() 2023-04-25 14:19:48,152 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider() 2023-04-25 14:19:48,157 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider() 2023-04-25 14:19:48,157 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider() 2023-04-25 14:19:48,157 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider() 2023-04-25 14:19:48,158 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.jackson.UnrecognizedPropertyExceptionHandler() 2023-04-25 14:19:48,159 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.FileProvider() 2023-04-25 14:19:48,159 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.FileProvider() 2023-04-25 14:19:48,159 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.FileProvider() 2023-04-25 14:19:48,159 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.FileProvider() 2023-04-25 14:19:48,161 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.MultiValuedParamConverterProvider() 2023-04-25 14:19:48,163 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DocumentProvider(org.jboss.resteasy.spi.ResteasyConfiguration) 2023-04-25 14:19:48,163 DEBUG [org.jbo.res.res.i18n] (main) Provider : org.jboss.resteasy.plugins.providers.DocumentProvider, Method : DocumentProvider 2023-04-25 14:19:48,164 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DocumentProvider(org.jboss.resteasy.spi.ResteasyConfiguration) 2023-04-25 14:19:48,164 DEBUG [org.jbo.res.res.i18n] (main) Provider : org.jboss.resteasy.plugins.providers.DocumentProvider, Method : DocumentProvider 2023-04-25 14:19:48,164 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DocumentProvider(org.jboss.resteasy.spi.ResteasyConfiguration) 2023-04-25 14:19:48,164 DEBUG [org.jbo.res.res.i18n] (main) Provider : org.jboss.resteasy.plugins.providers.DocumentProvider, Method : DocumentProvider 2023-04-25 14:19:48,164 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DocumentProvider(org.jboss.resteasy.spi.ResteasyConfiguration) 2023-04-25 14:19:48,164 DEBUG [org.jbo.res.res.i18n] (main) Provider : org.jboss.resteasy.plugins.providers.DocumentProvider, Method : DocumentProvider 2023-04-25 14:19:48,165 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DefaultBooleanWriter() 2023-04-25 14:19:48,165 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DefaultBooleanWriter() 2023-04-25 14:19:48,165 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ByteArrayProvider() 2023-04-25 14:19:48,165 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ByteArrayProvider() 2023-04-25 14:19:48,165 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ByteArrayProvider() 2023-04-25 14:19:48,165 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ByteArrayProvider() 2023-04-25 14:19:48,166 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.StringTextStar() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.StringTextStar() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.StringTextStar() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.StringTextStar() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.StreamingOutputProvider() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.StreamingOutputProvider() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ReaderProvider() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ReaderProvider() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ReaderProvider() 2023-04-25 14:19:48,167 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.ReaderProvider() 2023-04-25 14:19:48,168 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DataSourceProvider() 2023-04-25 14:19:48,168 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DataSourceProvider() 2023-04-25 14:19:48,168 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DataSourceProvider() 2023-04-25 14:19:48,168 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.DataSourceProvider() 2023-04-25 14:19:48,168 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.JaxrsFormProvider() 2023-04-25 14:19:48,168 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.JaxrsFormProvider() 2023-04-25 14:19:48,168 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.JaxrsFormProvider() 2023-04-25 14:19:48,168 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.JaxrsFormProvider() 2023-04-25 14:19:48,169 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.AsyncStreamingOutputProvider() 2023-04-25 14:19:48,169 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.AsyncStreamingOutputProvider() 2023-04-25 14:19:48,169 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.FileRangeWriter() 2023-04-25 14:19:48,169 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.FileRangeWriter() 2023-04-25 14:19:48,169 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.InputStreamProvider() 2023-04-25 14:19:48,169 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.InputStreamProvider() 2023-04-25 14:19:48,169 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.InputStreamProvider() 2023-04-25 14:19:48,169 DEBUG [io.qua.res.runtime] (main) Create constructor: public org.jboss.resteasy.plugins.providers.InputStreamProvider() 2023-04-25 14:19:48,172 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.ForbiddenExceptionMapper() 2023-04-25 14:19:48,173 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.AuthenticationFailedExceptionMapper() 2023-04-25 14:19:48,173 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.AuthenticationCompletionExceptionMapper() 2023-04-25 14:19:48,174 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.CompositeExceptionMapper() 2023-04-25 14:19:48,174 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.common.runtime.jackson.QuarkusObjectMapperContextResolver() 2023-04-25 14:19:48,257 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.AuthenticationRedirectExceptionMapper() 2023-04-25 14:19:48,258 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.vertx.JsonObjectWriter() 2023-04-25 14:19:48,259 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.vertx.JsonObjectWriter() 2023-04-25 14:19:48,259 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.common.runtime.jackson.QuarkusJacksonSerializer() 2023-04-25 14:19:48,259 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.common.runtime.jackson.QuarkusJacksonSerializer() 2023-04-25 14:19:48,259 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.common.runtime.jackson.QuarkusJacksonSerializer() 2023-04-25 14:19:48,259 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.common.runtime.jackson.QuarkusJacksonSerializer() 2023-04-25 14:19:48,259 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.vertx.JsonArrayReader() 2023-04-25 14:19:48,260 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.vertx.JsonArrayReader() 2023-04-25 14:19:48,260 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.vertx.JsonArrayWriter() 2023-04-25 14:19:48,260 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.vertx.JsonArrayWriter() 2023-04-25 14:19:48,260 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.vertx.JsonObjectReader() 2023-04-25 14:19:48,260 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.vertx.JsonObjectReader() 2023-04-25 14:19:48,261 DEBUG [io.qua.res.runtime] (main) Create constructor: public io.quarkus.resteasy.runtime.UnauthorizedExceptionMapper() 2023-04-25 14:19:48,304 DEBUG [io.net.uti.int.PlatformDependent0] (main) -Dio.netty.noUnsafe: false 2023-04-25 14:19:48,304 DEBUG [io.net.uti.int.PlatformDependent0] (main) Java version: 19 2023-04-25 14:19:48,305 DEBUG [io.net.uti.int.PlatformDependent0] (main) java.nio.Buffer.address: available 2023-04-25 14:19:48,305 DEBUG [io.net.uti.int.PlatformDependent0] (main) java.nio.Bits.unaligned: available, true 2023-04-25 14:19:48,306 DEBUG [io.net.uti.int.PlatformDependent0] (main) java.nio.DirectByteBuffer.(long, int): unavailable 2023-04-25 14:19:48,306 DEBUG [io.net.uti.int.PlatformDependent] (main) sun.misc.Unsafe: available 2023-04-25 14:19:48,311 DEBUG [io.net.uti.int.PlatformDependent] (main) maxDirectMemory: 6442450944 bytes (maybe) 2023-04-25 14:19:48,311 DEBUG [io.net.uti.int.PlatformDependent] (main) -Dio.netty.tmpdir: /var/folders/y3/3vnrv9lj74d5xxvvvpdj2qv00000gp/T (java.io.tmpdir) 2023-04-25 14:19:48,311 DEBUG [io.net.uti.int.PlatformDependent] (main) -Dio.netty.bitMode: 64 (sun.arch.data.model) 2023-04-25 14:19:48,311 DEBUG [io.net.uti.int.PlatformDependent] (main) Platform: MacOS 2023-04-25 14:19:48,311 DEBUG [io.net.uti.int.PlatformDependent] (main) -Dio.netty.maxDirectMemory: -1 bytes 2023-04-25 14:19:48,311 DEBUG [io.net.uti.int.PlatformDependent] (main) -Dio.netty.uninitializedArrayAllocationThreshold: -1 2023-04-25 14:19:48,311 DEBUG [io.net.uti.int.CleanerJava9] (main) java.nio.ByteBuffer.cleaner(): available 2023-04-25 14:19:48,311 DEBUG [io.net.uti.int.PlatformDependent] (main) -Dio.netty.noPreferDirect: false 2023-04-25 14:19:48,314 DEBUG [io.ver.cor.log.LoggerFactory] (main) Using io.vertx.core.logging.SLF4JLogDelegateFactory 2023-04-25 14:19:48,318 DEBUG [io.qua.ver.cor.run.VertxCoreRecorder] (main) Vert.x Cache configured to: /var/folders/y3/3vnrv9lj74d5xxvvvpdj2qv00000gp/T/vertx-cache/798794120795369973 2023-04-25 14:19:48,324 DEBUG [io.net.uti.ResourceLeakDetector] (main) -Dio.netty.leakDetection.level: simple 2023-04-25 14:19:48,324 DEBUG [io.net.uti.ResourceLeakDetector] (main) -Dio.netty.leakDetection.targetRecords: 4 2023-04-25 14:19:48,331 DEBUG [io.net.cha.MultithreadEventLoopGroup] (main) -Dio.netty.eventLoopThreads: 16 2023-04-25 14:19:48,337 DEBUG [io.net.cha.nio.NioEventLoop] (main) -Dio.netty.noKeySetOptimization: false 2023-04-25 14:19:48,337 DEBUG [io.net.cha.nio.NioEventLoop] (main) -Dio.netty.selectorAutoRebuildThreshold: 512 2023-04-25 14:19:48,340 DEBUG [io.net.uti.int.PlatformDependent] (main) org.jctools-core.MpscChunkedArrayQueue: available 2023-04-25 14:19:48,349 DEBUG [io.qua.ver.cor.run.VertxCoreRecorder] (main) Vertx has Native Transport Enabled: false 2023-04-25 14:19:48,353 DEBUG [io.net.cha.DefaultChannelId] (Thread-2) -Dio.netty.processId: 45416 (auto-detected) 2023-04-25 14:19:48,353 DEBUG [io.net.cha.DefaultChannelId] (Thread-2) -Dio.netty.machineId: 43:84:8f:9b:f3:5f:63:3d (user-set) 2023-04-25 14:19:48,356 WARN [io.qua.run.con.ConfigRecorder] (main) Build time property cannot be changed at runtime: - quarkus.naming.enable-jndi is set to 'true' but it is build time fixed to 'false'. Did you change the property quarkus.naming.enable-jndi after building the application? 2023-04-25 14:19:48,356 WARN [io.qua.run.log.LoggingSetupRecorder] (main) Root log level TRACE set below minimum logging level DEBUG, promoting it to DEBUG 2023-04-25 14:19:48,401 DEBUG [io.deb.ser.DebeziumServer] (main) Found 1 candidate consumer(s) 2023-04-25 14:19:48,403 INFO [io.deb.ser.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$215/0x000000080124c8d0@5e3a39cd' stream name mapper 2023-04-25 14:19:48,476 INFO [io.deb.ser.htt.HttpChangeConsumer] (main) Using http content-type type application/json 2023-04-25 14:19:48,476 INFO [io.deb.ser.htt.HttpChangeConsumer] (main) Using sink URL: http://127.0.0.1:5555 2023-04-25 14:19:48,477 INFO [io.deb.ser.DebeziumServer] (main) Consumer 'io.debezium.server.http.HttpChangeConsumer' instantiated 2023-04-25 14:19:48,481 DEBUG [io.deb.ser.DebeziumServer] (main) Configuration for DebeziumEngine: {connector.class=io.debezium.connector.sqlserver.SqlServerConnector, offset.storage.http.url=http://127.0.0.1:5555, transforms.unwrap.delete.handling.mode=rewrite, transforms=unwrap, schema.history.internal.file.filename=FileDatabaseHistory.dat, topic.prefix=, offset.storage.file.filename=offsets.dat, transforms.unwrap.type=io.debezium.transforms.ExtractNewRecordState, database.encrypt=true, database.user=sqlserver, database.names=aw2019, key.converter.value=json, transforms.unwrap.add.headers=db, database.port=1433, value.converter.value=json, offset.flush.interval.ms=0, key.converter.schemas.enable=false, schema.history.internal=io.debezium.storage.file.history.FileSchemaHistory, database.hostname=, database.password=, value.converter.schemas.enable=false, schema.history.internal.http.url=http://127.0.0.1:5555, name=http, transforms.unwrap.add.fields=op,table,source.ts_ms, table.include.list=Person.ContactType5, database.trustServerCertificate=true} 2023-04-25 14:19:48,515 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2023-04-25 14:19:48,516 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2023-04-25 14:19:48,528 INFO [io.deb.emb.EmbeddedEngine$EmbeddedConfig] (main) EmbeddedConfig values: access.control.allow.methods = access.control.allow.origin = admin.listeners = null bootstrap.servers = [localhost:9092] client.dns.lookup = use_all_dns_ips config.providers = [] connector.client.config.override.policy = All header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter key.converter = class org.apache.kafka.connect.json.JsonConverter listeners = [http://:8083] metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 offset.flush.interval.ms = 0 offset.flush.timeout.ms = 5000 offset.storage.file.filename = offsets.dat offset.storage.partitions = null offset.storage.replication.factor = null offset.storage.topic = plugin.path = null response.http.headers.config = rest.advertised.host.name = null rest.advertised.listener = null rest.advertised.port = null rest.extension.classes = [] ssl.cipher.suites = null ssl.client.auth = none ssl.enabled.protocols = [TLSv1.2, TLSv1.3] ssl.endpoint.identification.algorithm = https ssl.engine.factory.class = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.certificate.chain = null ssl.keystore.key = null ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLSv1.3 ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.certificates = null ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS task.shutdown.graceful.timeout.ms = 5000 topic.creation.enable = true topic.tracking.allow.reset = true topic.tracking.enable = true value.converter = class org.apache.kafka.connect.json.JsonConverter 2023-04-25 14:19:48,528 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. 2023-04-25 14:19:48,529 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2023-04-25 14:19:48,529 INFO [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2023-04-25 14:19:48,530 INFO [io.deb.ser.DebeziumServer] (main) Engine executor started 2023-04-25 14:19:48,541 DEBUG [io.net.uti.NetUtil] (vert.x-eventloop-thread-0) -Djava.net.preferIPv4Stack: false 2023-04-25 14:19:48,541 DEBUG [io.net.uti.NetUtil] (vert.x-eventloop-thread-0) -Djava.net.preferIPv6Addresses: false 2023-04-25 14:19:48,543 DEBUG [io.net.uti.NetUtilInitializations] (vert.x-eventloop-thread-0) Loopback interface: lo0 (lo0, 0:0:0:0:0:0:0:1%lo0) 2023-04-25 14:19:48,546 DEBUG [io.net.uti.NetUtil] (vert.x-eventloop-thread-0) Failed to get SOMAXCONN from sysctl and file /proc/sys/net/core/somaxconn. Default: 128 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.numHeapArenas: 16 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.numDirectArenas: 16 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.pageSize: 8192 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.maxOrder: 3 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.chunkSize: 65536 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.smallCacheSize: 256 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.normalCacheSize: 64 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.maxCachedBufferCapacity: 32768 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.cacheTrimInterval: 8192 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.cacheTrimIntervalMillis: 0 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.useCacheForAllThreads: false 2023-04-25 14:19:48,582 DEBUG [io.net.buf.PooledByteBufAllocator] (vert.x-eventloop-thread-0) -Dio.netty.allocator.maxCachedByteBuffersPerChunk: 1023 2023-04-25 14:19:48,602 DEBUG [io.net.buf.ByteBufUtil] (vert.x-eventloop-thread-0) -Dio.netty.allocator.type: pooled 2023-04-25 14:19:48,602 DEBUG [io.net.buf.ByteBufUtil] (vert.x-eventloop-thread-0) -Dio.netty.threadLocalDirectBufferSize: 0 2023-04-25 14:19:48,602 DEBUG [io.net.buf.ByteBufUtil] (vert.x-eventloop-thread-0) -Dio.netty.maxThreadLocalCharBufferSize: 16384 2023-04-25 14:19:48,611 INFO [io.quarkus] (main) debezium-server-dist 2.1.3.Final on JVM (powered by Quarkus 2.16.3.Final) started in 0.943s. Listening on: http://0.0.0.0:8080 2023-04-25 14:19:48,612 INFO [io.quarkus] (main) Profile prod activated. 2023-04-25 14:19:48,612 INFO [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health, vertx] 2023-04-25 14:19:48,615 FINE [com.mic.sql.jdb.Driver] (pool-7-thread-1) Microsoft JDBC Driver 10.2.1.0 for SQL Server 2023-04-25 14:19:48,615 FINE [com.mic.sql.jdb.int.SQLServerDriver] (pool-7-thread-1) Property:serverName Value: 2023-04-25 14:19:48,615 FINE [com.mic.sql.jdb.int.SQLServerDriver] (pool-7-thread-1) Property:portNumber Value:1433 2023-04-25 14:19:48,615 FINE [com.mic.sql.jdb.int.SQLServerDriver] (pool-7-thread-1) Property:databaseName Value:aw2019 2023-04-25 14:19:48,649 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:1 created by (SQLServerDriver:2) 2023-04-25 14:19:48,650 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:1 This attempt server name: port: 1433 InstanceName: null useParallel: false 2023-04-25 14:19:48,651 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:1 This attempt endtime: 1682457590525 2023-04-25 14:19:48,651 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:1 This attempt No: 0 2023-04-25 14:19:48,651 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:1 Connecting with server: port: 1433 Timeout slice: 1874 Timeout Full: 15 2023-04-25 14:19:48,776 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:1 ClientConnectionId: 21bbb2e6-97e5-450d-a5dd-3526d93fb8ce Server returned major version:15 2023-04-25 14:19:48,999 DEBUG [io.deb.jdb.JdbcConnection] (pool-7-thread-1) Connected to jdbc:sqlserver://:1433;databaseName=aw2019 with {password=***, names=aw2019, encrypt=true, trustServerCertificate=true, user=sqlserver} 2023-04-25 14:19:49,066 FINE [com.mic.sql.jdb.int.SQLServerStatement] (pool-7-thread-1) SQLServerStatement:1 created by (ConnectionID:1 ClientConnectionId: 21bbb2e6-97e5-450d-a5dd-3526d93fb8ce) 2023-04-25 14:19:49,066 FINE [com.mic.sql.jdb.int.SQLServerStatement] (pool-7-thread-1) SQLServerStatement:1 Executing (not server cursor) SELECT @@VERSION 2023-04-25 14:19:49,162 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (pool-7-thread-1) SQLServerResultSet:1 created by (SQLServerStatement:1) 2023-04-25 14:19:49,220 DEBUG [io.deb.con.sql.SqlServerConnector] (pool-7-thread-1) Successfully tested connection for jdbc:sqlserver://:1433;databaseName=aw2019 with user 'sqlserver' 2023-04-25 14:19:49,220 INFO [io.deb.con.sql.SqlServerConnector] (pool-7-thread-1) Checking if user has access to CDC table 2023-04-25 14:19:49,221 FINE [com.mic.sql.jdb.int.SQLServerStatement] (pool-7-thread-1) SQLServerStatement:2 created by (ConnectionID:1 ClientConnectionId: 21bbb2e6-97e5-450d-a5dd-3526d93fb8ce) 2023-04-25 14:19:49,221 FINE [com.mic.sql.jdb.int.SQLServerStatement] (pool-7-thread-1) SQLServerStatement:2 Executing (not server cursor) EXEC [aw2019].sys.sp_cdc_help_change_data_capture 2023-04-25 14:19:49,321 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (pool-7-thread-1) SQLServerResultSet:2 created by (SQLServerStatement:2) 2023-04-25 14:19:49,331 INFO [io.deb.jdb.JdbcConnection] (pool-9-thread-1) Connection gracefully closed 2023-04-25 14:19:49,345 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file offsets.dat 2023-04-25 14:19:49,349 DEBUG [io.deb.ser.ConnectorLifecycle] (pool-7-thread-1) Connector started 2023-04-25 14:19:49,351 FINE [com.mic.sql.jdb.Driver] (pool-7-thread-1) Microsoft JDBC Driver 10.2.1.0 for SQL Server 2023-04-25 14:19:49,351 FINE [com.mic.sql.jdb.int.SQLServerDriver] (pool-7-thread-1) Property:serverName Value: 2023-04-25 14:19:49,351 FINE [com.mic.sql.jdb.int.SQLServerDriver] (pool-7-thread-1) Property:portNumber Value:1433 2023-04-25 14:19:49,351 FINE [com.mic.sql.jdb.int.SQLServerDriver] (pool-7-thread-1) Property:databaseName Value:aw2019 2023-04-25 14:19:49,351 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:2 created by (SQLServerDriver:3) 2023-04-25 14:19:49,352 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:2 This attempt server name: port: 1433 InstanceName: null useParallel: false 2023-04-25 14:19:49,352 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:2 This attempt endtime: 1682457591226 2023-04-25 14:19:49,352 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:2 This attempt No: 0 2023-04-25 14:19:49,352 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:2 Connecting with server: port: 1433 Timeout slice: 1874 Timeout Full: 15 2023-04-25 14:19:49,477 FINE [com.mic.sql.jdb.int.SQLServerConnection] (pool-7-thread-1) ConnectionID:2 ClientConnectionId: 29ea8171-56a1-42e1-8fbb-33f7084ca880 Server returned major version:15 2023-04-25 14:19:49,668 DEBUG [io.deb.jdb.JdbcConnection] (pool-7-thread-1) Connected to jdbc:sqlserver://:1433;databaseName=aw2019 with {password=***, names=aw2019, encrypt=true, trustServerCertificate=true, user=sqlserver} 2023-04-25 14:19:49,741 FINE [com.mic.sql.jdb.int.SQLServerStatement] (pool-7-thread-1) SQLServerPreparedStatement:3 created by (ConnectionID:2 ClientConnectionId: 29ea8171-56a1-42e1-8fbb-33f7084ca880) 2023-04-25 14:19:49,755 FINE [com.mic.sql.jdb.int.SQLServerStatement] (pool-7-thread-1) SQLServerPreparedStatement:3: calling sp_executesql: SQL:SELECT name FROM sys.databases WHERE name = @P0 2023-04-25 14:19:49,818 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (pool-7-thread-1) SQLServerResultSet:3 created by (SQLServerPreparedStatement:3) 2023-04-25 14:19:49,824 INFO [io.deb.jdb.JdbcConnection] (pool-10-thread-1) Connection gracefully closed 2023-04-25 14:19:49,832 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting SqlServerConnectorTask with configuration: 2023-04-25 14:19:49,833 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) connector.class = io.debezium.connector.sqlserver.SqlServerConnector 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.http.url = http://127.0.0.1:5555 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) transforms.unwrap.delete.handling.mode = rewrite 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) transforms = unwrap 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) schema.history.internal.file.filename = FileDatabaseHistory.dat 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) topic.prefix = 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage.file.filename = offsets.dat 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) transforms.unwrap.type = io.debezium.transforms.ExtractNewRecordState 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) errors.retry.delay.initial.ms = 300 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter = org.apache.kafka.connect.json.JsonConverter 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter = org.apache.kafka.connect.json.JsonConverter 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.encrypt = true 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.user = 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.names = aw2019 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore 2023-04-25 14:19:49,834 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.value = json 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.timeout.ms = 5000 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) errors.retry.delay.max.ms = 10000 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) transforms.unwrap.add.headers = db 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.port = 1433 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.value = json 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) offset.flush.interval.ms = 0 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) key.converter.schemas.enable = false 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) schema.history.internal = io.debezium.storage.file.history.FileSchemaHistory 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) errors.max.retries = -1 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.hostname = 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.password = ******** 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) value.converter.schemas.enable = false 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) name = http 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) schema.history.internal.http.url = http://127.0.0.1:5555 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) transforms.unwrap.add.fields = op,table,source.ts_ms 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) task.id = 0 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) table.include.list = Person.ContactType5 2023-04-25 14:19:49,835 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) database.trustServerCertificate = true 2023-04-25 14:19:49,837 INFO [io.deb.con.CommonConnectorConfig] (pool-7-thread-1) Loading the custom topic naming strategy plugin: io.debezium.schema.SchemaTopicNamingStrategy 2023-04-25 14:19:49,901 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) No previous offsets found 2023-04-25 14:19:49,904 DEBUG [io.deb.pip.sig.Signal] (pool-7-thread-1) Registering signal 'log' using class 'io.debezium.pipeline.signal.Log' 2023-04-25 14:19:49,905 DEBUG [io.deb.pip.sig.Signal] (pool-7-thread-1) Registering signal 'schema-changes' using class 'io.debezium.pipeline.signal.SchemaChanges' 2023-04-25 14:19:49,905 DEBUG [io.deb.pip.sig.Signal] (pool-7-thread-1) Registering signal 'execute-snapshot' using class 'io.debezium.pipeline.signal.ExecuteSnapshot' 2023-04-25 14:19:49,905 DEBUG [io.deb.pip.sig.Signal] (pool-7-thread-1) Registering signal 'stop-snapshot' using class 'io.debezium.pipeline.signal.StopSnapshot' 2023-04-25 14:19:49,905 DEBUG [io.deb.pip.sig.Signal] (pool-7-thread-1) Registering signal 'snapshot-window-open' using class 'io.debezium.pipeline.source.snapshot.incremental.OpenIncrementalSnapshotWindow' 2023-04-25 14:19:49,905 DEBUG [io.deb.pip.sig.Signal] (pool-7-thread-1) Registering signal 'snapshot-window-close' using class 'io.debezium.pipeline.source.snapshot.incremental.CloseIncrementalSnapshotWindow' 2023-04-25 14:19:49,906 DEBUG [io.deb.pip.sig.Signal] (pool-7-thread-1) Registering signal 'pause-snapshot' using class 'io.debezium.pipeline.signal.PauseIncrementalSnapshot' 2023-04-25 14:19:49,906 DEBUG [io.deb.pip.sig.Signal] (pool-7-thread-1) Registering signal 'resume-snapshot' using class 'io.debezium.pipeline.signal.ResumeIncrementalSnapshot' 2023-04-25 14:19:49,907 INFO [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector SqlServerConnector, id = named = change-event-source-coordinator 2023-04-25 14:19:49,909 INFO [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-sqlserverconnector--change-event-source-coordinator 2023-04-25 14:19:49,910 DEBUG [io.deb.ser.ConnectorLifecycle] (pool-7-thread-1) Task started 2023-04-25 14:19:49,910 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:49,910 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:49,911 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:49,911 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-sqlserverconnector--change-event-source-coordinator) Metrics registered 2023-04-25 14:19:49,911 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-sqlserverconnector--change-event-source-coordinator) Context created 2023-04-25 14:19:49,914 INFO [io.deb.con.sql.SqlServerSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No previous offset has been found 2023-04-25 14:19:49,914 INFO [io.deb.con.sql.SqlServerSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) According to the connector configuration both schema and data will be snapshotted 2023-04-25 14:19:49,914 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot step 1 - Preparing 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.Driver] (debezium-sqlserverconnector--change-event-source-coordinator) Microsoft JDBC Driver 10.2.1.0 for SQL Server 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.int.SQLServerDriver] (debezium-sqlserverconnector--change-event-source-coordinator) Property:serverName Value: 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.int.SQLServerDriver] (debezium-sqlserverconnector--change-event-source-coordinator) Property:portNumber Value:1433 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.int.SQLServerDriver] (debezium-sqlserverconnector--change-event-source-coordinator) Property:databaseName Value:aw2019 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.int.SQLServerConnection] (debezium-sqlserverconnector--change-event-source-coordinator) ConnectionID:3 created by (SQLServerDriver:4) 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.int.SQLServerConnection] (debezium-sqlserverconnector--change-event-source-coordinator) ConnectionID:3 This attempt server name: port: 1433 InstanceName: null useParallel: false 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.int.SQLServerConnection] (debezium-sqlserverconnector--change-event-source-coordinator) ConnectionID:3 This attempt endtime: 1682457591789 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.int.SQLServerConnection] (debezium-sqlserverconnector--change-event-source-coordinator) ConnectionID:3 This attempt No: 0 2023-04-25 14:19:49,914 FINE [com.mic.sql.jdb.int.SQLServerConnection] (debezium-sqlserverconnector--change-event-source-coordinator) ConnectionID:3 Connecting with server: port: 1433 Timeout slice: 1875 Timeout Full: 15 2023-04-25 14:19:50,028 FINE [com.mic.sql.jdb.int.SQLServerConnection] (debezium-sqlserverconnector--change-event-source-coordinator) ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664 Server returned major version:15 2023-04-25 14:19:50,209 DEBUG [io.deb.jdb.JdbcConnection] (debezium-sqlserverconnector--change-event-source-coordinator) Connected to jdbc:sqlserver://:1433;databaseName=aw2019 with {responseBuffering=adaptive, fetchSize=10000, trustServerCertificate=true, password=***, names=aw2019, encrypt=true, user=sqlserver} 2023-04-25 14:19:50,269 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot step 2 - Determining captured tables 2023-04-25 14:19:50,278 FINE [com.mic.sql.jdb.int.SQLServerDatabaseMetaData] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerDatabaseMetaData:1 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,286 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerCallableStatement:4 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,287 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerCallableStatement:4: calling sp_executesql: SQL:EXEC sp_tables @P0, @P1, @P2, @P3 2023-04-25 14:19:50,352 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:4 created by (SQLServerCallableStatement:4) 2023-04-25 14:19:50,367 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Adding table aw2019.Person.Address to the list of capture schema tables 2023-04-25 14:19:50,370 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot step 3 - Locking captured tables [aw2019.Person.ContactType5] 2023-04-25 14:19:50,370 INFO [io.deb.con.sql.SqlServerSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Setting locking timeout to 10 s 2023-04-25 14:19:50,370 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:5 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,371 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:5 Executing (not server cursor) SET LOCK_TIMEOUT 10000 2023-04-25 14:19:50,415 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:50,415 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:50,415 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:50,415 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:50,415 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:50,415 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:50,609 INFO [io.deb.con.sql.SqlServerSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Executing schema locking 2023-04-25 14:19:50,609 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:6 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,609 INFO [io.deb.con.sql.SqlServerSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Locking table aw2019.Person.ContactType5 2023-04-25 14:19:50,610 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:6 Executing (not server cursor) SELECT TOP(0) * FROM [aw2019].[Person].[ContactType5] WITH (TABLOCKX) 2023-04-25 14:19:50,669 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:5 created by (SQLServerStatement:6) 2023-04-25 14:19:50,669 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot step 4 - Determining snapshot offset 2023-04-25 14:19:50,673 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:7 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,673 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:7 Executing (not server cursor) SELECT [aw2019].sys.fn_cdc_get_max_lsn() 2023-04-25 14:19:50,729 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:6 created by (SQLServerStatement:7) 2023-04-25 14:19:50,737 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot step 5 - Reading structure of captured tables 2023-04-25 14:19:50,739 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:8 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,739 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:8 Executing (not server cursor) SELECT object_id, column_name FROM [aw2019].cdc.captured_columns ORDER BY object_id, column_id 2023-04-25 14:19:50,799 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:7 created by (SQLServerStatement:8) 2023-04-25 14:19:50,803 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:9 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,804 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:9: calling sp_executesql: SQL:WITH ordered_change_tables AS (SELECT ROW_NUMBER() OVER (PARTITION BY ct.source_object_id, ct.start_lsn ORDER BY ct.create_date DESC) AS ct_sequence, ct.* FROM [aw2019].cdc.change_tables AS ct) SELECT OBJECT_SCHEMA_NAME(source_object_id, DB_ID(@P0)), OBJECT_NAME(source_object_id, DB_ID(@P1)), capture_instance, object_id, start_lsn FROM ordered_change_tables WHERE ct_sequence = 1 2023-04-25 14:19:50,860 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:8 created by (SQLServerPreparedStatement:9) 2023-04-25 14:19:50,865 INFO [io.deb.con.sql.SqlServerSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Reading structure of schema 'aw2019' 2023-04-25 14:19:50,867 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerCallableStatement:4: calling sp_prepexec: PreparedHandle:0, SQL:EXEC sp_tables @P0, @P1, @P2, @P3 2023-04-25 14:19:50,920 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:50,920 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:50,920 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:50,920 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:50,920 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:50,920 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:50,931 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:9 created by (SQLServerCallableStatement:4) 2023-04-25 14:19:50,935 DEBUG [io.deb.jdb.JdbcConnection] (debezium-sqlserverconnector--change-event-source-coordinator) Retrieving columns of table aw2019.Person.ContactType5 2023-04-25 14:19:50,935 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:10 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,935 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:10 Executing (not server cursor) SELECT CAST(SERVERPROPERTY('EngineEdition') as INT) 2023-04-25 14:19:50,990 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:10 created by (SQLServerStatement:10) 2023-04-25 14:19:50,990 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:11 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:50,991 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:11: calling sp_executesql: SQL:DECLARE @mssqljdbc_temp_sp_columns_result TABLE(TABLE_QUALIFIER SYSNAME, TABLE_OWNER SYSNAME,TABLE_NAME SYSNAME, COLUMN_NAME SYSNAME, DATA_TYPE SMALLINT, TYPE_NAME SYSNAME, PRECISION INT,LENGTH INT, SCALE SMALLINT, RADIX SMALLINT, NULLABLE SMALLINT, REMARKS VARCHAR(254), COLUMN_DEF NVARCHAR(4000),SQL_DATA_TYPE SMALLINT, SQL_DATETIME_SUB SMALLINT, CHAR_OCTET_LENGTH INT, ORDINAL_POSITION INT,IS_NULLABLE VARCHAR(254), SS_IS_SPARSE SMALLINT, SS_IS_COLUMN_SET SMALLINT, SS_IS_COMPUTED SMALLINT,SS_IS_IDENTITY SMALLINT, SS_UDT_CATALOG_NAME NVARCHAR(128), SS_UDT_SCHEMA_NAME NVARCHAR(128),SS_UDT_ASSEMBLY_TYPE_NAME NVARCHAR(max), SS_XML_SCHEMACOLLECTION_CATALOG_NAME NVARCHAR(128),SS_XML_SCHEMACOLLECTION_SCHEMA_NAME NVARCHAR(128), SS_XML_SCHEMACOLLECTION_NAME NVARCHAR(128),SS_DATA_TYPE TINYINT);INSERT INTO @mssqljdbc_temp_sp_columns_result EXEC sp_columns_100 @P0,@P1,@P2,@P3,@P4,@P5;SELECT TABLE_QUALIFIER AS TABLE_CAT, TABLE_OWNER AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE,TYPE_NAME, PRECISION AS COLUMN_SIZE, LENGTH AS BUFFER_LENGTH, SCALE AS DECIMAL_DIGITS, RADIX AS NUM_PREC_RADIX,NULLABLE, REMARKS, COLUMN_DEF, SQL_DATA_TYPE, SQL_DATETIME_SUB, CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE,NULL AS SCOPE_CATALOG, NULL AS SCOPE_SCHEMA, NULL AS SCOPE_TABLE, SS_DATA_TYPE AS SOURCE_DATA_TYPE,CASE SS_IS_IDENTITY WHEN 0 THEN 'NO' WHEN 1 THEN 'YES' WHEN '' THEN '' END AS IS_AUTOINCREMENT,CASE SS_IS_COMPUTED WHEN 0 THEN 'NO' WHEN 1 THEN 'YES' WHEN '' THEN '' END AS IS_GENERATEDCOLUMN, SS_IS_SPARSE, SS_IS_COLUMN_SET, SS_UDT_CATALOG_NAME, SS_UDT_SCHEMA_NAME, SS_UDT_ASSEMBLY_TYPE_NAME,SS_XML_SCHEMACOLLECTION_CATALOG_NAME, SS_XML_SCHEMACOLLECTION_SCHEMA_NAME, SS_XML_SCHEMACOLLECTION_NAME FROM @mssqljdbc_temp_sp_columns_result ORDER BY TABLE_CAT, TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION; 2023-04-25 14:19:51,061 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:11 created by (SQLServerPreparedStatement:11) 2023-04-25 14:19:51,069 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerCallableStatement:12 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:51,069 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerCallableStatement:12: calling sp_executesql: SQL:EXEC sp_pkeys @P0, @P1, @P2 2023-04-25 14:19:51,130 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:12 created by (SQLServerCallableStatement:12) 2023-04-25 14:19:51,137 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot step 6 - Persisting schema history 2023-04-25 14:19:51,137 DEBUG [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Capturing structure of table aw2019.Person.ContactType5 2023-04-25 14:19:51,144 DEBUG [io.deb.con.sql.SqlServerDatabaseSchema] (debezium-sqlserverconnector--change-event-source-coordinator) Applying schema change event SchemaChangeEvent [database=aw2019, schema=Person, ddl=null, tables=[columns: { ContactTypeID int identity(10, 0) NOT NULL AUTO_INCREMENTED Name Name(50) NOT NULL ModifiedDate datetime(23, 3) NOT NULL } primary key: [ContactTypeID] default charset: null comment: null attributes: { } ], type=CREATE, ts_ms=1682457591139] 2023-04-25 14:19:51,145 DEBUG [io.deb.rel.TableSchemaBuilder] (debezium-sqlserverconnector--change-event-source-coordinator) Mapping table 'aw2019.Person.ContactType5' to schemas under '.aw2019.Person.ContactType5' 2023-04-25 14:19:51,147 DEBUG [io.deb.rel.TableSchemaBuilder] (debezium-sqlserverconnector--change-event-source-coordinator) - field 'ContactTypeID' (INT32) from column ContactTypeID int identity(10, 0) NOT NULL AUTO_INCREMENTED 2023-04-25 14:19:51,148 DEBUG [io.deb.rel.TableSchemaBuilder] (debezium-sqlserverconnector--change-event-source-coordinator) - field 'ContactTypeID' (INT32) from column ContactTypeID int identity(10, 0) NOT NULL AUTO_INCREMENTED 2023-04-25 14:19:51,148 DEBUG [io.deb.rel.TableSchemaBuilder] (debezium-sqlserverconnector--change-event-source-coordinator) - field 'Name' (STRING) from column Name Name(50) NOT NULL 2023-04-25 14:19:51,148 DEBUG [io.deb.rel.TableSchemaBuilder] (debezium-sqlserverconnector--change-event-source-coordinator) - field 'ModifiedDate' (INT64) from column ModifiedDate datetime(23, 3) NOT NULL 2023-04-25 14:19:51,149 DEBUG [io.deb.rel.TableSchemaBuilder] (debezium-sqlserverconnector--change-event-source-coordinator) Mapped primary key for table 'aw2019.Person.ContactType5' to schema: {"name" : ".aw2019.Person.ContactType5.Key", "type" : "STRUCT", "optional" : "false", "default" : null, "fields" : [{"name" : "ContactTypeID", "index" : "0", "schema" : {"type" : "INT32", "optional" : "false", "default" : null}}]} 2023-04-25 14:19:51,149 DEBUG [io.deb.rel.TableSchemaBuilder] (debezium-sqlserverconnector--change-event-source-coordinator) Mapped columns for table 'aw2019.Person.ContactType5' to schema: {"name" : ".aw2019.Person.ContactType5.Value", "type" : "STRUCT", "optional" : "true", "default" : null, "fields" : [{"name" : "ContactTypeID", "index" : "0", "schema" : {"type" : "INT32", "optional" : "false", "default" : null}}, {"name" : "Name", "index" : "1", "schema" : {"type" : "STRING", "optional" : "false", "default" : null}}, {"name" : "ModifiedDate", "index" : "2", "schema" : {"name" : "io.debezium.time.Timestamp", "type" : "INT64", "optional" : "false", "default" : null, "version" : "1"}}]} 2023-04-25 14:19:51,219 INFO [io.deb.con.sql.SqlServerSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Schema locks released. 2023-04-25 14:19:51,219 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot step 7 - Snapshotting data 2023-04-25 14:19:51,219 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshotting contents of 1 tables while still in transaction 2023-04-25 14:19:51,219 DEBUG [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshotting table aw2019.Person.ContactType5 2023-04-25 14:19:51,220 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Exporting data from table 'aw2019.Person.ContactType5' (1 of 1 tables) 2023-04-25 14:19:51,220 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) For table 'aw2019.Person.ContactType5' using select statement: 'SELECT [ContactTypeID], [Name], [ModifiedDate] FROM [aw2019].[Person].[ContactType5]' 2023-04-25 14:19:51,221 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:13 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:51,221 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:13 Executing (not server cursor) SELECT CURRENT_TIMESTAMP 2023-04-25 14:19:51,280 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:13 created by (SQLServerStatement:13) 2023-04-25 14:19:51,283 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:14 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:51,283 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:14 Executing (not server cursor) SELECT [ContactTypeID], [Name], [ModifiedDate] FROM [aw2019].[Person].[ContactType5] 2023-04-25 14:19:51,339 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:14 created by (SQLServerStatement:14) 2023-04-25 14:19:51,342 FINE [com.mic.sql.jdb.int.SQLServerResultSetMetaData] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSetMetaData:1 created by (SQLServerResultSet:14) 2023-04-25 14:19:51,353 INFO [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Finished exporting 20 records for table 'aw2019.Person.ContactType5'; total duration '00:00:00.133' 2023-04-25 14:19:51,410 INFO [io.deb.pip.sou.AbstractSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot - Final stage 2023-04-25 14:19:51,425 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:51,426 DEBUG [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Sending 1 records to topic 2023-04-25 14:19:51,426 DEBUG [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Sending 20 records to topic .aw2019.Person.ContactType5 2023-04-25 14:19:51,426 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:51,426 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received 21 records from the task 2023-04-25 14:19:51,427 DEBUG [io.deb.tra.SmtManager] (pool-7-thread-1) Expected Envelope for transformation, passing it unchanged 2023-04-25 14:19:51,429 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received 21 transformed records from the task 2023-04-25 14:19:51,471 INFO [io.deb.con.sql.SqlServerSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Removing locking timeout 2023-04-25 14:19:51,471 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:15 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:51,471 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:15 Executing (not server cursor) SET LOCK_TIMEOUT -1 2023-04-25 14:19:51,531 DEBUG [org.apa.kaf.con.sto.OffsetStorageWriter] (pool-7-thread-1) Submitting 1 entries to backing store. The offsets are: {{server=, database=aw2019}={commit_lsn=00000a41:00004ab8:0003, snapshot=true, snapshot_completed=true}} 2023-04-25 14:19:51,539 DEBUG [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Committing offset '{server=, database=aw2019}' for partition '{commit_lsn=00000a41:00004ab8:0003, snapshot=true, snapshot_completed=true}' 2023-04-25 14:19:51,539 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:51,539 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:51,539 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:51,589 INFO [io.deb.pip.sou.AbstractSnapshotChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot completed 2023-04-25 14:19:51,592 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-sqlserverconnector--change-event-source-coordinator) Snapshot ended with SnapshotResult [status=COMPLETED, offset=SqlServerOffsetContext [sourceInfoSchema=Schema{io.debezium.connector.sqlserver.Source:STRUCT}, sourceInfo=SourceInfo [serverName=, changeLsn=NULL, commitLsn=00000a41:00004ab8:0003, eventSerialNo=null, snapshot=FALSE, sourceTime=2023-04-26T04:19:51.300Z], snapshotCompleted=true, eventSerialNo=1]] 2023-04-25 14:19:51,594 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-sqlserverconnector--change-event-source-coordinator) Connected metrics set to 'true' 2023-04-25 14:19:51,594 INFO [io.deb.con.sql.SqlServerChangeEventSourceCoordinator] (debezium-sqlserverconnector--change-event-source-coordinator) Starting streaming 2023-04-25 14:19:51,595 INFO [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) Last position recorded in offsets is 00000a41:00004ab8:0003(NULL)[1] 2023-04-25 14:19:51,595 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:16 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:51,595 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:16 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:51,650 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:15 created by (SQLServerStatement:16) 2023-04-25 14:19:51,650 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:52,044 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:52,045 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:52,046 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:52,046 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:52,046 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:52,046 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:52,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:17 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:52,101 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:17 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:52,161 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:16 created by (SQLServerStatement:17) 2023-04-25 14:19:52,162 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:52,551 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:52,552 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:52,552 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:52,552 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:52,552 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:52,552 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:52,596 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:18 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:52,596 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:18 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:52,651 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:17 created by (SQLServerStatement:18) 2023-04-25 14:19:52,651 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:53,057 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:53,058 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:53,058 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:53,058 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:53,058 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:53,058 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:53,096 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:19 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:53,097 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:19 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:53,161 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:18 created by (SQLServerStatement:19) 2023-04-25 14:19:53,161 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:53,561 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:53,561 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:53,561 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:53,561 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:53,561 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:53,562 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:53,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:20 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:53,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:20 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:53,662 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:19 created by (SQLServerStatement:20) 2023-04-25 14:19:53,663 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:54,064 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:54,064 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:54,064 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:54,065 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:54,065 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:54,065 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:54,098 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:21 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:54,098 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:21 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:54,153 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:20 created by (SQLServerStatement:21) 2023-04-25 14:19:54,153 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:54,570 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:54,570 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:54,571 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:54,571 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:54,571 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:54,571 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:54,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:22 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:54,600 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:22 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:54,663 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:21 created by (SQLServerStatement:22) 2023-04-25 14:19:54,664 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:55,075 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:55,076 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:55,076 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:55,076 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:55,076 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:55,076 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:55,097 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:23 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:55,098 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:23 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:55,153 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:22 created by (SQLServerStatement:23) 2023-04-25 14:19:55,154 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:55,582 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:55,582 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:55,583 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:55,583 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:55,583 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:55,583 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:55,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:24 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:55,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:24 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:55,654 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:23 created by (SQLServerStatement:24) 2023-04-25 14:19:55,655 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:56,084 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:56,085 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:56,085 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:56,085 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:56,085 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:56,085 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:56,095 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:25 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:56,095 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:25 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:56,154 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:24 created by (SQLServerStatement:25) 2023-04-25 14:19:56,154 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:56,589 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:56,589 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:56,589 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:56,589 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:56,589 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:56,589 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:56,595 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:26 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:56,596 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:26 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:56,654 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:25 created by (SQLServerStatement:26) 2023-04-25 14:19:56,654 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:57,095 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:57,095 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:57,096 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:57,096 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:57,096 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:57,096 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:57,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:27 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:57,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:27 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:57,166 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:26 created by (SQLServerStatement:27) 2023-04-25 14:19:57,166 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:57,598 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:28 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:57,598 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:28 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:57,599 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:57,599 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:57,599 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:57,599 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:57,599 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:57,599 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:57,657 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:27 created by (SQLServerStatement:28) 2023-04-25 14:19:57,658 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:58,099 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:29 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:58,099 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:29 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:58,104 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:58,105 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:58,105 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:58,105 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:58,105 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:58,105 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:58,156 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:28 created by (SQLServerStatement:29) 2023-04-25 14:19:58,157 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:58,600 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:30 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:58,601 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:30 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:58,606 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:58,607 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:58,607 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:58,607 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:58,607 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:58,607 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:58,657 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:29 created by (SQLServerStatement:30) 2023-04-25 14:19:58,658 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:59,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:31 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:59,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:31 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:59,111 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:59,111 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:59,111 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:59,112 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:59,112 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:59,112 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:59,157 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:30 created by (SQLServerStatement:31) 2023-04-25 14:19:59,158 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:19:59,598 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:32 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:19:59,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:32 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:19:59,617 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:19:59,618 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:19:59,618 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:19:59,618 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:19:59,618 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:19:59,618 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:19:59,659 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:31 created by (SQLServerStatement:32) 2023-04-25 14:19:59,659 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:00,095 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:33 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:00,095 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:33 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:00,124 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:00,124 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:00,125 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:00,125 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:00,125 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:00,125 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:00,159 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:32 created by (SQLServerStatement:33) 2023-04-25 14:20:00,160 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:00,595 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:34 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:00,595 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:34 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:00,626 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:00,627 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:00,627 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:00,627 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:00,627 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:00,628 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:00,660 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:33 created by (SQLServerStatement:34) 2023-04-25 14:20:00,660 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:01,098 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:35 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:01,099 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:35 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:01,131 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:01,131 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:01,132 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:01,132 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:01,132 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:01,132 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:01,160 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:34 created by (SQLServerStatement:35) 2023-04-25 14:20:01,160 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:01,597 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:36 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:01,598 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:36 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:01,636 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:01,637 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:01,637 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:01,637 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:01,637 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:01,638 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:01,660 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:35 created by (SQLServerStatement:36) 2023-04-25 14:20:01,660 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:02,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:37 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:02,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:37 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:02,143 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:02,143 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:02,143 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:02,143 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:02,143 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:02,143 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:02,160 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:36 created by (SQLServerStatement:37) 2023-04-25 14:20:02,161 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:02,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:38 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:02,600 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:38 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:02,646 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:02,647 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:02,647 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:02,647 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:02,648 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:02,648 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:02,662 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:37 created by (SQLServerStatement:38) 2023-04-25 14:20:02,664 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:39 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:02,666 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:39: calling sp_executesql: SQL:SELECT [aw2019].sys.fn_cdc_increment_lsn(@P0) 2023-04-25 14:20:02,720 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:38 created by (SQLServerPreparedStatement:39) 2023-04-25 14:20:02,721 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:40 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:02,721 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:40: calling sp_executesql: SQL:SELECT * FROM [aw2019].cdc.change_tables WHERE start_lsn BETWEEN @P0 AND @P1 2023-04-25 14:20:02,781 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:39 created by (SQLServerPreparedStatement:40) 2023-04-25 14:20:02,781 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:41 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:02,781 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:41 Executing (not server cursor) SELECT object_id, column_name FROM [aw2019].cdc.captured_columns ORDER BY object_id, column_id 2023-04-25 14:20:02,841 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:40 created by (SQLServerStatement:41) 2023-04-25 14:20:02,842 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:42 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:02,842 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:42: calling sp_executesql: SQL:WITH ordered_change_tables AS (SELECT ROW_NUMBER() OVER (PARTITION BY ct.source_object_id, ct.start_lsn ORDER BY ct.create_date DESC) AS ct_sequence, ct.* FROM [aw2019].cdc.change_tables AS ct WHERE ct.start_lsn <= @P0) SELECT OBJECT_SCHEMA_NAME(source_object_id, DB_ID(@P1)), OBJECT_NAME(source_object_id, DB_ID(@P2)), capture_instance, object_id, start_lsn FROM ordered_change_tables WHERE ct_sequence = 1 2023-04-25 14:20:02,902 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:41 created by (SQLServerPreparedStatement:42) 2023-04-25 14:20:02,908 INFO [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) CDC is enabled for table Capture instance "Person_Person" [sourceTableId=aw2019.Person.Person, changeTableId=aw2019.cdc.Person_Person_CT, startLsn=00000a31:00003bc0:0003, changeTableObjectId=253243957, stopLsn=NULL] but the table is not on connector's table include list 2023-04-25 14:20:02,913 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:43 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:02,913 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerPreparedStatement:43: calling sp_executesql: SQL:SELECT *, TODATETIMEOFFSET([aw2019].sys.fn_cdc_map_lsn_to_time([__$start_lsn]), DATEPART(TZOFFSET, SYSDATETIMEOFFSET())) FROM [aw2019].cdc.[fn_cdc_get_all_changes_Person_ContactType5](@P0, @P1, N'all update old') order by [__$start_lsn] ASC, [__$seqval] ASC, [__$operation] ASC 2023-04-25 14:20:02,974 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:42 created by (SQLServerPreparedStatement:43) 2023-04-25 14:20:02,976 FINE [com.mic.sql.jdb.int.SQLServerResultSetMetaData] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSetMetaData:2 created by (SQLServerResultSet:42) 2023-04-25 14:20:03,052 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:44 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:03,052 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:44 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:03,111 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:43 created by (SQLServerStatement:44) 2023-04-25 14:20:03,112 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:03,112 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:45 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:03,112 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:45 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:03,153 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:03,153 DEBUG [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Sending 1 records to topic .aw2019.Person.ContactType5 2023-04-25 14:20:03,154 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 22 records sent during previous 00:00:13.321, last recorded offset of {server=, database=aw2019} partition is {transaction_id=null, event_serial_no=2, commit_lsn=00000a41:00004b10:0003, change_lsn=00000a41:00004b10:0002} 2023-04-25 14:20:03,154 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:03,154 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received 1 records from the task 2023-04-25 14:20:03,154 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received 1 transformed records from the task 2023-04-25 14:20:03,165 DEBUG [org.apa.kaf.con.sto.OffsetStorageWriter] (pool-7-thread-1) Submitting 1 entries to backing store. The offsets are: {{server=, database=aw2019}={transaction_id=null, event_serial_no=2, commit_lsn=00000a41:00004b10:0003, change_lsn=00000a41:00004b10:0002}} 2023-04-25 14:20:03,167 DEBUG [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Committing offset '{server=, database=aw2019}' for partition '{transaction_id=null, event_serial_no=2, commit_lsn=00000a41:00004b10:0003, change_lsn=00000a41:00004b10:0002}' 2023-04-25 14:20:03,168 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:03,168 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:03,168 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:03,172 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:44 created by (SQLServerStatement:45) 2023-04-25 14:20:03,172 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:03,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:46 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:03,600 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:46 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:03,662 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:45 created by (SQLServerStatement:46) 2023-04-25 14:20:03,663 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:03,669 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:03,670 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:03,670 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:03,670 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:03,670 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:03,670 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:04,097 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:47 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:04,097 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:47 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:04,153 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:46 created by (SQLServerStatement:47) 2023-04-25 14:20:04,153 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:04,175 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:04,176 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:04,176 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:04,176 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:04,176 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:04,176 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:04,598 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:48 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:04,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:48 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:04,664 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:47 created by (SQLServerStatement:48) 2023-04-25 14:20:04,665 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:04,678 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:04,679 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:04,679 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:04,679 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:04,679 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:04,679 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:05,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:49 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:05,100 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:49 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:05,164 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:48 created by (SQLServerStatement:49) 2023-04-25 14:20:05,164 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:05,181 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:05,181 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:05,181 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:05,181 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:05,181 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:05,181 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:05,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:50 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:05,599 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:50 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:05,654 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:49 created by (SQLServerStatement:50) 2023-04-25 14:20:05,654 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:05,686 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:05,687 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:05,687 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:05,687 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:05,687 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:05,687 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:06,099 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:51 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:06,099 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:51 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:06,164 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:50 created by (SQLServerStatement:51) 2023-04-25 14:20:06,165 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:06,192 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:06,193 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:06,193 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:06,193 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine is polling task for records on thread Thread[#36,pool-7-thread-1,5,main] 2023-04-25 14:20:06,193 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) polling records... 2023-04-25 14:20:06,193 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:06,215 DEBUG [io.qua.run.Application] (main) Stopping application 2023-04-25 14:20:06,215 DEBUG [io.qua.run.shu.ShutdownRecorder] (main) Attempting to gracefully shutdown. 2023-04-25 14:20:06,215 DEBUG [io.qua.run.Application] (Shutdown thread) Stopping application 2023-04-25 14:20:06,224 INFO [io.deb.ser.DebeziumServer] (main) Received request to stop the engine 2023-04-25 14:20:06,224 INFO [io.deb.emb.EmbeddedEngine] (main) Stopping the embedded engine 2023-04-25 14:20:06,225 INFO [io.deb.emb.EmbeddedEngine] (main) Waiting for PT5M for connector to stop 2023-04-25 14:20:06,600 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:52 created by (ConnectionID:3 ClientConnectionId: 9f4d8256-1de0-4029-869b-c1db5cf85664) 2023-04-25 14:20:06,600 FINE [com.mic.sql.jdb.int.SQLServerStatement] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerStatement:52 Executing (not server cursor) SELECT MAX(start_lsn) FROM [aw2019].cdc.lsn_time_mapping WHERE tran_id <> 0x00 2023-04-25 14:20:06,666 FINE [com.mic.sql.jdb.int.SQLServerResultSet] (debezium-sqlserverconnector--change-event-source-coordinator) SQLServerResultSet:51 created by (SQLServerStatement:52) 2023-04-25 14:20:06,666 DEBUG [io.deb.con.sql.SqlServerStreamingChangeEventSource] (debezium-sqlserverconnector--change-event-source-coordinator) No change in the database 2023-04-25 14:20:06,693 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:06,693 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) no records available or batch size not reached yet, sleeping a bit... 2023-04-25 14:20:06,694 DEBUG [io.deb.con.bas.ChangeEventQueue] (pool-7-thread-1) checking for more records... 2023-04-25 14:20:06,694 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Embedded engine returned from polling task for records 2023-04-25 14:20:06,694 DEBUG [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Received no records from the task 2023-04-25 14:20:06,694 INFO [io.deb.emb.EmbeddedEngine] (pool-7-thread-1) Stopping the task and engine 2023-04-25 14:20:06,694 INFO [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Stopping down connector 2023-04-25 14:20:07,100 INFO [io.deb.con.sql.SqlServerChangeEventSourceCoordinator] (debezium-sqlserverconnector--change-event-source-coordinator) Finished streaming 2023-04-25 14:20:07,100 INFO [io.deb.pip.ChangeEventSourceCoordinator] (debezium-sqlserverconnector--change-event-source-coordinator) Connected metrics set to 'false' 2023-04-25 14:20:07,104 INFO [io.deb.jdb.JdbcConnection] (pool-11-thread-1) Connection gracefully closed 2023-04-25 14:20:07,105 DEBUG [io.deb.ser.ConnectorLifecycle] (pool-7-thread-1) Task stopped 2023-04-25 14:20:07,106 INFO [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Stopped FileOffsetBackingStore 2023-04-25 14:20:07,106 DEBUG [io.deb.ser.ConnectorLifecycle] (pool-7-thread-1) Connector stopped 2023-04-25 14:20:07,107 INFO [io.deb.ser.ConnectorLifecycle] (pool-7-thread-1) Connector completed: success = 'true', message = 'Connector 'io.debezium.connector.sqlserver.SqlServerConnector' completed normally.', error = 'null' 2023-04-25 14:20:07,107 DEBUG [io.deb.emb.EmbeddedEngine] (main) Interrupting the embedded engine's thread Thread[#36,pool-7-thread-1,5,main] (already interrupted: false) 2023-04-25 14:20:07,116 DEBUG [io.qua.arc.impl] (main) ArC DI container shut down 2023-04-25 14:20:07,124 DEBUG [io.qua.thread-pool] (main) loop: 1, remaining: 60000000000, intervalRemaining: 5000000000, interruptRemaining: 10000000000 2023-04-25 14:20:07,124 INFO [io.quarkus] (main) debezium-server-dist stopped in 0.909s