Hi All,
I am getting couchbase Select N1QL query time out. I am using couchbase java client library 2.7.3. and getting below error.
java.util.concurrent.TimeoutException: {“b”:“swipe”,“r”:“xx.xx.xx.xx:8093”,“s”:“n1ql”,“c”:“56A556C4A2265275/FFFFFFFF9E685D2B”,“t”:7500000,“i”:“66d10b93-299c-444d-89b7-d973c91681c1”,“l”:“xx.xx.xx.xx:58164”}
at com.couchbase.client.java.bucket.api.Utils$1.call(Utils.java:131) ~[java-client-2.7.3.jar!/:na]
at com.couchbase.client.java.bucket.api.Utils$1.call(Utils.java:127) ~[java-client-2.7.3.jar!/:na]
at rx.internal.operators.OperatorOnErrorResumeNextViaFunction$4.onError(OperatorOnErrorResumeNextViaFunction.java:140) ~[rxjava-1.3.8.jar!/:1.3.8]
at rx.internal.operators.OnSubscribeTimeoutTimedWithFallback$TimeoutMainSubscriber.onTimeout(OnSubscribeTimeoutTimedWithFallback.java:166) ~[rxjava-1.3.8.jar!/:1.3.8]
I have index created on the filter parameter and the java client configuration parameter used is mention below.
-Dcom.couchbase.computationPoolSize=5 -Dcom.couchbase.mutationTokensEnabled=true -Dcom.couchbase.kvServiceEndpoints=2 -Dcom.couchbase.autoreleaseAfter=15000 -Dcom.couchbase.socketConnectTimeout=60000
My query is how to improve the SELECT N1QL performance, so that SELECT query doesn’t have timeout issue (if invoked 10 times continuously).
Regards,