Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.9
-
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
Issue Links
- is duplicated by
-
MDEV-25653 Replication between two cluster fails on ADD PARTITION
- Closed
- relates to
-
MDEV-25653 Replication between two cluster fails on ADD PARTITION
- Closed