Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.1, Cheshire-Cat
-
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
- causes
-
MB-44258 join with double intersect scan returns no rows
- Closed
For Gerrit Dashboard: MB-42825 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
141189,2 | MB-42825 hangs on intersect scan | mad-hatter | query | Status: MERGED | +2 | +1 |
141253,3 | MB-42825 hangs on intersect scan | master | query | Status: MERGED | +2 | +1 |
141311,2 | MB-42825 reopen allowed on a stop signal | mad-hatter | query | Status: MERGED | +2 | +1 |
141314,2 | MB-42825 tighten children waiting | mad-hatter | query | Status: MERGED | +2 | +1 |
141382,3 | MB-42825 reopen allowed on a stop signal | master | query | Status: MERGED | +2 | +1 |
141426,2 | MB-42825 tighten children waiting | master | query | Status: MERGED | +2 | +1 |
145674,2 | MB-44258 join with intersect scan returns no rows, regression from MB 42825 | mad-hatter | query | Status: MERGED | +2 | +1 |
145819,4 | MB-44258 join with intersect scan returns no rows, regression from MB 42825 | master | query | Status: MERGED | +2 | +1 |