codership / galera

Synchronous multi-master replication library
GNU General Public License v2.0
448 stars 176 forks source link

`drop trigger` not replicated #578

Closed fabrykowski closed 4 years ago

fabrykowski commented 4 years ago

I have set up a small cluster of three MariaDB servers synchronised via Galera.

Everything works perfectly, except for the fact that I can neither edit nor drop triggers from tables, once defined. The only way to get rid of a trigger is to drop the entire table, which – for obvious reasons – is a non-starter.

Even though my actual setup is bare-metal, I have put together an MWE running on Docker and exhibiting the same behaviour: galera_drop_trigger_mwe

Is there anything missing from my configuration, or is this actually a bug in this constellation?

janlindstrom commented 4 years ago

This is clearly a bug, please fill a bug report at jira.mariadb.org

fabrykowski commented 4 years ago

This bug is tracked by https://jira.mariadb.org/browse/MDEV-21578 https://jira.mariadb.org/browse/MDEV-23638.