No such file or directory - cause: open /apps/

I’m seeing the below error intermittently in my application server’s log. This bug is causing service endpoints to fail when attempting a basic query. Note, I am not seeing this error when connecting to the community edition build on my localhost (Community Edition 6.0.0 build 1693 ‧ IPv4). I was able to apply a temporary fix by adding a more performant index. Our admin believes this is a client side problem so I’m starting here. Please let me know if this needs to be posted elsewhere. Thanks all

server build:
Enterprise Edition 6.0.1 build 2037 ‧ IPv4

couchbase node.js client version:

Windows 10
Windows Server 2012 R2

query sent:
select FleetVisits.* from FleetVisits where app = ‘FVR’ AND type=‘Property’

Note, app and type are indexed separately. The temp fix creates an index with both attributes.

2019-09-16 10:31 AM { Error: open /apps/cb/product/6.0.0/opt/couchbase/var/lib/couchbase/tmp/scan-results7136117725760: no such file or directory - cause: open /apps/cb/product/6.0.0/opt/couchbase/var/lib/couchbase/tmp/scan-results7136117725760: no such file or directory

2019-09-16 10:31 AM requestID: ‘6576a82a-41da-45b0-823f-b99752ed7583’,

2019-09-16 10:31 AM at c:\apps\fvr-app-server\node_modules\couchbase\lib\bucket.js:933:17

2019-09-16 10:31 AM code: 5000,

2019-09-16 10:31 AM otherErrors: ,

2019-09-16 10:31 AM responseBody:

2019-09-16 10:31 AM ‘{\n"requestID": “6576a82a-41da-45b0-823f-b99752ed7583”,\n"signature": {"":""},\n"results": [\n],\n"errors": [{“code”:5000,“msg”:“open /apps/cb/product/6.0.0/opt/couchbase/var/lib/couchbase/tmp/scan-results7136117725760: no such file or directory - cause: open /apps/cb/product/6.0.0/opt/couchbase/var/lib/couchbase/tmp/scan-results7136117725760: no such file or directory”}],\n"status": “errors”,\n"metrics": {“elapsedTime”: “7.536918ms”,“executionTime”: “7.366039ms”,“resultCount”: 1,“resultSize”: 533,“errorCount”: 1}\n}\n’ } ‘’

Error 5000 is the N1QL query service’s default error of sorts. It’s effectively HTTP 500 with an extra zero. The problem isn’t on the client in this case.

From the message, it seems to indicate the query service was trying to open a temporary file created during its processing of the query, but couldn’t find the file. There is probably more in the logs of that node which took the query processing. You might want to grab that and create a post in the Couchbase Server topic.