[GODRIVER-117] cursor timeout on agg pipeline Created: 02/Nov/17  Updated: 16/Nov/17  Resolved: 16/Nov/17

Status: Closed
Project: Go Driver
Component/s: Connections
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Adinoyi Omuya Assignee: Samuel Rossi (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related

 Description   

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.



 Comments   
Comment by Samuel Rossi (Inactive) [ 16/Nov/17 ]

I'm unable to reproduce this, so I'm going to close it. Feel free to reopen it if you can get it to reproduce.

Comment by Adinoyi Omuya [ 03/Nov/17 ]

It was failing reliably via the BI Connector (which essentially runs the aggregation against a server) but I haven't tested it solely with the Go driver nor with other drivers.

Comment by David Golden [ 02/Nov/17 ]

Can it be replicated consistently? Can the same error be replicated with other drivers (i.e. is this is server issue or a driver issue)?

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