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

Revoking privileges from a non-existing user on a master breaks replication on the slave in the presence of replication filters

    XMLWordPrintable

Details

    Description

      The bug reported by MENT-1482 was decided to be fixed in the CS version as well. This ticket duplicates the enterprise report.

      In the presence of a replication filter on a slave, revoking privileges from a non-existing user on the master breaks replication on the slave. Without the filter, the slave just proceeds normally without any issues.

      How to reproduce:

      • Set up a master/replica
      • Configure a filter on the replica: replicate_do_wild_table=schema.%
      • On the master, execute revoke all privileges from 'nonexistentuser'@'%';

      Replication will break with:

      Query caused different errors on master and slave.
      Error on master: message (format)='Can't revoke all privileges for one or more of the requested users' error code=1269 ;
      Error on slave: actual message='no error', error code=0.
      Default database: ''.
      Query: 'REVOKE ALL PRIVILEGES FROM 'nonexistentuser'@'%''

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              bnestere Brandon Nesterenko
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.