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

Maxscale CDC to Kafka job is failing for few tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.2.3
    • 6.3.1
    • cdc
    • None
    • Ubuntu 20.04
    • 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

            markus makela markus makela
            ponsuresh.pandians Pon Suresh Pandian (Inactive)
            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.