Operational Defect Database
BugZero found this defect 79 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
MongoDB | 2596189
EOF optimization in MultiPlanner causes profile_find.js to fail due to missing replanReason
Last update date:
3/13/2024
Affected products:
MongoDB Server
Affected releases:
No affected releases provided.
Fixed releases:
8.0.0-rc0
Description:
Info
Failing test: jstests/core/administrative/profile/profile_find.js . Problem When EOF optimization is available, MultiPlanner constructs the executor with `_multiPlanStage` and returns the executor directly. This causes the jstest failure because the specific stats returned by MultiPlanStats does not have `replanReason` field. Approach Consolidate both the stats MultiPlanStats and CachedPlanStats to have `replanReason` field and allow passing the replanReason into `_multiPlanStage`. Note After addressing the issue, re-enable the test core/administrative/profile/profile_find.js .
Top User Comments
xgen-internal-githook commented on Wed, 13 Mar 2024 01:55:06 +0000: Author: {'name': 'Chi-I Huang', 'email': '8468853+chiihuang@users.noreply.github.com', 'username': 'chiihuang'} Message: SERVER-87377 Add replanReason in MultiPlanStats (#19843) SERVER-87377 Add replanReason in MultiPlanStats When Classic Runtime Planner for SBE is enabled and CachedPlanner decides to replan a query, replanReason is missed when EOF optimization is used in MultiPlanner. This is because the explainer only access the stats from the underlying MultiPlanStage and its specific stats does not have that. This commit adds an optional field to allow the caller to pass in replanReason when MultiPlanStage is constructed and hence the reason can be propagated from CachedPlanner, MultiPlanner to MultiPlanStage. GitOrigin-RevId: d137bcb6155c9920a8390d3880d211d3f5a9f0fe Branch: master https://github.com/mongodb/mongo/commit/09beadac8799d384d61c2d37dc6daf9c4842a4a9
Steps to Reproduce
ninja -j128 install-devcore && buildscripts/resmoke.py run --suite core --mongodSetParameters='{logComponentVerbosity: {query: 5}}' --additionalFeatureFlags featureFlagSbeFull,featureFlagClassicRuntimePlanningForSbe jstests/core/administrative/profile/profile_find.js .
