QAN - Explain tab is not showing values.

Description

Preconditions: Start pmm server using aws-staging-start jenkins job with mongo using flag --mongo-replica-for-backup.

Steps:

  1. Navigate to the QAN and select query (INSERT pbmLog, AGGREGATE test ,AGGREGATE student) for mongo db.

Expected Result:
Explain details are displayed in details tab.

Actual results:
(Location40413) BSON field 'insert.$db' is a duplicate field: cannot explain this type of query

How to test

Please use FB:
Try few “INSERT” queries/examples. “INSERT” should not be supported and you should get error message:
command %s is not supported for explain, where %s is it’s type (INSERT in this case, but for example DROP is same case).

How to document

None

Attachments

1

Activity

Show:

Jiří Čtvrtka 
August 21, 2024 at 9:00 AM

Flag added

Waiting on

Jiří Čtvrtka 
August 13, 2024 at 10:01 AM

are you getting same error for aggregate, dbstats queries like for insert? Or in this case there is another one? Thank you.

Ondrej Patocka 
July 9, 2024 at 12:22 PM

Refinement notes:
Can we have exact steps to reproduce listed (DB setup, queries run, timeline).
Also would be great to split the ticket per PG and Mongo techs and per feature.

Ondrej Patocka 
June 25, 2024 at 12:39 PM

Refinement notes:
Can we have exact steps to reproduce listed (DB setup, queries run, timeline).
Also would be great to split the ticket per PG and Mongo techs and per feature.

Nurlan Moldomurov 
April 24, 2024 at 1:09 PM

Could you please also add environment information.

Done

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Needs Doc

Planned Version/s

Fix versions

Story Points

Regression Issue

Yes

Found by Automation

Yes

Affects versions

Smart Checklist Progress

Created April 18, 2024 at 12:28 PM
Updated November 13, 2024 at 8:34 AM
Resolved August 21, 2024 at 1:26 PM