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

Replication SQL error when type text is converted to text compressed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.5.16
    • N/A
    • Replication
    • None

    Description

      We wanted to rolling upgrade a chat message table, so we took a first replica and change our table definition with the following SQL:

      alter table chat_messages MODIFY COLUMN `text` text COMPRESSED COLLATE utf8mb4_unicode_ci DEFAULT NULL;

      Once done the replication was broken with the following error message

      Last_SQL_Error: Column 6 of table 'XXX.chat_messages' cannot be converted from type 'blob' to type 'text /!100301 COMPRESSED/'
      

      *Note to reproduce replication settings *

      • binlog_format : ROW
      • Using_Gtid: Current_Pos
      • Parallel_Mode: optimistic

      *Note to reproduction table definition *

      • The column origin column type COLUMN `text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
      • The table is range partitioned by on timestamp created_at column
      • The table is engine innodb

      Attachments

        Activity

          People

            Unassigned Unassigned
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.