Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8915

Replication ignoring column which is missing on slave

    XMLWordPrintable

Details

    Description

      Replication appears to silently fail on a table which exists on the slave that is missing a column that is on the master. The master is part of a 3-node Galera setup. The column was created during an rolling-schema update which makes me wonder if that's the reason the column never made it to the slave. Row based replication is of course being used here.

      The relay log on the slave includes the column when doing a 'mysqlbinlog -v -v'. The column is the last column on the table.

      The table is getting updated on the slave, minus the column. So it looks like it's just silently ignoring the missing column from the replication stream but writing the rest of the data? Slave_skip_errors is empty and slave_sql_verify_checksum is enabled.

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            m00dawg Tim Soderstrom
            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.