-
Type: Bug
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: 3.0.0
-
Component/s: Text Search
-
Labels:None
-
Environment:{code}
PS D:\mongodb\bin> mongo.exe --eval "printjson(db.serverBuildInfo())"
MongoDB shell version: 3.0.2
connecting to: test
{
"version" : "3.0.2",
"gitVersion" : "6201872043ecbbc0a4cc169b5482dcf385fc464f",
"targetMinOS" : "Windows 7/Windows Server 2008 R2",
"OpenSSLVersion" : "OpenSSL 1.0.1m-fips 19 Mar 2015",
"sysInfo" : "windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack
1') BOOST_LIB_VERSION=1_49",
"loaderFlags" : "/nologo /DEBUG /INCREMENTAL:NO /LARGEADDRESSAWARE /OPT:REF",
"compilerFlags" : "/TP /nologo /EHsc /W3 /wd4355 /wd4800 /wd4267 /wd4244 /wd4290 /wd4068 /wd4351 /we4099 /Z7 /er
rorReport:none /MD /O2 /Oy- /Gw /Gy /Zc:inline",
"allocator" : "system",
"versionArray" : [
3,
0,
2,
0
],
"javascriptEngine" : "V8",
"bits" : 64,
"debug" : false,
"maxBsonObjectSize" : 16777216,
"ok" : 1
}
{code}{code} PS D:\mongodb\bin> mongo.exe --eval "printjson(db.serverBuildInfo())" MongoDB shell version: 3.0.2 connecting to: test { "version" : "3.0.2", "gitVersion" : "6201872043ecbbc0a4cc169b5482dcf385fc464f", "targetMinOS" : "Windows 7/Windows Server 2008 R2", "OpenSSLVersion" : "OpenSSL 1.0.1m-fips 19 Mar 2015", "sysInfo" : "windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49", "loaderFlags" : "/nologo /DEBUG /INCREMENTAL:NO /LARGEADDRESSAWARE /OPT:REF", "compilerFlags" : "/TP /nologo /EHsc /W3 /wd4355 /wd4800 /wd4267 /wd4244 /wd4290 /wd4068 /wd4351 /we4099 /Z7 /er rorReport:none /MD /O2 /Oy- /Gw /Gy /Zc:inline", "allocator" : "system", "versionArray" : [ 3, 0, 2, 0 ], "javascriptEngine" : "V8", "bits" : 64, "debug" : false, "maxBsonObjectSize" : 16777216, "ok" : 1 } {code}
-
Windows
Hi All,
Recently I update my DB from2.6 to 3.0. I find when I execute command
db.DeviceDataCurr.find({$text:{$search:"hostname"}},{_id:1}).limit(10)
via mongo.exe, the Server memory will increase, The server died after I looped run this command.
I tried many times and found that both mmapv1 and wiredtiger have this promblem.
I also tried v2.6, It works fine.
Hope your response.
there are some db log
2015-04-11T20:59:41.271-0400 I QUERY [conn12] query NGDomain111.DeviceDataCurr query: { $text: { $search: "hostname" } } planSummary: TEXT {} cursorid:30552791919 ntoreturn:10 ntoskip:0 nscanned:58912 nscannedObjects:58912 keyUpdates:0 writeConflicts:0 numYields:461 nreturned:10 reslen:550 locks:{ Global: { acquireCount: { r: 462 } }, MMAPV1Journal: { acquireCount: { r: 462 } }, Database: { acquireCount: { r: 462 } }, Collection: { acquireCount: { R: 462 } } } 1744ms 2015-04-11T20:59:42.061-0400 I STORAGE [DataFileSync] flushing mmaps took 14790ms for 14 files 2015-04-11T20:59:42.651-0400 I QUERY [conn12] query NGDomain111.DeviceDataCurr query: { $text: { $search: "hostname" } } planSummary: TEXT {} cursorid:31386534272 ntoreturn:10 ntoskip:0 nscanned:58912 nscannedObjects:58912 keyUpdates:0 writeConflicts:0 numYields:461 nreturned:10 reslen:550 locks:{ Global: { acquireCount: { r: 462 } }, MMAPV1Journal: { acquireCount: { r: 462 } }, Database: { acquireCount: { r: 462 } }, Collection: { acquireCount: { R: 462 } } } 1375ms 2015-04-11T20:59:44.443-0400 I QUERY [conn12] query NGDomain111.DeviceDataCurr query: { $text: { $search: "hostname" } } planSummary: TEXT {} cursorid:31826192619 ntoreturn:10 ntoskip:0 nscanned:58912 nscannedObjects:58912 keyUpdates:0 writeConflicts:0 numYields:462 nreturned:10 reslen:550 locks:{ Global: { acquireCount: { r: 463 } }, MMAPV1Journal: { acquireCount: { r: 463 } }, Database: { acquireCount: { r: 463 } }, Collection: { acquireCount: { R: 463 } } } 1786ms 2015-04-11T20:59:45.915-0400 I QUERY [conn12] query NGDomain111.DeviceDataCurr query: { $text: { $search: "hostname" } } planSummary: TEXT {} cursorid:31081467184 ntoreturn:10 ntoskip:0 nscanned:58912 nscannedObjects:58912 keyUpdates:0 writeConflicts:0 numYields:462 nreturned:10 reslen:550 locks:{ Global: { acquireCount: { r: 463 } }, MMAPV1Journal: { acquireCount: { r: 463 } }, Database: { acquireCount: { r: 463 } }, Collection: { acquireCount: { R: 463 } } } 1468ms 2015-04-11T21:00:21.665-0400 I COMMAND [PeriodicTaskRunner] task: DBConnectionPool-cleaner took: 421ms 2015-04-11T21:00:27.988-0400 I COMMAND [PeriodicTaskRunner] task: DBConnectionPool-cleaner took: 375ms 2015-04-11T21:01:31.943-0400 I COMMAND [PeriodicTaskRunner] task: DBConnectionPool-cleaner took: 528ms 2015-04-11T21:01:32.589-0400 I COMMAND [PeriodicTaskRunner] task: DBConnectionPool-cleaner took: 244ms 2015-04-11T21:02:30.713-0400 I QUERY [conn12] query NGDomain111.DeviceDataCurr query: { $text: { $search: "hostname" } } planSummary: TEXT {} cursorid:31859778607 ntoreturn:10 ntoskip:0 nscanned:58912 nscannedObjects:58912 keyUpdates:0 writeConflicts:0 numYields:483 nreturned:10 reslen:550 locks:{ Global: { acquireCount: { r: 484 } }, MMAPV1Journal: { acquireCount: { r: 484 } }, Database: { acquireCount: { r: 484 } }, Collection: { acquireCount: { R: 484 } } } 164738ms 2015-04-11T21:02:31.388-0400 I NETWORK [conn12] SocketException handling request, closing client connection: 9001 socket exception [SEND_ERROR] server [127.0.0.1:50994]