Details
Description
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"
|
}
|
}
|
Attachments
Issue Links
- duplicates
-
COMPASS-3539 Compass Hangs When Sampling Larger Collections
-
- Closed
-
- related to
-
COMPASS-3157 Enforce maxTimeMS for every query sent to the server
-
- Closed
-