Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Issues

Select view

Select search mode

 
50 of 67

PMM QAN is Broken when Query having Explain Keyword

Description

PMM QAN is broken when Query having Explain keywords:

E.g.:

explain select * from t1 where c2>1 and c2<=3;

As soon as you click on explain tab in QAN for such queries it failed with invalid GetActionRequest.ActionId: value length muct be at least 1 runes

 

Proposed Solution (draft)

  • detect + show err msg - not possible to run explain on explain

How to test

FB: https://github.com/Percona-Lab/pmm-submodules/pull/3865

Test together with https://perconadev.atlassian.net/browse/PMM-12784

Original Steps

  1. Start PMM 2.44 using the docker.

  2. Start MySQL, any version of your choice, in my test,t I used PS 8.0.39

  3. Add Service to PMM

  4. Create the following table with data in MySQL:

    use test; CREATE TABLE `t1` ( `c1` int NOT NULL, `c2` varchar(100) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; insert into t1 values(1,1),(2,2),(3,3),(4,5); Run following Queries: explain select * from t1 where c1=1; explain select * from t1 where c2=1; explain select * from t1 where c2>1 and c2<=3;

  5. Once the above queries start to be visible in QAN, just click on any of the queries and go to the Explain tab.

  6. The reported error will be seen.

How to document

None

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Needs Doc

No

Planned Version/s

Fix versions

Story Points

Sprint

Affects versions

Start date

Smart Checklist

Created December 24, 2024 at 9:58 AM
Updated 4 days ago
Configure

Activity

Show:

Matej Kubinec last week

Most likely caused by the same issue as in https://perconadev.atlassian.net/browse/PMM-12784 - fix will be to provide a reason why explain cannot be run on query.