[MDEV-23638] DROP TRIGGER in Galera Cluster not replicating Created: 2020-09-01  Updated: 2020-10-06  Resolved: 2020-09-08

Status: Closed
Project: MariaDB Server
Component/s: Galera, Triggers
Affects Version/s: 10.5.5
Fix Version/s: 10.5.7

Type: Bug Priority: Major
Reporter: Fabrykowski Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: drop, galera, replication, triggers
Environment:

Galera cluster with 3 nodes, MariaDB version 10.5.5

Issue Links:
Relates
relates to MDEV-21578 CREATE OR REPLACE TRIGGER in Galera c... Closed

 Description   

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: https://github.com/fabrykowski/galera_drop_trigger_mwe

Issue MDEV-21578 is similar, but deals only with "CREATE OR REPLACE" and not with "DROP".
Generated at Thu Feb 08 09:23:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.