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

            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.1-9204 contains query commit fe59898 with commit message:
            MB-42825 reopen allowed on a stop signal

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.1-9204 contains query commit fe59898 with commit message: MB-42825 reopen allowed on a stop signal
            Hide
            pierre.regazzoni Pierre Regazzoni added a comment -

            Verified with following build:

            • 6.6.1-9204
            • 7.0.0-3920
              Ran query over 100 times without issue multiple times.
              Also did a continuous run for 5 minutes without hangs.
            Show
            pierre.regazzoni Pierre Regazzoni added a comment - Verified with following build: 6.6.1-9204 7.0.0-3920 Ran query over 100 times without issue multiple times. Also did a continuous run for 5 minutes without hangs.
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.0.0-3934 contains query commit ddc4d65 with commit message:
            MB-42825 tighten children waiting

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-3934 contains query commit ddc4d65 with commit message: MB-42825 tighten children waiting
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.1-9209 contains query commit b65840a with commit message:
            MB-42825 tighten children waiting

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.1-9209 contains query commit b65840a with commit message: MB-42825 tighten children waiting
            Hide
            mihir.kamdar Mihir Kamdar added a comment -

            Marco Greco Are we waiting for any further fixes? If not, can this be resolved now ?

            Show
            mihir.kamdar Mihir Kamdar added a comment - Marco Greco Are we waiting for any further fixes? If not, can this be resolved now ?

              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