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

        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.