mongodb config_error ai_generated true

MongoServerError: collation mismatch on index

ID: mongodb/collation-mismatch

Also available as: JSON · Markdown
82%Fix Rate
86%Confidence
3Evidence
2023-01-01First Seen

Version Compatibility

VersionStatusIntroducedDeprecatedNotes
7 active — — —

Root Cause

Query collation doesnt match index collation.

generic

Workarounds

  1. 90% success Specify matching collation in query: {collation:{locale:"en"}}
  2. 88% success Create index with same collation as most common queries

Dead Ends

Common approaches that don't work:

  1. Remove all collations 72% fail

    Loses locale-aware sorting

  2. Create duplicate indexes with different collations 75% fail

    Index bloat