-
Type:
Question
-
Resolution: Done
-
Priority:
Major - P3
-
None
-
Affects Version/s: 2.6.1
-
Component/s: Querying
-
None
-
None
-
None
-
None
-
None
-
None
-
None
-
None
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>