Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
Cheshire-Cat, 6.6.1
-
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
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | Cheshire-Cat [ 15915 ] |
| Affects Version/s | 6.6.1 [ 17002 ] |
| Assignee | Kamini Jagtiani [ kamini.jagtiani ] | Marco Greco [ marco.greco ] |
I don't have the complete picture yet, but it seems like the some children of the intersect scan have gone away without notifying the parent
goroutine 91047 [semacquire, 1 minutes]:
sync.runtime_Semacquire(0xc0000e7c54)
/usr/local/go/src/runtime/sema.go:56 +0x42
sync.(*WaitGroup).Wait(0xc0000e7c54)
/usr/local/go/src/sync/waitgroup.go:130 +0x64
github.com/couchbase/query/execution.(*valueExchange).retrieveChildNoStop(0xc0000e7b80, 0x1)
/home/marco/query/src/github.com/couchbase/query/execution/exchange.go:488 +0xbc
github.com/couchbase/query/execution.(*base).childrenWaitNoStop(0xc0000e7b80, 0x1)
/home/marco/query/src/github.com/couchbase/query/execution/base.go:780 +0x50
github.com/couchbase/query/execution.(*IntersectScan).RunOnce.func1()
/home/marco/query/src/github.com/couchbase/query/execution/scan_intersect.go:151 +0x86c
github.com/couchbase/query/util.(*Once).Do(0xc0000e7cb8, 0xc0019ddf50)
/home/marco/query/src/github.com/couchbase/query/util/sync.go:55 +0x4a
github.com/couchbase/query/execution.(*IntersectScan).RunOnce(0xc0000e7b80, 0xc000e0c000, 0x28b8940, 0xc003b2fe00)
/home/marco/query/src/github.com/couchbase/query/execution/scan_intersect.go:65 +0x82
github.com/couchbase/query/execution.execOp(0x28c08e0, 0xc0000e7b80, 0xc000e0c000, 0x28b8940, 0xc003b2fe00)
/home/marco/query/src/github.com/couchbase/query/execution/base.go:495 +0x54
created by github.com/couchbase/query/execution.(*base).fork
/home/marco/query/src/github.com/couchbase/query/execution/base.go:505 +0xfa
| Labels | approved-for-6.6.1 |
| Link | This issue blocks MB-40528 [ MB-40528 ] |
| Fix Version/s | 6.6.1 [ 17002 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Resolved [ 5 ] |
Build couchbase-server-7.0.0-3906 contains query commit f40fd5e with commit message:
MB-42825 hangs on intersect scan
Build couchbase-server-6.6.1-9200 contains query commit 3c7ab4b with commit message:
MB-42825 hangs on intersect scan
| Assignee | Marco Greco [ marco.greco ] | Mihir Kamdar [ mihir.kamdar ] |
| Assignee | Mihir Kamdar [ mihir.kamdar ] | Pierre Regazzoni [ JIRAUSER25157 ] |
I could easily repro issue on build 6.6.1-9192.
I then tried on 6.6.1-9200:
- I did first run of query with 50 occurrence which worked.
- Then tried 100 times but query then hanged on iteration 46.
[root@localhost ~]# cat query-46.out |
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 |
You can check cluster http://172.23.104.92:8091/Â which has 6.6.1-9200.
To repro simply run on server node:
cd /root/
|
for (( i=0; i<100; ++i)); do /opt/couchbase/bin/cbq -u Administrator -p password -f query.sql -o query-${i}.out; done |
Â
| VERIFICATION STEPS | Run query in repro other 50 times. | |
| Resolution | Fixed [ 1 ] | |
| Status | Resolved [ 5 ] | Reopened [ 4 ] |
| Assignee | Pierre Regazzoni [ JIRAUSER25157 ] | Marco Greco [ marco.greco ] |
| Resolution | Fixed [ 1 ] | |
| Status | Reopened [ 4 ] | Resolved [ 5 ] |
Build couchbase-server-7.0.0-3920 contains query commit 4beab79 with commit message:
MB-42825 reopen allowed on a stop signal
Build couchbase-server-6.6.1-9204 contains query commit fe59898 with commit message:
MB-42825 reopen allowed on a stop signal
| Assignee | Marco Greco [ marco.greco ] | Pierre Regazzoni [ JIRAUSER25157 ] |
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.
| VERIFICATION STEPS | Run query in repro other 50 times. | Run query in repro other 100 times. |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Assignee | Pierre Regazzoni [ JIRAUSER25157 ] | Marco Greco [ marco.greco ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Reopened [ 4 ] |
Build couchbase-server-7.0.0-3934 contains query commit ddc4d65 with commit message:
MB-42825 tighten children waiting
Build couchbase-server-6.6.1-9209 contains query commit b65840a with commit message:
MB-42825 tighten children waiting
Marco Greco Are we waiting for any further fixes? If not, can this be resolved now ?
| Resolution | Fixed [ 1 ] | |
| Status | Reopened [ 4 ] | Resolved [ 5 ] |
| Assignee | Marco Greco [ marco.greco ] | Mihir Kamdar [ mihir.kamdar ] |
| Assignee | Mihir Kamdar [ mihir.kamdar ] | Pierre Regazzoni [ JIRAUSER25157 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Fix Version/s | 7.0.0 [ 17233 ] |
| Fix Version/s | Cheshire-Cat [ 15915 ] |
Repro:
install travel-sample
run the query (couple of times in UI or cbq shell)
Looks like some synchronization issue.
runtime.goparkunlock(...)