-
Type:
Bug
-
Resolution: Cannot Reproduce
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Connections
-
None
-
None
-
None
-
None
-
None
-
None
-
None
-
None
This query sometimes returns a cursor not found error when run against 3.6.0-rc0.
db.order_header.aggregate([
{"$match":{"order_number":{"$ne":null}}},
{"$lookup":{"as":"__joined_ORDER_DETAILS","foreignField":"order_number","from":"order_details","localField":"order_number"}},
{"$unwind":{"path":"$__joined_ORDER_DETAILS","preserveNullAndEmptyArrays":false}},
{"$project":{"ORDER_DETAILS_DOT_product_number":"$__joined_ORDER_DETAILS.product_number","ORDER_DETAILS_DOT_quantity":"$__joined_ORDER_DETAILS.quantity","ORDER_DETAILS_DOT_quantity*ORDER_DETAILS_DOT_unit_sale_price":{"$multiply":["$__joined_ORDER_DETAILS.quantity","$__joined_ORDER_DETAILS.unit_sale_price"]},"ORDER_DETAILS_DOT_unit_sale_price":"$__joined_ORDER_DETAILS.unit_sale_price"}},
{"$project":{"Sales_DOT_Product_number":"$ORDER_DETAILS_DOT_product_number","Sales_DOT_Revenue":"$ORDER_DETAILS_DOT_quantity*ORDER_DETAILS_DOT_unit_sale_price"}}
])
The exact error message is something like:
unable get the next batch for cursor 133684215895: (CursorNotFound) Cursor not found, cursor id: 133684215895 (see SUPPORT-2370 for more).
The database export the pipeline is run against can be fetched at https://ibm.box.com/s/6o1gvrq5f9fgr3ccyn7tv6p15xt6mk7z (the collections are in the gosales1021 database.