-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Fully Compatible
-
ALL
-
-
Query 2019-01-14, Query 2019-01-28, Query 2019-02-11
Currently, running a nested $lookup pipeline on a sharded cluster will fail:
[js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 2018-12-20T13:33:59.472-0500 E QUERY [js] Error: command failed: { [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 "ok" : 0, [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 "errmsg" : "$lookup must run on mongoS, but cannot :: caused by :: $lookup must run on a shard", [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 "code" : 20, [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 "codeName" : "IllegalOperation", [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 "operationTime" : Timestamp(1545330839, 14), [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 "$clusterTime" : { [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 "clusterTime" : Timestamp(1545330839, 16), [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.473-0500 "signature" : { [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.474-0500 "hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="), [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.474-0500 "keyId" : NumberLong(0) [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.474-0500 } [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.474-0500 } [js_test:lookup_max_nested_pipeline] 2018-12-20T13:33:59.474-0500 } :
Part of this ticket is changing jstests/noPassthrough/lookup_max_nested_pipeline.js to also run in the sharded case.
- depends on
-
SERVER-32308 Add the ability for a $lookup stage to execute on mongos against a sharded foreign collection
- Closed
- is depended on by
-
SERVER-38995 Allow geoNear within a lookup pipeline in the sharded case
- Closed
-
SERVER-38996 Allow $text within a lookup pipeline in the sharded case
- Closed
-
SERVER-32536 Add collation support for sharded $lookup.
- Closed
-
SERVER-32548 Add $lookup support for sharded views
- Closed
-
SERVER-38825 Gate sharded $lookup / $graphLookup with FCV check
- Closed
-
SERVER-38830 Support sharded $lookup 'let' variable serialization for shard to shard routing
- Closed
-
SERVER-27533 Allow "from" collection of $graphLookup to be sharded
- Closed
-
SERVER-38758 Avoid restarting $lookup from the top if a stale version error is encountered during a single lookup
- Closed
-
SERVER-39015 Make local reads for $lookup/$graphLookup (on unsharded collections) provide a shard version
- Closed
-
SERVER-39016 Make sharded $lookup queries run on non-primary shards able to target the primary shard
- Closed
-
SERVER-39048 Ban $lookup on sharded collections while in a transaction
- Closed
- related to
-
SERVER-74102 Hedging options should only be available on `mongos`
- Closed