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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5.9
    • 10.4.19, 10.5.10
    • Galera
    • 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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25653 Replication between two cluster fails on ADD PARTITION

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25653 Replication between two cluster fails on ADD PARTITION

          • Major - Major loss of function.
          • Closed

          Activity

            People

              jplindst Jan Lindström (Inactive)
              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.