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

assertion 17144 Runner error: Overflow sort stage buffered data usage of 33554584 bytes exceeds internal limit of 33554432 bytes

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • 2.6.1
    • Querying
    • None

    Description

      we're having this issue with 2.6.1. how can we fix this problem?

      2014-09-11T15:48:36.726-0700 [conn11525]  ntoskip:0 ntoreturn:-1
      2014-09-11T15:48:36.726-0700 [conn11525] query rcfgmongo.CONFIG_312e312e312e32 query: { query: { SCOPE: 2021 }, orderby: { OFFSET: 1 } } keyUpdates:0 exception: Runner error: Overflow sort stage buffered data usage of 33554584 bytes exceeds internal limit of 33554432 bytes code:17144 numYields:4 locks(micros) r:4170258 reslen:158 2620ms
      2014-09-11T15:48:37.505-0700 [conn11533] assertion 17144 Runner error: Overflow sort stage buffered data usage of 33554584 bytes exceeds internal limit of 33554432 bytes ns:rcfgmongo.CONFIG_312e312e312e32 query:{ query: { SCOPE: 2021 }, orderby: { OFFSET: 1 } }

      rcfgmongo:PRIMARY> db.CONFIG_312e312e312e32.getIndexes();
      [
              {
                      "v" : 1,
                      "key" : {
                              "_id" : 1
                      },
                      "name" : "_id_",
                      "ns" : "rcfgmongo.CONFIG_312e312e312e32"
              },
              {
                      "v" : 1,
                      "key" : {
                              "SCOPE" : 1,
                              "KEY" : 1
                      },
                      "name" : "SCOPE_1_KEY_1",
                      "ns" : "rcfgmongo.CONFIG_312e312e312e32",
                      "background" : true
              },
              {
                      "v" : 1,
                      "key" : {
                              "KEY" : 1
                      },
                      "name" : "KEY_1",
                      "ns" : "rcfgmongo.CONFIG_312e312e312e32",
                      "background" : true
              },
              {
                      "v" : 1,
                      "key" : {
                              "CTX" : 1
                      },
                      "name" : "CTX_1",
                      "ns" : "rcfgmongo.CONFIG_312e312e312e32",
                      "background" : true
              },
              {
                      "v" : 1,
                      "unique" : true,
                      "key" : {
                              "UID" : 1
                      },
                      "name" : "UID_1",
                      "ns" : "rcfgmongo.CONFIG_312e312e312e32",
                      "background" : true
              },
              {
                      "v" : 1,
                      "key" : {
                              "SCOPE" : 1
                      },
                      "name" : "SCOPE_1",
                      "ns" : "rcfgmongo.CONFIG_312e312e312e32",
                      "OFFSET" : -1
              }
      ]
      rcfgmongo:PRIMARY> 

      Attachments

        Activity

          People

            ramon.fernandez@mongodb.com Ramon Fernandez Marina
            nammo Nam Tang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: