Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23638

DROP TRIGGER in Galera Cluster not replicating

Details

    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".

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              jplindst Jan Lindström (Inactive)
              fabrykowski Fabrykowski
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.