Explain section returns different results
General
Escalation
General
Escalation
Description
How to test
None
How to document
None
Attachments
3
is caused by
Smart Checklist
Activity
Show:

Roman Misyurin July 3, 2020 at 9:17 AM
Wait for the backend fixes
Details
Details
Assignee
Unassigned
UnassignedReporter

Priority
Components
Needs QA
Yes
Needs Doc
Yes
Story Points
1
Environment
server docker - perconalab/pmm-server-fb:PR-863-78ec537
client - https://s3.us-east-2.amazonaws.com/pmm-build-cache/PR-BUILDS/pmm2-client/pmm2-client-PR-863-78ec537.tar.gz
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created May 28, 2020 at 7:59 AM
Updated November 13, 2024 at 8:34 AM
STR:
Open these two instances, select few queries and notice that Explain section is returning different results.
http://18.216.249.15/graph/d/pmm-qan/pmm-query-analytics?columns=%5B%22load%22,%22num_queries%22,%22query_time%22%5D&filter_by=a4e608692ba2721250c223e88b0110cf&var-environment=All&var-cluster=All&var-replication_set=All&var-database=All&var-schema=All&var-node_name=All&var-service_name=All&var-service_type=All&var-service_type=mysql&var-service_type=mongodb&var-node_type=All&var-interval=$__auto_interval_interval&order_by=-load&group_by=queryid&from=now-12h&to=now&totals=false&query_selected=true
http://18.219.161.142/graph/d/pmm-qan/pmm-query-analytics?columns=%5B%22load%22,%22num_queries%22,%22query_time%22%5D&filter_by=0777f5fb19c1c948f63a61c7df1778a2&var-environment=All&var-cluster=All&var-replication_set=All&var-database=All&var-schema=All&var-node_name=All&var-service_name=All&var-service_type=All&var-service_type=mongodb&var-service_type=mysql&var-node_type=All&var-interval=$__auto_interval_interval&order_by=-load&group_by=queryid&from=now-12h&to=now&totals=false&query_selected=true
Actual result:
The first one showing "No explains found" for every single query - backend is not answering with results
Second one is answering with results and showing explains correctly
***
Both instances were same version and same settings. This appears also for queries where the fingerprint matches the example.
For example query - see attachments
SELECT `TABLE_SCHEMA` , TABLE_NAME , `TABLE_TYPE` , `ifnull` ( ENGINE , ? ) AS ENGINE , `ifnull` ( `VERSION` , ? ) AS `VERSION` , `ifnull` ( ROW_FORMAT , ? ) AS ROW_FORMAT , `ifnull` ( `TABLE_ROWS` , ? ) AS `TABLE_ROWS` , `ifnull` ( `DATA_LENGTH` , ? ) AS `DATA_LENGTH` , `ifnull` ( `INDEX_LENGTH` , ? ) AS `INDEX_LENGTH` , `ifnull` ( `DATA_FREE` , ? ) AS `DATA_FREE` , `ifnull` ( `CREATE_OPTIONS` , ? ) AS `CREATE_OPTIONS` FROM `information_schema` . `tables` WHERE `TABLE_SCHEMA` = ?