[SERVER-57957] $lookup with an unsharded foreign collection fails in a transaction when sharded lookup is enabled Created: 22/Jun/21  Updated: 29/Oct/23  Resolved: 15/Jul/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.1.0-rc0

Type: Bug Priority: Major - P3
Reporter: Hana Pearlman Assignee: Hana Pearlman
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-39048 Ban $lookup on sharded collections wh... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Sprint: Query Optimization 2021-07-12, Query Optimization 2021-07-26
Participants:

 Description   

$lookup against a sharded foreign collection while in a transaction is not allowed, but it should work when the foreign collection is unsharded. However, when sharded lookup is enabled, $lookup against an unsharded foreign collection while in a transaction fails.



 Comments   
Comment by Vivian Ge (Inactive) [ 06/Oct/21 ]

Updating the fixversion since branching activities occurred yesterday. This ticket will be in rc0 when it’s been triggered. For more active release information, please keep an eye on #server-release. Thank you!

Comment by Githook User [ 15/Jul/21 ]

Author:

{'name': 'Hana Pearlman', 'email': 'hana.pearlman@mongodb.com', 'username': 'HanaPearlman'}

Message: SERVER-39048, SERVER-57957: ban sharded $lookup and $graphLookup in a transaction
Branch: master
https://github.com/mongodb/mongo/commit/8343cf83a31d03c07aefd32674bcf93820bb2947

Generated at Thu Feb 08 05:43:13 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.