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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.17
    • Fix Version/s: 2.4.8
    • Component/s: dbfwfilter, qc_sqlite
    • Labels:
      None
    • Environment:
      SLES12.3
    • Sprint:
      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

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            thiesmeincke Thies Meincke
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration