com.couchbase.client.core.error.AmbiguousTimeoutException

Couchbase Java SDK: 3.3.3

When running the queries which take less than 100 ms on console, when the same query is executed through Java SDK, it sometimes gets stuck and throws this exception

10:26:48.117 [cb-timer-1-1] ERROR c.a.p.p.couchbase.CouchbaseRead - queryPrimaryByN1ql: Query: select identifier from pace_development where key_tx like "CONF::%::V1"  and name="issuance-delivery-tier"  and arrangement_orgLogoPCT="HKE"  and available_to="AUTHORIZED-USER"  and experience_orgLogoPCT="HKE"  and arrangement_id="9C6F0F01-A239-488D-BB5D-965BEFC4DC0F"  and feature_name="payment-device"  AND (offer_driven is missing or offer_driven is null or offer_driven=false) 
com.couchbase.client.core.error.AmbiguousTimeoutException: QueryRequest, Reason: TIMEOUT {"cancelled":true,"completed":true,"coreId":"0x73c2fd8d00000002","idempotent":false,"lastDispatchedFrom":"10.2.118.28:47798","lastDispatchedTo":"server1.phx.test.com:8093","reason":"TIMEOUT","requestId":8738,"requestType":"QueryRequest","retried":0,"service":{"operationId":"10cd01c8-f911-4de7-ad80-9dab3e393ec9","statement":"statement with space","type":"query"},"timeoutMs":75000}
	at com.couchbase.client.core.msg.BaseRequest.cancel(BaseRequest.java:184)
	at com.couchbase.client.core.msg.Request.cancel(Request.java:70)
	at com.couchbase.client.core.Timer.lambda$register$2(Timer.java:157)
	at com.couchbase.client.core.deps.io.netty.util.HashedWheelTimer$HashedWheelTimeout.run(HashedWheelTimer.java:715)
	at com.couchbase.client.core.deps.io.netty.util.concurrent.ImmediateExecutor.execute(ImmediateExecutor.java:34)
	at com.couchbase.client.core.deps.io.netty.util.HashedWheelTimer$HashedWheelTimeout.expire(HashedWheelTimer.java:703)
	at com.couchbase.client.core.deps.io.netty.util.HashedWheelTimer$HashedWheelBucket.expireTimeouts(HashedWheelTimer.java:790)
	at com.couchbase.client.core.deps.io.netty.util.HashedWheelTimer$Worker.run(HashedWheelTimer.java:503)
	at com.couchbase.client.core.deps.io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.lang.Thread.run(Thread.java:750)

Ensure that your SDK queries are running against the same CB server as the web console queries
Use the Index Advisor tab on the web console Query page for advice on indexing.