Connection_closed error while querying view

Couchbase Server
1

When trying to query some view (~4M documents in view, nearly 400M in bucket) via CURL I’m getting errors with the enigmatic reason "connection_closed”.
I’ve used the “collect logs” function which is in UI but this generated a very large amount of logs. Analyzing it shows nothing useful at first glance.
How to find any bits of information that may lead us to resolve the error? Below you can find CURL and Errors array from response:
Curl

`

curl --location -g ‚{user}:{password}@couch06.{somedomain.tld}:8092/{bucket_name}/_design/{doc_name}/_view/{view_name}?inclusive_end=true&reduce=false&startkey=[%22x%22]&endkey=[%22xxx%22]’

Json Errors object:
“errors”:[

{“from”:“couch07.somedomain.tld:8092”,“reason”:“connection_closed”},

{“from”:“couch01.somedomain.tld:8092”,“reason”:“connection_closed”},

{“from”:“couch05.somedomain.tld:8092”,“reason”:“connection_closed”},

{“from”:“couch02.somedomain.tld:8092”,“reason”:“connection_closed”},

{“from”:“couch08.somedomain.tld:8092”,“reason”:“connection_closed”},

{“from”:“couch04.somedomain.tld:8092”,“reason”:“connection_closed”},

{“from”:“couch03.somedomain.tld:8092”,“reason”:“connection_closed”}

]
`

2

How many seconds before the messages appear? I suspect the query nodes disconnected because of timeouts.

3

It actually runs for a few minutes with mixed results, but 9/10 times there is “connection_error”. Different results during the tests came out, most often between 400k and 1.6M - I guess I wasn’t precise with the description. Additionally, the total_rows key always looks like a valid number (~4M). The CURL tests should fetch the entire view, but actually in the code we use batches of 50k with the same results.
It looks like this:

  1. send Curl request
  2. works under a minute,
  3. pause for a few minutes with 0 kbps download
  4. ends json with errors.
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.