Query timeout option in Capella console

Couchbase Capella
1

I was running INSERT…SELECT queries in Capella console’s query window that exceeded default 10min timeout, so I increased the setting to max value of 30 min, but the change didn’t take affect: the queries kept being terminated after 10m.
Please advise.

2

Hi @AlexMc - It appears that there are other components between the Capella UI and the query engine that have a 10 minute limit.
I opened a ticket Jira (it’s not public, but if you want to inquire about it use this ticket id).

3

Note that the timeout issue applies only to the Capella UI. If you connect to your cluster using cbq or one of the SDKs, you should be able to have whatever timeout you need.

1 Like
6

Hi @eben ,
I am aware of this.
It was just a one-off thing, just moving some data from one scope/col to another.
But you are right, cbq seems to be the way to go.
Thanks for your reply.

7

Also explore other options