Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4095

Maxscale CDC to Kafka job is failing for few tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.2.3
    • Fix Version/s: 6.3.1
    • Component/s: cdc
    • Labels:
      None
    • Environment:
      Ubuntu 20.04
    • Sprint:
      MXS-SPRINT-156

      Description

      Hi Team,

      Maxscale for CDC of multiple tables into Kafka its running for most of the tables but is not starting for few tables. We are getting the following error in the log, when trying to start CDC Job

      From Maxscale Logs :

      2022-04-14 16:38:52   notice : Service 'avro-converter-PI2' started (4/4)
      2022-04-14 16:38:52   notice : Started replicating from [10.8.2x.xx]:3306 at GTID '0-202-74961217'
      2022-04-14 16:38:52   notice : Started replicating from [10.8.2x.xx]:3306 at GTID '0-197-76367692'
      2022-04-14 16:38:53   notice : Read 191 user@host entries from 'server2' for service 'Binlog-Service-PI2'.
      2022-04-14 16:38:53   notice : Read 165 user@host entries from 'server1' for service 'Binlog-Service-PI1'.
      2022-04-14 16:42:11   error  : Sync marker mismatch.
      2022-04-14 16:42:11   error  : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_IO'.
      2022-04-14 16:42:11   error  : Write to Client DCB ::ffff:10.8.2x.xx in state DCB::State::POLLING failed: 104, Connection reset by peer
      2022-04-14 16:42:11   error  : Write to Client DCB ::ffff:10.8.2x.xx in state DCB::State::POLLING failed: 104, Connection reset by peer
      2022-04-14 16:42:11   error  : Sync marker mismatch.
      2022-04-14 16:42:11   error  : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_IO'.
      2022-04-14 16:42:11   error  : Sync marker mismatch.
      2022-04-14 16:42:11   error  : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_IO'.
      2022-04-14 16:42:12   error  : Sync marker mismatch.
      2022-04-14 16:42:12   error  : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_IO'.
      2022-04-14 16:42:12   error  : Write to Client DCB ::ffff:10.8.2x.xx in state DCB::State::POLLING failed: 104, Connection reset by peer
      2022-04-14 16:42:12   error  : Sync marker mismatch.
      2022-04-14 16:42:12   error  : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_IO'.
      2022-04-14 16:42:12   error  : Write to Client DCB ::ffff:10.8.2x.xx in state DCB::State::POLLING failed: 104, Connection reset by peer
      2022-04-14 16:42:12   error  : Write to Client DCB ::ffff:10.8.2x.xx in state DCB::State::POLLING failed: 104, Connection reset by peer
      2022-04-14 16:42:14   error  : Sync marker mismatch.
      2022-04-14 16:42:14   error  : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_IO'.
      2022-04-14 16:42:16   error  : Sync marker mismatch.
      2022-04-14 16:42:16   error  : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_IO'.
      2022-04-14 16:42:18   error  : Write to Client DCB ::ffff:10.8.2x.xx in state DCB::State::POLLING failed: 104, Connection reset by peer
      2022-04-14 16:42:20   error  : Sync marker mismatch.
      2022-04-14 16:42:20   error  : [avrorouter] Reading Avro file failed with error 'MAXAVRO_ERR_IO'.
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            ponsuresh.pandians Pon Suresh Pandian
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.