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:
2.6.7
OS:
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’ } ‘’