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

ERROR 1193: Unknown system variable 'maxscale_version' : SELECT @@maxscale_version

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 2.2.14
    • N/A
    • N/A
    • using maxscale 2.2.14 and 10.3.9-MariaDB with Galera

    Description

      Galera is running on 3 MariaDB 10.3.9 servers successfully. Attempting to use maxscale 2.2.14 to route to the servers. All looks fine on both ends, but it is not working.

      This error is scrolling on the 3 MariaDB servers in the sql_error.log file:

      ERROR 1193: Unknown system variable 'maxscale_version' : SELECT @@maxscale_version

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          markus makela markus makela added a comment -

          What monitor module are you using? Galera clusters should use the galeramon module but it does not perform the query in question. It is quite likely that you have configured the mariadbmon, intended for master-slave replication clusters, instead of the galeramon.

          The query you see in the error log is used by MaxScale to detect if the server is a binlogrouter server and is currently executed unconditonally.

          markus makela markus makela added a comment - What monitor module are you using? Galera clusters should use the galeramon module but it does not perform the query in question. It is quite likely that you have configured the mariadbmon, intended for master-slave replication clusters, instead of the galeramon. The query you see in the error log is used by MaxScale to detect if the server is a binlogrouter server and is currently executed unconditonally.
          shansylvia Shannon added a comment -

          thank you, yes. I just used the template the was bundled in the Redhat 7 package. I no longer see the errors. thanks very much.

          shansylvia Shannon added a comment - thank you, yes. I just used the template the was bundled in the Redhat 7 package. I no longer see the errors. thanks very much.
          markus makela markus makela added a comment -

          Closing as Not a Bug since the issue was resolved with a change of monitor modules.

          markus makela markus makela added a comment - Closing as Not a Bug since the issue was resolved with a change of monitor modules.

          People

            Unassigned Unassigned
            shansylvia Shannon
            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.