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

Query parsing failing for certain queries when invoked from database firewall filter

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • qc_sqlite
    • None

    Description

      MaxScale is configured with database firewall filter and readwrite split service. Configuration files are attached

      Parsing for following query fails when invoked from dbfwfilter

      MySQL [tpcc]> select * from orders having count(*) > 10 group by o_carrier_id limit 10;
      ERROR 1141 (HY000): Access denied for user 'appuser'@'172.19.0.1' to database 'tpcc': dbfwfilter: 
      Query could not be parsed completely and will hence be rejected.
      

      Parsing of following query does not fail.

      MySQL [tpcc]> select * from orders where o_id > 1000 limit 10;
      +------+--------+--------+--------+--------------+----------+-------------+---------------------+
      | o_id | o_w_id | o_d_id | o_c_id | o_carrier_id | o_ol_cnt | o_all_local | o_entry_d           |
      +------+--------+--------+--------+--------------+----------+-------------+---------------------+
      | 1001 |      1 |      1 |   2350 |            9 |        8 |           1 | 2016-10-06 02:31:53 |
      | 1002 |      1 |      1 |   2977 |            4 |        5 |           1 | 2016-10-06 02:31:53 |
      | 1003 |      1 |      1 |   1863 |            7 |        8 |           1 | 2016-10-06 02:31:53 |
      | 1004 |      1 |      1 |   2684 |            6 |        6 |           1 | 2016-10-06 02:31:53 |
      | 1005 |      1 |      1 |   2378 |           10 |        5 |           1 | 2016-10-06 02:31:53 |
      | 1006 |      1 |      1 |   2689 |            5 |       14 |           1 | 2016-10-06 02:31:53 |
      | 1007 |      1 |      1 |   2116 |            6 |        9 |           1 | 2016-10-06 02:31:53 |
      | 1008 |      1 |      1 |   1521 |            1 |        8 |           1 | 2016-10-06 02:31:53 |
      | 1009 |      1 |      1 |   1249 |           10 |       15 |           1 | 2016-10-06 02:31:53 |
      | 1010 |      1 |      1 |   2502 |            2 |       12 |           1 | 2016-10-06 02:31:53 |
      +------+--------+--------+--------+--------------+----------+-------------+---------------------+
      10 rows in set (0.01 sec)
      

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            dshjoshi Dipti Joshi (Inactive)
            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.