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

optimize table: Query could not be tokenized/Parsing the query failed, cannot report query type

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.2.17
    • 2.4.8
    • dbfwfilter, qc_sqlite
    • None
    • SLES12.3
    • MXS-SPRINT-101

    Description

      optimize table <tab> throws error (client):
      MariaDB [****]> optimize table ****;
      ERROR 1141 (HY000): Access denied for user '****'@'::ffff:****': Query could not be tokenized and will hence be rejected. Please ensure that the SQL syntax is correct.

      maxscale-log:
      2018-12-20 15:48:23 info : (5) [qc_sqlite] Parsing the query failed, cannot report query type: optimize table ****
      2018-12-20 15:48:23 warning: (5) [dbfwfilter] Query could not be tokenized and will hence be rejected. Please ensure that the SQL syntax is correct: optimize table ****

      when using dbfwfilter and rules containing regex
      no regex-rules: optimize table works.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            thiesmeincke Thies Meincke
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.