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

Join queries hang without returning results

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Cheshire-Cat, 6.6.1
    • Fix Version/s: 6.6.1, 7.0.0
    • Component/s: query
    • Environment:
      Docker for Windows 10 20H2
      Image: couchbase/server:7.0.0-beta
      All services enabled
      Plasma indexes
      Loaded beer-sample and travel-sample buckets and created an empty default bucket
    • Triage:
      Untriaged
    • Link to Log File, atop/blg, CBCollectInfo, Core dump:
      CBCollectInfo is attached
    • Story Points:
      1
    • Is this a Regression?:
      Yes

      Description

      Queries involving joins may hang unexpectedly and never return results. This query in particular, generated by the Linq2Couchbase integration tests, seems to work often:

      SELECT `Extent2`.`airportname` as `airportName`, `Extent1`.`airline` as `airline`
      FROM `travel-sample` as `Extent1`
      INNER JOIN `travel-sample` as `Extent2` ON (`Extent1`.`destinationairport` = `Extent2`.`faa`) 
      WHERE ((`Extent1`.`type` = 'route') AND (`Extent2`.`type` = 'airport')) 
      LIMIT 1
      

      I have replicated repeatedly from the .NET SDK, using cURL, and in the Query Workbench. The HTTP request appears to get hung and never return a value and, in the case of cURL, never timeout. However, sometimes (rarely) valid results are returned.

        Attachments

          Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            Activity

            No work has yet been logged on this issue.

              People

              Assignee:
              pierre.regazzoni Pierre Regazzoni
              Reporter:
              btburnett3 Brant Burnett
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Gerrit Reviews

                    PagerDuty