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

Parsing the query failed, cannot report query type with pp_sqlite in Maxscale 25.10

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 25.10.3
    • 25.10.5
    • qc_sqlite
    • None
    • MXS-SPRINT-279, MXS-SPRINT-280
    • Unexpected results
    • Hide
      The parser of MaxScale was not able to parse the SQL statement, which led to it not being classified. That meant that the query was always sent to the primary. Now that the parser has been updated, the query is parsed and will therefore, since it is a read-only query, be sent to a replica.
      Show
      The parser of MaxScale was not able to parse the SQL statement, which led to it not being classified. That meant that the query was always sent to the primary. Now that the parser has been updated, the query is parsed and will therefore, since it is a read-only query, be sent to a replica.

    Description

      Getting below error with Maxscale 25.10.3 while parsing the query with Common Table Expression (WITH …), MATCH AGAINST and UNION

      2026-08-13 05:02:59   info   : (36408) [pp_sqlite] (Galera-RW-Service); Parsing the query failed, cannot report query type:  WITH filtered_processors AS (SELECT DISTINCT SUBSTR(proc_identifier,1,12) item_prefix, SUBSTR(proc_identifier,14,4) proc_code FROM my_schema.processor_master WHERE MATCH(proc_identifier) AGAINST ('SEARCH_TERM' IN BOOLEAN MODE)) SELECT DISTINCT A.item_id, PB.proc_code FROM my_schema.settlement_records A JOIN filtered_processors PB ON A.item_id = PB.item_prefix WHERE A.run_time = '20:00' AND A.is_active = 'Y' AND A.proc_mode = 'MODE_A' AND A.item_id IN (SELECT DISTINCT item_id FROM my_schema.batch_queue WHERE is_active = 'Y') AND A.item_id NOT IN (SELECT DISTINCT item_id FROM my_schema.job_history WHERE (event_date='2026-08-11' AND exec_status='COMPLETED')) UNION DISTINCT SELECT DISTINCT SUBSTRING(item_id,1,12), PB.proc_code FROM my_schema.job_history JTB JOIN filtered_processors PB ON JTB.item_id = PB.item_prefix WHERE event_date='2026-08-11' AND exec_status='FAILED' AND JTB.proc_mode='MODE_A' AND item_id NOT IN (SELECT item_id FROM my_schema.job_history_retry WHERE event_date='2026-08-11' AND exec_status='COMPLETED') GROUP BY item_id HAVING COUNT(*)<3;
      

      This is obfuscated version of query with all schemas, tables, columns, and business-specific values replaced with generic placeholders.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            niljoshi Nilnandan Joshi
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 2d
                2d
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 5h Time Not Required
                5h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.