There is a some way to cancel a FTS query that is expensive? Currently I can not cancel it once sent from the API of the application we are doing.
result = cluster.search_query(index_name,query, SearchOptions(limit=10_000_000, fields=fields))
for row in result:
.....
Python 3 SDK 3.1
Couchbase 6.6.0 Community
SO Ubuntu 20
sreeks
2
Hi @nelsonxx1 ,
We have some undocumented (experimental APIs in 6.6) to handle this situation.
Users can check for any long-running queries using the curl command.
curl -XGET -H "Content-Type: application/json" -u<user>:<password>
http://<node>:<ftsPort>/api/query
And cancel any such concerning query using the queryID returned in the response from the above curl.
curl -XPOST -H "Content-Type: application/json" -u<user>:<password>
http://<node>:<ftsPort>/api/query/<queryID>/cancel
These aren’t exposed over SDKs yet.
Cheers!
Gracias @sreeks for response.