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

Join queries hang without returning results

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Cheshire-Cat, 6.6.1
    • 6.6.1, 7.0.0
    • query
    • 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
    • Untriaged
    • CBCollectInfo is attached
    • 1
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  PagerDuty