-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
None
-
Affects Version/s: 1.11.2
-
Component/s: Compass
-
None
-
Iteration Bison
Anyone can connect to the M001 student cluster.
Hostname: cluster0-shard-00-00-jxeqq.mongodb.net
Username: m001-student
Password: m001-mongodb-basics
Replica Set Name: Cluster0-shard-0
Read Preference: Primary Preferred
The citibike.trips collection contains about 2 million documents with average size 440 bytes.
The following queries against the start and end station location fields caused the Compass schema analysis to hang the user interface.
{'start station location': {$geoWithin: { $centerSphere: [ [ -73.98475067347545, 40.73712494487114 ], 0.0013784387806381328 ]}}} {'end station location': {$geoWithin: { $centerSphere: [ [ -73.98475067347545, 40.73712494487114 ], 0.0013784387806381328 ]}}}
The following query causes the schema analysis to take longer than 10 seconds and then freeze about in about two thirds of my tests.
{tripduration: {$gte: 60, $lt: 50010}}
Neither the DevTools nor "DEBUG=*" command line outputs showed any subsequent output when the agg pipeline times out.
I captured the following from the Atlas real time tab.
{ "waitingForLock" : false, "desc" : "conn9493", "threadId" : "140398637815552", "client" : "71.14.15.226:54915", "ns" : "citibike.trips", "clientMetadata" : { "os" : { "type" : "Darwin", "name" : "darwin", "architecture" : "x64", "version" : "15.6.0" }, "platform" : "Node.js v7.4.0, LE, mongodb-core: 2.1.17", "driver" : { "name" : "nodejs", "version" : "2.2.33" } }, "opid" : 2140841, "op" : "command", "lockStats" : { "Global" : { "acquireCount" : { "r" : 25076 } }, "Database" : { "acquireCount" : { "r" : 12538 } }, "Collection" : { "acquireCount" : { "r" : 12537 } } }, "planSummary" : "IXSCAN { tripduration: 1 }", "active" : true, "secs_running" : 8, "microsecs_running" : 8988974, "query" : { "aggregate" : "trips", "pipeline" : [{ "$match" : { "tripduration" : { "$gte" : 60, "$lt" : 50010 } } }, { "$sample" : { "size" : 1000 } }], "allowDiskUse" : true, "maxTimeMS" : 10000, "cursor" : { "batchSize" : 1000 } }, "connectionId" : 9493, "numYields" : 11918, "locks" : { "Global" : "r", "Database" : "r", "Collection" : "r" } }
- duplicates
-
COMPASS-3539 Compass Hangs When Sampling Larger Collections
- Closed
- related to
-
COMPASS-3157 Enforce maxTimeMS for every query sent to the server
- Closed