Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.9
-
None
-
None
-
3 and 5 node galera clusters, 8 cpus 24g memory, rhel 8 VMware vms
Description
Creating a table and then altering the tables colums does not replicate across all nodes even with TOI enabled, you must manually replicate the changes, or expert the database from the server you created it on and reimport.
MariaDB [(none)]> show global variables like '%osu%'; |
+------------------+-------+ |
| Variable_name | Value |
|
+------------------+-------+ |
| wsrep_osu_method | TOI |
|
+------------------+-------+ |
|
|
MySQL [toitest1]> create table toitest1 ( test1 boolean, test2 boolean, test3 boolean ); |
|
|
All nodes |
MariaDB [toitest1]> desc toitest1; |
+-------+------------+------+-----+---------+-------+ |
| Field | Type | Null | Key | Default | Extra | |
+-------+------------+------+-----+---------+-------+ |
| test1 | tinyint(1) | YES | | NULL | | |
| test2 | tinyint(1) | YES | | NULL | | |
| test3 | tinyint(1) | YES | | NULL | | |
+-------+------------+------+-----+---------+-------+ |
|
|
|
|
MySQL [toitest1]> alter table toitest1 rename column test1 to test15; |
Query OK, 0 rows affected (0.01 sec) |
Records: 0 Duplicates: 0 Warnings: 0
|
|
|
|
|
Writer node
|
MariaDB [toitest1]> desc toitest1; |
+--------+------------+------+-----+---------+-------+ |
| Field | Type | Null | Key | Default | Extra | |
+--------+------------+------+-----+---------+-------+ |
| test15 | tinyint(1) | YES | | NULL | | |
| test2 | tinyint(1) | YES | | NULL | | |
| test3 | tinyint(1) | YES | | NULL | | |
|
|
All other nodes |
|
|
MariaDB [toitest1]> desc toitest1; |
+-------+------------+------+-----+---------+-------+ |
| Field | Type | Null | Key | Default | Extra | |
+-------+------------+------+-----+---------+-------+ |
| test1 | tinyint(1) | YES | | NULL | | |
| test2 | tinyint(1) | YES | | NULL | | |
| test3 | tinyint(1) | YES | | NULL | | |
+-------+------------+------+-----+---------+-------+ |
3 rows in set (0.002 sec) |
the same issue happens if you attempt to add a new column.