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

Please recognise some commands seen by the binlog router which trigger error reporting

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.4.3
    • 1.4.3
    • binlogrouter
    • None

    Description

      Seen in 1.4.3.2.

      The following 2 messages get seen in the maxscale log files triggered by some monitoring scripts etc. They cause no harm but it would be useful if the binlog router could recognise them and respond accordingly:

      Unexpected query from 'user'@'10.1.2.3': set autocommit=1
      Unexpected query from 'user'@'10.1.2.4': select USER()

      The first command just requires some sort of "OK" type response, and the second one would give the given user details, such as:

      root@localhost [(none)]> select USER();
      +----------------+
      | USER()         |
      +----------------+
      | root@localhost |
      +----------------+
      1 row in set (0.00 sec)
      

      This is not very important but does keep noisy logging to a minimum.

      Attachments

        Activity

          People

            Massimiliano Pinto Massimiliano Pinto (Inactive)
            sjmudd Simon Mudd
            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.