[2021-08-19 15:59:46,156] INFO KafkaDatabaseHistory Producer config: {batch.size=32768, acks=1, group.id=vista-connect-391, bootstrap.servers=pkc-l6gk2.centralus.azure.confluent.cloud:9092, buffer.memory=1048576, key.serializer=org.apache.kafka.common.serialization.StringSerializer, security.protocol=SASL_SSL, retries=1, value.serializer=org.apache.kafka.common.serialization.StringSerializer, sasl.mechanism=PLAIN, sasl.jaas.config=********, max.block.ms=10000, client.id=vista_raw_cmv218191_391-dbhistory, linger.ms=0} (io.debezium.relational.history.KafkaDatabaseHistory) [2021-08-19 15:59:46,156] INFO Requested thread factory for connector SqlServerConnector, id = vista_raw_cmv218191_391 named = db-history-config-check (io.debezium.util.Threads) [2021-08-19 15:59:46,156] INFO ProducerConfig values: acks = 1 batch.size = 32768 bootstrap.servers = [pkc-l6gk2.centralus.azure.confluent.cloud:9092] buffer.memory = 1048576 client.dns.lookup = use_all_dns_ips client.id = vista_raw_cmv218191_391-dbhistory compression.type = none connections.max.idle.ms = 540000 delivery.timeout.ms = 120000 enable.idempotence = false interceptor.classes = [] internal.auto.downgrade.txn.commit = false key.serializer = class org.apache.kafka.common.serialization.StringSerializer linger.ms = 0 max.block.ms = 10000 max.in.flight.requests.per.connection = 5 max.request.size = 1048576 metadata.max.age.ms = 300000 metadata.max.idle.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 partitioner.class = class org.apache.kafka.clients.producer.internals.DefaultPartitioner receive.buffer.bytes = 32768 reconnect.backoff.max.ms = 1000 reconnect.backoff.ms = 50 request.timeout.ms = 30000 retries = 1 retry.backoff.ms = 100 sasl.client.callback.handler.class = null sasl.jaas.config = [hidden] sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.login.callback.handler.class = null sasl.login.class = null sasl.login.refresh.buffer.seconds = 300 sasl.login.refresh.min.period.seconds = 60 sasl.login.refresh.window.factor = 0.8 sasl.login.refresh.window.jitter = 0.05 sasl.mechanism = PLAIN security.protocol = SASL_SSL security.providers = null send.buffer.bytes = 131072 socket.connection.setup.timeout.max.ms = 30000 socket.connection.setup.timeout.ms = 10000 ssl.cipher.suites = null 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 transaction.timeout.ms = 60000 transactional.id = null value.serializer = class org.apache.kafka.common.serialization.StringSerializer (org.apache.kafka.clients.producer.ProducerConfig) [2021-08-19 15:59:46,158] WARN The configuration 'group.id' was supplied but isn't a known config. (org.apache.kafka.clients.producer.ProducerConfig) [2021-08-19 15:59:46,158] INFO Kafka version: 6.2.0-ccs (org.apache.kafka.common.utils.AppInfoParser) [2021-08-19 15:59:46,158] INFO Kafka commitId: 1a5755cf9401c84f (org.apache.kafka.common.utils.AppInfoParser) [2021-08-19 15:59:46,158] INFO Kafka startTimeMs: 1629388786158 (org.apache.kafka.common.utils.AppInfoParser) [2021-08-19 15:59:46,160] INFO ConsumerConfig values: allow.auto.create.topics = true auto.commit.interval.ms = 5000 auto.offset.reset = earliest bootstrap.servers = [pkc-l6gk2.centralus.azure.confluent.cloud:9092] check.crcs = true client.dns.lookup = use_all_dns_ips client.id = vista_raw_cmv218191_391-dbhistory client.rack = connections.max.idle.ms = 540000 default.api.timeout.ms = 60000 enable.auto.commit = false exclude.internal.topics = true fetch.max.bytes = 52428800 fetch.max.wait.ms = 500 fetch.min.bytes = 1 group.id = vista-connect-391 group.instance.id = null heartbeat.interval.ms = 3000 interceptor.classes = [] internal.leave.group.on.close = true internal.throw.on.fetch.stable.offset.unsupported = false isolation.level = read_uncommitted key.deserializer = class org.apache.kafka.common.serialization.StringDeserializer max.partition.fetch.bytes = 1048576 max.poll.interval.ms = 300000 max.poll.records = 500 metadata.max.age.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 partition.assignment.strategy = [class org.apache.kafka.clients.consumer.RangeAssignor] receive.buffer.bytes = 65536 reconnect.backoff.max.ms = 1000 reconnect.backoff.ms = 50 request.timeout.ms = 30000 retry.backoff.ms = 100 sasl.client.callback.handler.class = null sasl.jaas.config = [hidden] sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.login.callback.handler.class = null sasl.login.class = null sasl.login.refresh.buffer.seconds = 300 sasl.login.refresh.min.period.seconds = 60 sasl.login.refresh.window.factor = 0.8 sasl.login.refresh.window.jitter = 0.05 sasl.mechanism = PLAIN security.protocol = SASL_SSL security.providers = null send.buffer.bytes = 131072 session.timeout.ms = 10000 socket.connection.setup.timeout.max.ms = 30000 socket.connection.setup.timeout.ms = 10000 ssl.cipher.suites = null 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 value.deserializer = class org.apache.kafka.common.serialization.StringDeserializer (org.apache.kafka.clients.consumer.ConsumerConfig) [2021-08-19 15:59:46,162] INFO Kafka version: 6.2.0-ccs (org.apache.kafka.common.utils.AppInfoParser) [2021-08-19 15:59:46,162] INFO Kafka commitId: 1a5755cf9401c84f (org.apache.kafka.common.utils.AppInfoParser) [2021-08-19 15:59:46,162] INFO Kafka startTimeMs: 1629388786162 (org.apache.kafka.common.utils.AppInfoParser) [2021-08-19 15:59:46,186] INFO [Producer clientId=vista_raw_cmv218191_391-dbhistory] Cluster ID: lkc-gqwk1 (org.apache.kafka.clients.Metadata) [2021-08-19 15:59:46,188] INFO [Consumer clientId=vista_raw_cmv218191_391-dbhistory, groupId=vista-connect-391] Cluster ID: lkc-gqwk1 (org.apache.kafka.clients.Metadata) [2021-08-19 15:59:46,202] INFO Metrics scheduler closed (org.apache.kafka.common.metrics.Metrics) [2021-08-19 15:59:46,202] INFO Closing reporter org.apache.kafka.common.metrics.JmxReporter (org.apache.kafka.common.metrics.Metrics) [2021-08-19 15:59:46,202] INFO Metrics reporters closed (org.apache.kafka.common.metrics.Metrics) [2021-08-19 15:59:46,202] INFO App info kafka.consumer for vista_raw_cmv218191_391-dbhistory unregistered (org.apache.kafka.common.utils.AppInfoParser) [2021-08-19 15:59:46,380] INFO Requested thread factory for connector SqlServerConnector, id = vista_raw_cmv218191_391 named = change-event-source-coordinator (io.debezium.util.Threads) [2021-08-19 15:59:46,380] INFO Creating thread debezium-sqlserverconnector-vista_raw_cmv218191_391-change-event-source-coordinator (io.debezium.util.Threads) [2021-08-19 15:59:46,380] INFO WorkerSourceTask{id=vista-sink-cmv218191-391-0} Source task finished initialization and start (org.apache.kafka.connect.runtime.WorkerSourceTask) [2021-08-19 15:59:46,380] INFO Metrics registered (io.debezium.pipeline.ChangeEventSourceCoordinator) [2021-08-19 15:59:46,380] INFO Context created (io.debezium.pipeline.ChangeEventSourceCoordinator) [2021-08-19 15:59:46,380] INFO No previous offset has been found (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource) [2021-08-19 15:59:46,380] INFO According to the connector configuration both schema and data will be snapshotted (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource) [2021-08-19 15:59:46,380] INFO Snapshot step 1 - Preparing (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:46,381] INFO Snapshot step 2 - Determining captured tables (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:47,099] INFO Snapshot step 3 - Locking captured tables [Viewpoint.dbo.bAPVM] (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:47,100] INFO Setting locking timeout to 10 s (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource) [2021-08-19 15:59:47,105] INFO Executing schema locking (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource) [2021-08-19 15:59:47,105] INFO Locking table Viewpoint.dbo.bAPVM (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource) [2021-08-19 15:59:47,107] INFO Snapshot step 4 - Determining snapshot offset (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:47,114] INFO Snapshot step 5 - Reading structure of captured tables (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:47,114] INFO Reading structure of schema 'Viewpoint' (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,087] WARN Mapper for type 'bYN' not found. (io.debezium.connector.sqlserver.SqlServerDefaultValueConverter) [2021-08-19 15:59:48,287] INFO Snapshot step 6 - Persisting schema history (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:48,321] INFO Schema locks released. (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource) [2021-08-19 15:59:48,321] INFO Snapshot step 7 - Snapshotting data (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:48,321] INFO Snapshotting contents of 1 tables while still in transaction (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:48,321] INFO Exporting data from table 'Viewpoint.dbo.bAPVM' (1 of 1 tables) (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 15:59:48,322] INFO For table 'Viewpoint.dbo.bAPVM' using select statement: 'SELECT [bAPVM].[VendorGroup],[bAPVM].[Vendor],[bAPVM].[SortName],[bAPVM].[Name],[bAPVM].[Type],[bAPVM].[TempYN],[bAPVM].[Contact],[b APVM].[Phone],[bAPVM].[Fax],[bAPVM].[EMail],[bAPVM].[URL],[bAPVM].[Address],[bAPVM].[City],[bAPVM].[State],[bAPVM].[Zip],[bAPVM].[Address2],[bAPVM].[POAddress],[bAPVM].[POCity],[bAPVM].[POState],[bAPVM].[POZip],[bAPVM].[PO Address2],[bAPVM].[Purge],[bAPVM].[CustGroup],[bAPVM].[Customer],[bAPVM].[TaxGroup],[bAPVM].[TaxCode],[bAPVM].[PayTerms],[bAPVM].[GLCo],[bAPVM].[GLAcct],[bAPVM].[V1099YN],[bAPVM].[V1099Type],[bAPVM].[V1099Box],[bAPVM].[Pro p],[bAPVM].[ActiveYN],[bAPVM].[AcctType],[bAPVM].[LastInvDate],[bAPVM].[AuditYN],[bAPVM].[Notes],[bAPVM].[AddnlInfo],[bAPVM].[AddendaTypeId],[bAPVM].[Reviewer],[bAPVM].[SeparatePayInvYN],[bAPVM].[UniqueAttchID],[bAPVM].[Ov errideMinAmtYN],[bAPVM].[MasterVendor],[bAPVM].[APRefUnqOvr],[bAPVM].[UpdatePMYN],[bAPVM].[KeyID],[bAPVM].[AddRevToAllLinesYN],[bAPVM].[Country],[bAPVM].[POCountry],[bAPVM].[AUVendorEFTYN],[bAPVM].[AUVendorAccountNumber],[ bAPVM].[AUVendorBSB],[bAPVM].[AUVendorReference],[bAPVM].[IATYN],[bAPVM].[ISODestinationCountryCode],[bAPVM].[BranchCountryCode],[bAPVM].[RDFIIdentNbrQualifier],[bAPVM].[GatewayOperatorRDFIIdent],[bAPVM].[CMAcct],[bAPVM].[ PayInfoDelivMthd],[bAPVM].[AusBusNbr],[bAPVM].[AusCorpNbr],[bAPVM].[PayControl],[bAPVM].[CASubjToWC],[bAPVM].[CAClearanceCert],[bAPVM].[CACertEffectiveDate],[bAPVM].[V1099AddressSeq],[bAPVM].[PayMethod],[bAPVM].[SubjToOnCo stYN],[bAPVM].[CSEmail],[bAPVM].[OnCostCostType],[bAPVM].[UpdatePREHYN],[bAPVM].[VendorAcctNumber],[bAPVM].[SubcontractorYN],[bAPVM].[DuplicateOf] FROM [dbo].[bAPVM]' (io.debezium.relational.RelationalSnapshotChangeEventSource) [2021-08-19 16:00:28,453] INFO Snapshot - Final stage (io.debezium.pipeline.source.AbstractSnapshotChangeEventSource) [2021-08-19 16:00:28,575] INFO Removing locking timeout (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource) [2021-08-19 16:00:28,575] ERROR Producer failure (io.debezium.pipeline.ErrorHandler) io.debezium.DebeziumException: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:78) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:113) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at io.debezium.relational.RelationalSnapshotChangeEventSource.rollbackTransaction(RelationalSnapshotChangeEventSource.java:472) at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:150) at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:69) ... 6 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1088) at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:3153) at io.debezium.relational.RelationalSnapshotChangeEventSource.rollbackTransaction(RelationalSnapshotChangeEventSource.java:469) ... 8 more [2021-08-19 16:00:28,575] INFO Connected metrics set to 'false' (io.debezium.pipeline.metrics.StreamingChangeEventSourceMetrics) [2021-08-19 16:00:28,881] ERROR WorkerSourceTask{id=vista-sink-cmv218191-391-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask) org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped. at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:130) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: io.debezium.DebeziumException: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:78) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:113) ... 5 more Caused by: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at io.debezium.relational.RelationalSnapshotChangeEventSource.rollbackTransaction(RelationalSnapshotChangeEventSource.java:472) at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:150) at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:69) ... 6 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1088) at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:3153) at io.debezium.relational.RelationalSnapshotChangeEventSource.rollbackTransaction(RelationalSnapshotChangeEventSource.java:469) ... 8 more [2021-08-19 16:00:28,881] INFO Stopping down connector (io.debezium.connector.common.BaseSourceTask) [2021-08-19 16:00:28,884] INFO Connection gracefully closed (io.debezium.jdbc.JdbcConnection) [2021-08-19 16:00:28,887] INFO Connection gracefully closed (io.debezium.jdbc.JdbcConnection) [2021-08-19 16:00:28,887] INFO [Producer clientId=vista_raw_cmv218191_391-dbhistory] Closing the Kafka producer with timeoutMillis = 30000 ms. (org.apache.kafka.clients.producer.KafkaProducer) [2021-08-19 16:00:28,888] INFO Metrics scheduler closed (org.apache.kafka.common.metrics.Metrics) [2021-08-19 16:00:28,888] INFO Closing reporter org.apache.kafka.common.metrics.JmxReporter (org.apache.kafka.common.metrics.Metrics) [2021-08-19 16:00:28,888] INFO Metrics reporters closed (org.apache.kafka.common.metrics.Metrics) [2021-08-19 16:00:28,888] INFO App info kafka.producer for vista_raw_cmv218191_391-dbhistory unregistered (org.apache.kafka.common.utils.AppInfoParser) [2021-08-19 16:00:28,888] INFO [Producer clientId=connector-producer-vista-sink-cmv218191-391-0] Closing the Kafka producer with timeoutMillis = 30000 ms. (org.apache.kafka.clients.producer.KafkaProducer) [2021-08-19 16:00:28,890] INFO Metrics scheduler closed (org.apache.kafka.common.metrics.Metrics) [2021-08-19 16:00:28,890] INFO Closing reporter org.apache.kafka.common.metrics.JmxReporter (org.apache.kafka.common.metrics.Metrics) [2021-08-19 16:00:28,890] INFO Metrics reporters closed (org.apache.kafka.common.metrics.Metrics) [2021-08-19 16:00:28,890] INFO App info kafka.producer for connector-producer-vista-sink-cmv218191-391-0 unregistered (org.apache.kafka.common.utils.AppInfoParser)