Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-15153

N1QL query should not fail when a rebalance operation is stuck or slow because data is there on active partitions

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • Untriaged
    • Unknown

    Description

      Executed the query for travel-sample bucket (below) and it fails with bulk get error message.

      cbq> SELECT a.name, s.flight, s.utc, r.sourceairport, r.destinationairport, r.equipment FROM `travel-sample` r UNNEST r.schedule s JOIN `travel-sample` a ON KEYS r.airlineid WHERE r.sourceairport='SFO' AND r.destinationairport='SEA' AND s.day=6 ORDER BY a.name;

      Output-
      {
      "requestID": "e4da0284-fadb-43c8-af67-31370de56585",
      "signature":

      { "destinationairport": "json", "equipment": "json", "flight": "json", "name": "json", "sourceairport": "json", "utc": "json" }

      ,
      "results": [
      ],
      "errors": [
      {
      "code": 12008,
      "msg": "Error performing buck get - cause:

      {4 errors, starting with bulkget exceeded MaxBulkRetries for vbucket 797}

      "
      }
      ],
      "status": "errors",
      "metrics":

      { "elapsedTime": "1m51.860439115s", "executionTime": "1m51.86016719s", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      Attachments

        1. AWS_colm.png
          AWS_colm.png
          240 kB
        2. AWS_QUERY_RESULTS.png
          AWS_QUERY_RESULTS.png
          113 kB
        3. AWS_query.log
          1.11 MB
        4. AWS_REBALANCE.png
          AWS_REBALANCE.png
          307 kB
        5. MB-15153.zip
          10.60 MB
        6. Screen Shot 2015-07-06 at 11.02.36 AM.png
          Screen Shot 2015-07-06 at 11.02.36 AM.png
          352 kB
        7. Screen Shot 2015-07-18 at 8.02.35 PM.png
          Screen Shot 2015-07-18 at 8.02.35 PM.png
          130 kB
        8. Screen Shot 2015-07-20 at 2.50.26 PM.png
          Screen Shot 2015-07-20 at 2.50.26 PM.png
          381 kB
        9. Screen Shot 2015-07-24 at 11.22.42 AM.png
          Screen Shot 2015-07-24 at 11.22.42 AM.png
          402 kB
        10. Screen Shot 2015-07-24 at 11.22.54 AM.png
          Screen Shot 2015-07-24 at 11.22.54 AM.png
          426 kB
        11. Screen Shot 2015-07-24 at 11.32.00 AM.png
          Screen Shot 2015-07-24 at 11.32.00 AM.png
          56 kB
        12. Screen Shot 2015-07-24 at 11.44.11 AM.png
          Screen Shot 2015-07-24 at 11.44.11 AM.png
          59 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            colm Colm Mchugh (Inactive)
            anil Anil Kumar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            12 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty