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{ b…

According to the log there: “total_us”:121525575 … your timeout is set to 120s and it’s taking slightly longer than that for the query service to send the response. So, the problem isn’t with the SDK, it’s the query and the amount of data. Question: why are you doing a ‘select *’ here? Often th…

Thank you for response. I have increased timeout and also commented the select * query and I am trying to create index on Student bucket for executing N1QL queries. I am getting same exception while creating index through SDK or directly execute query on Couchbase console. Through SDK, I am executi…

Ah, looks like your primary problem is something with creating the index. What I’d probably recommend is looking at the logs associated with secondary indexing (projector/indexer). You may be able to discern there why it’s crashing. Perhaps @tai_tran or @jeelan.poola have other thoughts and can p…

Thanks @vsr1 ! Just to short circuit others to the answer, there’s suspicion that it could be known issue MB-25086 , fixed in 5.5 and with workarounds if corrupt.

Thanks @ingenthr I am able to create index after reinstallation.

java.util.concurrent.TimeoutException while executing N1ql queries

Java SDK

vsr1 July 30, 2018, 5:49pm 5

Check this post for index creation issue. Unable to create index in couchbase

1 Like

Topic		Replies	Views
N1QL is failing with Timeout Exception Java SDK n1ql	12	3485	July 12, 2019
N1QL queries throw TimeoutException after the application runs for some days Java SDK query , n1ql	3	2258	January 10, 2018
Java Client 2.3.1 : N1QL queries throwing TimeoutException [upgraded to Couchbase 4.5] Java SDK query , java , n1ql	31	7449	November 22, 2017
N1QL queries timing out when run in java sdk Java SDK	38	9844	July 21, 2016
java.util.concurrent.TimeoutException during N1QL query run from Java SDK Java SDK n1ql	3	3327	November 7, 2019

java.util.concurrent.TimeoutException while executing N1ql queries

Related topics