Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-15196

Hashed index causes 'Overflow hashed AND stage buffered data usage' error

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 2.6.4
    • Component/s: Querying
    • None
    • ALL
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      I have documents like:

      {
  "_id": ObjectId("4cf567c4e4b08fffc3947252"),
  "kodoId": 1167286,
  "p": "/term/Japanese/Tanzania",
  "pl": "/term/japanese/tanzania",
  "r": "/viewWord.jsp?wordId=12083307",
  "l": "eng",
  "cd": new Date("2010-11-30T22:08:20+0100")
}

      and a hashed index on 'pl' added yesterday. Some unit tests now fail with:

      Overflow hashed AND stage buffered data usage of 33554468 bytes exceeds internal limit of 33554432 bytes

      on query

      {pl: 'blah', l: 'eng'}

      with sort

      {cd: -1}

      for some reason if I switch to sort {_id: -1} the error goes away.

            Assignee:
            rassi J Rassi (Inactive)
            Reporter:
            niccottrell Nic Cottrell (Personal) (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: