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

            btburnett3 Brant Burnett created issue -
            Sitaram.Vemulapalli Sitaram Vemulapalli made changes -
            Field Original Value New Value
            Fix Version/s Cheshire-Cat [ 15915 ]
            mihir.kamdar Mihir Kamdar made changes -
            Affects Version/s 6.6.1 [ 17002 ]
            kamini.jagtiani Kamini Jagtiani made changes -
            Assignee Kamini Jagtiani [ kamini.jagtiani ] Marco Greco [ marco.greco ]
            mihir.kamdar Mihir Kamdar made changes -
            Labels approved-for-6.6.1
            mihir.kamdar Mihir Kamdar made changes -
            Link This issue blocks MB-40528 [ MB-40528 ]
            marco.greco Marco Greco made changes -
            Fix Version/s 6.6.1 [ 17002 ]
            marco.greco Marco Greco made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            wayne Wayne Siu made changes -
            Assignee Marco Greco [ marco.greco ] Mihir Kamdar [ mihir.kamdar ]
            pierre.regazzoni Pierre Regazzoni made changes -
            Assignee Mihir Kamdar [ mihir.kamdar ] Pierre Regazzoni [ JIRAUSER25157 ]
            pierre.regazzoni Pierre Regazzoni made changes -
            VERIFICATION STEPS Run query in repro other 50 times.
            Resolution Fixed [ 1 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            pierre.regazzoni Pierre Regazzoni made changes -
            Assignee Pierre Regazzoni [ JIRAUSER25157 ] Marco Greco [ marco.greco ]
            marco.greco Marco Greco made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Resolved [ 5 ]
            pierre.regazzoni Pierre Regazzoni made changes -
            Assignee Marco Greco [ marco.greco ] Pierre Regazzoni [ JIRAUSER25157 ]
            pierre.regazzoni Pierre Regazzoni made changes -
            VERIFICATION STEPS Run query in repro other 50 times. Run query in repro other 100 times.
            Status Resolved [ 5 ] Closed [ 6 ]
            marco.greco Marco Greco made changes -
            Assignee Pierre Regazzoni [ JIRAUSER25157 ] Marco Greco [ marco.greco ]
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            marco.greco Marco Greco made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Resolved [ 5 ]
            wayne Wayne Siu made changes -
            Assignee Marco Greco [ marco.greco ] Mihir Kamdar [ mihir.kamdar ]
            mihir.kamdar Mihir Kamdar made changes -
            Assignee Mihir Kamdar [ mihir.kamdar ] Pierre Regazzoni [ JIRAUSER25157 ]
            marco.greco Marco Greco made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            marco.greco Marco Greco made changes -
            Link This issue causes MB-44258 [ MB-44258 ]
            lynn.straus Lynn Straus made changes -
            Fix Version/s 7.0.0 [ 17233 ]
            lynn.straus Lynn Straus made changes -
            Fix Version/s Cheshire-Cat [ 15915 ]

              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