Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-5481

Galera Monitor does not log an error if "SHOW SLAVE STATUS" fails

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 21.06.18, 22.08.15, 23.02.12, 23.08.8, 24.02.4, 25.01.1
    • 23.08.9, 24.02.5, 25.01.2
    • galeramon
    • None
    • MXS-SPRINT-227

    Description

      Affects all versions, but only reported on 23.08.

      Galera Monitor does not need any special privileges to monitor a Galera Cluster. The monitor does require REPLICA MONITOR to detect traditional replication (with "SHOW SLAVE STATUS"). The monitor runs "SHOW SLAVE STATUS" on all monitored servers but ignores errors on executing the query, as Galera-related status information could still be queried. If the monitor lacks the REPLICA MONITOR-privilege, the only effect is the server's Access_denied_errors counter increasing.

      As "SHOW SLAVE STATUS" is an extra query the Galera Monitor only uses to detect traditional replicas (not Galera replication), this usually does not affect the user. The issue was detected by a user who noticed the access denied error counter continuously increasing and was confused as to why, as MaxScale did not log an error or a warning.
      To show the error counter, run SHOW GLOBAL STATUS LIKE '%Access%';

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            esa.korhonen Esa Korhonen
            esa.korhonen Esa Korhonen
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.