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

ALTER TABLE races in replication on slave side

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.0
    • None
    • None
    • None
    • Linux RHEL6

    Description

      Setup:

      Master: Percona 5.5.24-rel26.0.256
      Middle: Percona 5.5.20-rel24.1.217
      Slave: MariaDB-10.0.0

      On Master:
      Say you have the following table:

      CREATE TABLE `audit_publication_publication_rtb` (
      `audit_publication_publication_rtb_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `publication_id` int(10) unsigned NOT NULL,
      `old_publisher_id` int(10) unsigned DEFAULT NULL,
      `old_rtb_id` varchar(255) DEFAULT NULL,
      `new_publisher_id` int(10) unsigned DEFAULT NULL,
      `new_rtb_id` varchar(255) DEFAULT NULL,
      `record_action` int(1) DEFAULT NULL,
      `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      PRIMARY KEY (`audit_publication_publication_rtb_id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      This table is being inserted into constantly.

      I then run the following statement:
      ALTER TABLE adfonic.audit_publication_publication_rtb
      ADD old_status VARCHAR(32) AFTER old_rtb_id,
      ADD new_status VARCHAR(32) AFTER new_rtb_id;

      This propagates fine to the Middle server.

      However, on the Slave server running MariaDB 10.0.0, this seems to cause replication to break:

      Slave_SQL_Running is No
      Last_Error is Column 4 of table 'db.audit_publication_publication_rtb' cannot be converted from type 'varchar(96)' to type 'int(10) unsigned', Last_SQL_Error is Column 4 of table 'db.audit_publication_publication_rtb' cannot be converted from type 'varchar(96)' to type 'int(10) unsigned'

      At a glance, it looks like the inserts in new format are somehow overtaking the alter table statement in the replication stream.

      Attachments

        Activity

          People

            elenst Elena Stepanova
            gordan Gordan Bobic
            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.