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: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 25.10.3
    • 25.10
    • None
    • None
    • MXS-SPRINT-279

    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:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 2d
                2d
                Remaining:
                Remaining Estimate - 2d
                2d
                Logged:
                Time Spent - Not Specified
                Not Specified

                Git Integration

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