[PMM-6256] Query Analytics Dashboard: 'InvalidNamespace' EXPLAIN error with some MongoDB queries - Percona JIRA

XML

Word

Printable

Details

Type: Bug
Status: Done
Priority: High
Resolution: Fixed
Affects Version/s: 2.9.0
Fix Version/s: 2.9.1
Component/s: PMM Agent
Labels:
None

Story Points:
0
Needs Review:
Yes
Needs QA:
Yes

Description

STR:
I generated queries for the next types:
count()
aggregate()
findandmodify()
distinct()

And it seems there are some problem with explain for these queries
For all these types explain returns:

 (InvalidNamespace) Mismatched $db in explain command. Expected admin but got sbtest: cannot explain this type of query

http://10.30.3.50/graph/d/pmm-qan/pmm-query-analytics?columns=%5B%22load%22,%22num_queries%22,%22query_time%22%5D&filter_by=b8daf18df8f8bfa4ddcb60b38d93e790&var-environment=All&var-cluster=All&var-replication_set=All&var-database=All&var-schema=All&var-node_name=All&var-node_name=bm-qanqa04.bm.int.percona.com&var-service_name=All&var-service_type=All&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&details_tab=explain

For distinct query:

 {"service_id":"/service_id/03f30f98-5a15-4191-be5b-2f707c166f18","query":"{\"ns\":\"sbtest.inventory\",\"op\":\"command\",\"command\":{\"distinct\":\"inventory\",\"key\":\"item.sku\",\"query\":{},\"lsid\":{\"id\":{\"$binary\":{\"base64\":\"XfBTls2VQ8uoNOn4s1luPw==\",\"subType\":\"04\"}}},\"$db\":\"sbtest\"}}"}