/tmp/scan-results** files deleted but not releasing space from /tmp

Couchbase Server
,
1

/tmp/scan-results** files deleted but not releasing space from /tmp .

[root@node1 proc]#  lsof |grep -i deleted|grep scan-resul
cbq-engin 11014            couchbase    7u      REG              253,0   171967961    8638096 /tmp/scan-results11014403755131 (deleted)
cbq-engin 11014            couchbase   10u      REG              253,0   312417340    8638085 /tmp/scan-results11014104362772 (deleted)
cbq-engin 11014            couchbase   16r      REG              253,0   171967961    8638096 /tmp/scan-results11014403755131 (deleted)
cbq-engin 11014            couchbase   20u      REG              253,0         988    8638107 /tmp/scan-results11014418588368 (deleted)
cbq-engin 11014            couchbase   21u      REG              253,0    71820715    8638098 /tmp/scan-results11014711827557 (deleted)
cbq-engin 11014            couchbase   24u      REG              253,0   342599241    8638089 /tmp/scan-results11014650997645 (deleted)
cbq-engin 11014            couchbase   26u      REG              253,0   387898790    8638095 /tmp/scan-results11014893413516 (deleted)
cbq-engin 11014            couchbase   29r      REG              253,0   387898790    8638095 /tmp/scan-results11014893413516 (deleted)
cbq-engin 11014            couchbase   30r      REG              253,0   342599241    8638089 /tmp/scan-results11014650997645 (deleted)
cbq-engin 11014            couchbase   31u      REG              253,0    62628306    8638102 /tmp/scan-results11014665753261 (deleted)
cbq-engin 11014            couchbase   32r      REG              253,0    62628306    8638102 /tmp/scan-results11014665753261 (deleted)
2

This seems unexpected. Could you please try to kill cbq-engine process and see if that helps to release this space? The process will restart automatically.

3

Yes we already did that , is there any way we can prevent this

4

We haven’t seen this issue before. Next time this happens, can you please run the below command on the node running cbq-engine and share the output. This will help us investigate the problem.

curl http://localhost:6060/debug/pprof/goroutine?debug=1

5

we had a similar issue on our 3 node Windows 2016 server with couchbase Enterprise Edition 6.0.2 build 2413. Executing a query caused this error
[5000] open D:\Couchbase\Server\var\lib\couchbase\tmp\scan-results5960831968761: The system cannot find the path specified.
we fixed the issue by creating an empty tmp folder on all 3 nodes. Then everything worked!

6

Couchbase installation must have created tmp directory. If you changed directory to some thing else the directory must be present with proper permissions on all the nodes where query service is running. (Example 2)
https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/backfill.html