compass icon indicating copy to clipboard operation
compass copied to clipboard

Published 20 hours ago • verified publisher icon mongodb-js

Bug Report: explain plan failed on sharded cluster

Open artjomkruglenkov opened this issue 3 years ago • 6 comments

Explain plan does not longer work after upgrading to Compass 1.26.0

Bug Report

Current Behavior

In Compass version 1.26.0 when explain button is clicked in Explain plan section then nothing happens and screen does not update.

Code/Gist

Expected Behavior/Code

The expected behavior is to evaluate plan as it was before in version 1.25.0

Environment

  • node.js / npm versions: v12.16.3 / npm 7.8.0
  • OS: OSX 10.15.7

Possible Solution

Revert to previous version 1.25.0 where explain plan functionality does work as expected.

Additional Context/Screenshots

artjomkruglenkov avatar Apr 07 '21 08:04 artjomkruglenkov

Same issue when using $or operator.

c4c1us avatar Apr 07 '21 14:04 c4c1us

Hi @artjomkruglenkov - thanks for reporting. I haven't been able to reproduce this yet, here's couple questions to hopefully help us identify what's happening:

  • Does this happen with every query?
  • How many documents are in the collection?
  • Does it work on a collection with a smaller amount of documents?
  • Is this a sharded cluster?

Anemy avatar Apr 07 '21 21:04 Anemy

Hi @Anemy.

  • Does this happen with every query?

Yes, at least with the ones I have tried.

  • How many documents are in the collection.

Around 2.3mil

  • Does it work on a collection with a smaller amount of documents?
  • Is this a sharded cluster?

Yes, it's a sharded cluster. In fact, after your question I have tried running the same queries with non-sharded mongo setup and much fewer entries. In these cases explain plan works as expected.

artjomkruglenkov avatar Apr 07 '21 23:04 artjomkruglenkov

Thanks for the response @artjomkruglenkov! I'd have another question that would be interesting: which MongoDB server versions did you connect to? Was the test with the non-sharded setup the same version as the sharded cluster?

Thanks for your help!

rose-m avatar Apr 08 '21 13:04 rose-m

@rose-m The mongodb version is the same for both deployments: 4.2.12.

artjomkruglenkov avatar Apr 08 '21 13:04 artjomkruglenkov

I can confirm the same issue on the MacOS version (unsure about windows and linux). Our database is as well mongo db community version 4.2.12. I have tried with mongodb compass 1.26.0 and 1.26.1 and explain shows no results, as if the query were not executed somehow. I needed to downgrade to compass 1.25.0, and explain works fine again.

silver-mx avatar Apr 12 '21 08:04 silver-mx

Hey, could you please try this again with the latest Compass? We have a new explain plan experience now, to check if the issue has gone away.

alenakhineika avatar Oct 20 '23 13:10 alenakhineika

Hi @artjomkruglenkov and @silver-mx! Wanted to check in on how the new explain plan experience is working out for you. Have the recent releases addressed the issue you were facing earlier? Your feedback is invaluable, and we appreciate your insights. 🚀🌟

himanshusinghs avatar Feb 08 '24 12:02 himanshusinghs

Hi @himanshusinghs. For me, explain plan functionality works as expected in Compass 1.42.0

artjomkruglenkov avatar Feb 08 '24 19:02 artjomkruglenkov

Sounds good, going to close this then, thanks!

Anemy avatar Feb 09 '24 06:02 Anemy