mongodb runtime_error ai_generated true

MongoServerError：查询形状的计划缓存条目已失效但无法重新规划：内部错误

MongoServerError: PlanCache invalidated entry for query shape but could not re-plan: internal error

ID: mongodb/plan-cache-invalidation-failed

其他格式: JSON · Markdown 中文 · English
82%修复率
88%置信度
1证据数
2024-01-10首次发现

根因分析

由于索引更改或数据分布变化，查询形状的计划缓存条目失效，但查询规划器因缓存元数据损坏或索引缺失而无法生成新计划。

English

The plan cache entry for a query shape was invalidated due to index changes or data distribution shifts, but the query planner failed to generate a new plan due to corrupted cache metadata or missing index.

generic

官方文档

https://www.mongodb.com/docs/manual/reference/command/planCacheClear/

解决方案

  1. Run db.collection.getPlanCache().clear() followed by db.collection.createIndex() for the missing index, then re-execute the query to force a fresh plan.
  2. Upgrade to MongoDB 7.0+ where plan cache invalidation is more robust; if not possible, set internalQueryPlanCacheSize to 0 in the configuration to disable caching temporarily.

无效尝试

常见但无效的做法:

  1. 90% 失败

    Restarting mongod clears the plan cache temporarily, but the error reoccurs if the underlying cause (e.g., missing index or stale statistics) isn't addressed.

  2. 70% 失败

    Manually running db.collection.getPlanCache().clear() may not help if the query shape is still cached in the server's internal structures; the error persists.