[SERVER-71470] Aggregation with $lookup span multiple collections does not work correctly in multitenancy mode Created: 17/Nov/22  Updated: 29/Oct/23  Resolved: 03/Jan/23

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

Type: Task Priority: Major - P3
Reporter: Sophia Tan Assignee: Hugh Tong (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-72531 Complete TODO listed in SERVER-71470 Closed
Assigned Teams:
Serverless
Backwards Compatibility: Fully Compatible
Sprint: Server Serverless 2022-12-26, Server Serverless 2023-01-09
Participants:
Story Points: 5

 Description   

Test with injecting security token, the jstests/core/txns/aggregation_in_transaction.js get failure when it performs aggregations that look at other collections. 

Here is the error message and code.

  • "errmsg" : "Expected collection info, but found none; target collection: test.aggregation_in_transaction_lookup"
  • "code" : 5842600

It maybe is caused by the planner analysis code which drop off the tenant information. 



 Comments   
Comment by Githook User [ 06/Jan/23 ]

Author:

{'name': 'Sophia Tan', 'email': 'sophia_tll@hotmail.com', 'username': 'sophiatll'}

Message: SERVER-72531 Complete TODO listed in SERVER-71470
Branch: master
https://github.com/mongodb/mongo/commit/2a3aa2ed8eaf76163b0506c4c7a93cb913379b69

Comment by Githook User [ 03/Jan/23 ]

Author:

{'name': 'cortrain', 'email': '95658946+cortrain@users.noreply.github.com', 'username': 'cortrain'}

Message: SERVER-71470 Fix lookup agg across multiple collections for multitenancy
Branch: master
https://github.com/mongodb/mongo/commit/f004c2152bbf5302cd143c852f9b6d4b9319d098

Generated at Thu Feb 08 06:19:06 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.