search

mongodb-js / compass

The GUI for MongoDB.
https://mongodb.com/compass
Other
1.15k stars 176 forks source link

Bug Report: explain plan failed on sharded cluster #2159

Closed artjomkruglenkov closed 8 months ago

artjomkruglenkov commented 3 years ago

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

Possible Solution

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

Additional Context/Screenshots

c4c1us commented 3 years ago

Same issue when using $or operator.

Anemy commented 3 years ago

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:

artjomkruglenkov commented 3 years ago

Hi @Anemy.

Yes, at least with the ones I have tried.

Around 2.3mil

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.

rose-m commented 3 years ago

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!

artjomkruglenkov commented 3 years ago

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

silver-mx commented 3 years ago

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.

alenakhineika commented 1 year ago

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.

himanshusinghs commented 8 months ago

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. 🚀🌟

artjomkruglenkov commented 8 months ago

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

Anemy commented 8 months ago

Sounds good, going to close this then, thanks!