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

ALTER TABLE not replicated with Galera in MariaDB 10.5.9

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.9
    • Fix Version/s: 10.4.19, 10.5.10
    • Component/s: Galera
    • Labels:
    • Environment:
      Debian Buster (LXC containers in Ubuntu 20.10), MariaDB from official repo (10.5.9+maria~buster)

      Description

      After upgrading 3-node cluster from 10.5.8 to 10.5.9, I noticed that ALTER TABLE statements are not replicated. Change is visible only on initiator. No log message anywhere.

      Later when I try to write a row in that table, other node fails:

      2021-02-23 15:17:33 2 [ERROR] Slave SQL: Column 57 of table 'xx.xx' cannot be converted from type 'tinyint' to type 'enum('unknown','ok','warning','slow','response_tim', Internal MariaDB error code: 1677
       
      ...
       
      2021-02-23 15:17:33 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on 654e4dc9-1f74-11eb-9dab-7e7fcd43b6b6:20437917
               at /home/buildbot/buildbot/build/galera/src/replicator_smm.cpp:process_apply_error():1347
      

      I tried many different ALTER TABLE statements, without success. For example, CREATE TABLE works. All DML commands are also ok.

      After downgrading back to 10.5.8, everything works.

        Attachments

        1. galera_2_cluster_alter.cnf
          0.5 kB
          Mario Karuza
        2. galera_2_cluster_alter.test
          2 kB
          Mario Karuza

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              pstast Petr Šťastný
              Votes:
              2 Vote for this issue
              Watchers:
              10 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.