Cancel running N1QL query

SQL++
1

Hello.
I wanted to know if there is a way to cancel a running query in N1QL.

Thanks

2

You can simply disconnect on HTTP/REST call to cancel the query.

3

You can cancel the N1QL query by calling lcb_n1ql_cancel - refer here.

4

You can just delete from system:active_request where requestId = “…” (the actual request id, which you can get from selecting from system/active_requests or from the /admin/active_requests REST API endpoint)