Getting Timeout exception while executing N1qL queries. With Niql queries, the application runs fine. I am using Couchbase Server 5.1 and SDK as 2.6.0.
Below is my code to execute n1ql query:
bucket = cluster.openBucket(bucketName);
System.out.println(“Inside get document by Id Method”);
try{
bucket.bucketManager().createN1qlPrimaryIndex(true, false, 120000, TimeUnit.MILLISECONDS);
N1qlQueryResult result = bucket.query(N1qlQuery.simple(“select * from Student”));
for (N1qlQueryRow row : result) {
System.out.println("************Result is : " + row);
}
} catch (Exception e) {
System.out.println(“Exception occured”);
bucket.close();
}
Exception received:
2018-07-27 15:48:38.275 ERROR 5208 — [nio-8080-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.RuntimeException: java.util.concurrent.TimeoutException: {“b”:“Student”,“r”:“127.0.0.1:8093”,“s”:“n1ql”,“c”:“45B71F527285AD82/FFFFFFFFC517C66B”,“t”:75000000,“l”:“127.0.0.1:61270”}] with root cause
java.util.concurrent.TimeoutException: {“b”:“Student”,“r”:“127.0.0.1:8093”,“s”:“n1ql”,“c”:“45B71F527285AD82/FFFFFFFFC517C66B”,“t”:75000000,“l”:“127.0.0.1:61270”}
at com.couchbase.client.java.bucket.api.Utils$1.call(Utils.java:131) ~[java-client-2.6.0.jar:na]
at com.couchbase.client.java.bucket.api.Utils$1.call(Utils.java:127) ~[java-client-2.6.0.jar:na]
at rx.internal.operators.OperatorOnErrorResumeNextViaFunction$4.onError(OperatorOnErrorResumeNextViaFunction.java:140) ~[rxjava-1.3.7.jar:1.3.7]
at rx.internal.operators.OnSubscribeTimeoutTimedWithFallback$TimeoutMainSubscriber.onTimeout(OnSubscribeTimeoutTimedWithFallback.java:166) ~[rxjava-1.3.7.jar:1.3.7]
at rx.internal.operators.OnSubscribeTimeoutTimedWithFallback$TimeoutMainSubscriber$TimeoutTask.call(OnSubscribeTimeoutTimedWithFallback.java:191) ~[rxjava-1.3.7.jar:1.3.7]
at rx.internal.schedulers.ScheduledAction.run(ScheduledAction.java:55) ~[rxjava-1.3.7.jar:1.3.7]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:1.8.0_121]
at java.util.concurrent.FutureTask.run(Unknown Source) ~[na:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) ~[na:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) ~[na:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[na:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:1.8.0_121]
at java.lang.Thread.run(Unknown Source) [na:1.8.0_121]
2018-07-27 15:48:55.778 WARN 5208 — [tionScheduler-4] c.c.c.c.endpoint.AbstractGenericHandler : [/127.0.0.1:8093][QueryEndpoint]: Got error while consuming KeepAliveResponse.
java.util.concurrent.TimeoutException: null
at rx.internal.operators.OnSubscribeTimeoutTimedWithFallback$TimeoutMainSubscriber.onTimeout(OnSubscribeTimeoutTimedWithFallback.java:166) [rxjava-1.3.7.jar:1.3.7]
at rx.internal.operators.OnSubscribeTimeoutTimedWithFallback$TimeoutMainSubscriber$TimeoutTask.call(OnSubscribeTimeoutTimedWithFallback.java:191) [rxjava-1.3.7.jar:1.3.7]
at rx.internal.schedulers.EventLoopsScheduler$EventLoopWorker$2.call(EventLoopsScheduler.java:189) [rxjava-1.3.7.jar:1.3.7]
at rx.internal.schedulers.ScheduledAction.run(ScheduledAction.java:55) [rxjava-1.3.7.jar:1.3.7]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.8.0_121]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) [na:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [na:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_121]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_121]
at java.lang.Thread.run(Unknown Source) [na:1.8.0_121]
2018-07-27 15:49:32.710 WARN 5208 — [ cb-tracing-1] c.c.c.core.tracing.ThresholdLogReporter : Operations over threshold: [{“top”:[{“operation_name”:“n1ql”,“last_local_id”:“45B71F527285AD82/FFFFFFFFC517C66B”,“last_local_address”:“127.0.0.1:61270”,“last_remote_address”:“127.0.0.1:8093”,“last_dispatch_us”:121520204,“total_us”:121525575}],“service”:“n1ql”,“count”:1}]
2018-07-27 15:49:32.710 WARN 5208 — [ cb-orphan-1] c.c.c.c.t.DefaultOrphanResponseReporter : Orphan responses observed: [{“top”:[{“b”:“Student”,“r”:“127.0.0.1:8093”,“s”:“n1ql”,“c”:“45B71F527285AD82/FFFFFFFFC517C66B”,“l”:“127.0.0.1:61270”},{“r”:“127.0.0.1:8093”,“s”:“n1ql”,“c”:“45B71F527285AD82/FFFFFFFFC517C66B”,“l”:“127.0.0.1:61270”}],“service”:“n1ql”,“count”:2}]