Uploaded image for project: 'Go Driver'
  1. Go Driver
  2. GODRIVER-117

cursor timeout on agg pipeline

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Connections
    • None

    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.

      Attachments

        Activity

          People

            sam.rossi@mongodb.com Samuel Rossi (Inactive)
            adinoyi.omuya@mongodb.com Adinoyi Omuya
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: