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

Replication Error with compressed columns

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.11.4
    • N/A
    • Replication
    • None
    • Debian

    Description

      I am getting this error while trying to do master-slave replication:

      Column 1 of table 'meshok.sale_description' cannot be converted from type 'mediumblob' to type 'mediumtext /*!100301 COMPRESSED*/'
      

      Table definition on master:

      CREATE TABLE `sale_description` (
        `id` int(10) unsigned NOT NULL DEFAULT 0,
        `description` mediumtext  NOT NULL,
        `d_add` varchar(1000) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
      

      Table definition on slave:

      CREATE TABLE `sale_description` (
        `id` int(10) unsigned NOT NULL DEFAULT 0,
        `description` mediumtext  /*!100301 COMPRESSED*/ NOT NULL DEFAULT '',
        `d_add` varchar(1000) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            alexcool Alex
            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.