Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4857

Debezium task stops running due to multiple uncaught exceptions in REST call

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • None
    • None
    • None
    • None
    • False
    • None
    • False

    Description

      We are using mysql debezium connector for CDC and noticed below errors popping up intermittently which eventually brings down our debezium task.

      The occurrence of these errors is sporadic and is not associated with any changes we make to the connector.

      Stack trace:

      [2022-02-28 11:51:49,760] ERROR Uncaught exception in REST call to /info (org.apache.kafka.connect.runtime.rest.errors.ConnectExceptionMapper:61)
      javax.ws.rs.NotFoundException: HTTP 404 Not Found
      	at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:252)
      	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
      	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
      	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
      	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
      	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)
      	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
      	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
      	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:791)
      	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
      	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
      	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1435)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
      	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
      	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
      	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1350)
      	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
      	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:234)
      	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:179)
      	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
      	at org.eclipse.jetty.server.Server.handle(Server.java:516)
      	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
      	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
      	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
      	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
      	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
      	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
      	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
      	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:383)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:882)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1036)
      	at java.base/java.lang.Thread.run(Thread.java:829)
      [2022-02-28 11:52:13,139] ERROR Uncaught exception in REST call to /api/hpe-restapi.json (org.apache.kafka.connect.runtime.rest.errors.ConnectExceptionMapper:61)
      javax.ws.rs.NotFoundException: HTTP 404 Not Found
      	at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:252)
      	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
      	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
      	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
      	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
      	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)
      	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
      	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
      	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:791)
      	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
      	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
      	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1435)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
      	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
      	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
      	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1350)
      	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
      	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:234)
      	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:179)
      	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
      	at org.eclipse.jetty.server.Server.handle(Server.java:516)
      	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
      	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
      	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
      	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
      	at org.eclipse.jetty.io.Abstrac
      	..........
      [2022-03-05 12:50:58,157] ERROR Uncaught exception in REST call to /DB4Web/security-tenable-scanner-prod-3.dm.vpc:23/foo (org.apache.kafka.connect.runtime.rest.errors.ConnectExceptionMapper:61)
      javax.ws.rs.NotFoundException: HTTP 404 Not Found
      	at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:252)
      	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
      	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
      	at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
      	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
      	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
      	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)
      	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
      	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)
      	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
      	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:791)
      	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
      	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
      	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1435)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
      	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
      	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
      	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1350)
      	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
      	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:234)
      	at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:179)
      	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
      	at org.eclipse.jetty.server.Server.handle(Server.java:516)
      	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
      	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
      	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
      	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
      	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
      	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
      	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
      	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:383)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:882)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1036)
      	at java.base/java.lang.Thread.run(Thread.java:829)
      [2022-03-05 12:51:01,925] INFO WorkerSourceTask{id=XXX-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:487)
      

      Connector config:

       {
        "name": "NAME",
        "config": {
          "connector.class": "io.debezium.connector.mysql.MySqlConnector",
          "tasks.max": "1",
          "database.hostname": "XXX",
          "database.port": "xxx",
          "database.user": "USER",
          "database.password": "PASS",
          "database.whitelist": "XXX",
          "table.whitelist": "XXX",
          "database.server.id": "XXX",
          "database.server.name": "XXX",
          "database.history.kafka.bootstrap.servers": "XXX",
          "database.history.kafka.topic": "XXX",
          "include.schema.changes": true,
          "database.history.store.only.monitored.tables.ddl": true,
          "snapshot.mode": "schema_only",
          "snapshot.locking.mode": "minimal",
          "inconsistent.schema.handling.mode": "warn",
          "database.history.skip.unparseable.ddl": true,
      
          "database.history.producer.security.protocol":"SASL_SSL",
          "database.history.producer.sasl.mechanism":"AWS_MSK_IAM",
          "database.history.producer.sasl.jaas.config":"software.amazon.msk.auth.iam.IAMLoginModule required;",
          "database.history.producer.sasl.client.callback.handler.class":"software.amazon.msk.auth.iam.IAMClientCallbackHandler",
      
          "database.history.consumer.security.protocol":"SASL_SSL",
          "database.history.consumer.sasl.mechanism":"AWS_MSK_IAM",
          "database.history.consumer.sasl.jaas.config":"software.amazon.msk.auth.iam.IAMLoginModule required;",
          "database.history.consumer.sasl.client.callback.handler.class":"software.amazon.msk.auth.iam.IAMClientCallbackHandler",
      
          "database.history.security.protocol":"SASL_SSL",
          "database.history.sasl.mechanism":"AWS_MSK_IAM",
          "database.history.sasl.jaas.config":"software.amazon.msk.auth.iam.IAMLoginModule required;",
          "database.history.sasl.client.callback.handler.class":"software.amazon.msk.auth.iam.IAMClientCallbackHandler"
        }
      }
      

      Using Amazon RDS MySQL version 5.7

      Attachments

        Activity

          People

            Unassigned Unassigned
            falguni06 Falguni Madria (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: