In one cluster, we are seeing repeatedly the prepare statements in completed_requests, when checked with app team they are running just select queries, but in couchbase it is coming with ‘prepare’ appended to it.
Auto-prepare is set to false at couchbase level.
Any idea on this why all statements are being prepared?
SDK’s always uses prepared statement unless adhoc=true set.
That’s true but AFAIK adhoc=true is the default in all SDKs apart from Go. It’s certainly the default in the JVM SDKs that I’m most familiar with.
@pruthvi what SDK are you using?
Java SDK 3.1 is being used