I can see following lines in spring microservice logs every now and then and mostly whenever I hit my FTS query where 220.127.116.11 is my search node:
2018-01-31 10:42:04.791 INFO 18684 — [ cb-io-1-2] com.couchbase.client.core.node.Node : Disconnected from Node 18.104.22.168/ec2-54-218-6-25.us-west-2.compute.amazonaws.com
2018-01-31 10:42:04.860 INFO 18684 — [ cb-io-1-4] com.couchbase.client.core.node.Node : Connected to Node 22.214.171.124/ec2-54-218-6-25.us-west-2.compute.amazonaws.com
I have four node cluster and whenever I remove search node from cluster cluster loooks to be stable as rebalance button gone disable while when I add it it keeps enable and keepds enable even after clicking on it. From command line re -balance shows 100% completed every time. Kindly suggest me some steps to trouble shoot this issue please. Please let me know for further information.
Hi, Not very sure of the exact problem you face at the moment.
-Is your search node responding to search requests after adding it through the rebalance?
-Is the node disconnection affecting your search ? Don’t know the SDK /Client side of this.
But there is a chance that, either side closing the connection after any keep alive/idle time out?
Thanks for the update!
Currently I am running search on 1 million records and working fine functionally.
But I want to make sure time in FTS quries which includes, exact match, wildcard and fuzzy should not be affected by this issue. Let me show you time taken:
Exact or Default Search: within 1 second
Fuzzy Search: within 2 second
Wildcard Search: within 12 second
Blank Search (Match all): within 12 second
The impact from a new connection establishment may/may not be significant depending on the use cases or the current requirements. But certainly it has a cost too.
Regarding your figures, these again depends on many factors like the system h/w configurations /current load/nature of json data/query types/other storage level advanced configuration etc. Meaning, from such figures we can’t right way classify this as a good/bad performance… But keep monitoring the stats page graphs of the respective index with respect to variations in performance of the above queries - will give you some hints to what all happening at the back ground…and one can track/adjust configs further from these figures.
@divya.garg121 actually I was referring to the debug logs of your application, not the couchbase server. I wanted to get insight into how the SDK is operating, which is sent to your app logger. sorry for the confusion!
Yeah so for some reason the sockets to 8094 get disconnected and then SDK reestablishes it again quickly.
Couple of questions:
do you have any failing requests or other service impact from this behavior?
How do you configure the CouchbaseCluster/CouchbaseEnvironment (especially around the pool config for search)
If you keep the defaults, it might be worth a try by setting for example .searchEndpoints(4) (ignore the deprecation warning for now) on the DefaultCouchbaseEnvironment.Builder and then pass the env into CouchbaseCluster and see if it makes a difference. Like this:
Thanks for the feedback daschl.
I have not seen failing request till now and am also not making high no of request till now. But I have seen similar disconnect and connect logs in warning mode for other nodes too.
I am using Spring boot way to creating bucket bean and using SearchQuery. These are the entries on my spring application.properties:
yes I am using defaults. This is all provided by spring on timeouts:
spring.couchbase.env.endpoints.key-value=1 # Number of sockets per node against the Key/value service.
spring.couchbase.env.endpoints.query=1 # Number of sockets per node against the Query (N1QL) service.
spring.couchbase.env.endpoints.view=1 # Number of sockets per node against the view service.
spring.couchbase.env.ssl.enabled= # Enable SSL support. Enabled automatically if a “keyStore” is provided unless specified otherwise.
spring.couchbase.env.ssl.key-store= # Path to the JVM key store that holds the certificates.
spring.couchbase.env.ssl.key-store-password= # Password used to access the key store.
spring.couchbase.env.timeouts.connect=5000 # Bucket connections timeout in milliseconds.
spring.couchbase.env.timeouts.key-value=2500 # Blocking operations performed on a specific key timeout in milliseconds.
spring.couchbase.env.timeouts.query=7500 # N1QL query operations timeout in milliseconds.
spring.couchbase.env.timeouts.socket-connect=1000 # Socket connect connections timeout in milliseconds.
spring.couchbase.env.timeouts.view=7500 # Regular and geospatial view operations timeout in milliseconds.
As per the link I shared earlier, Socket Keepalive Interval default is 30000ms > 20 sec at which you see the connection break.
Why don’t you configure Socket Keepalive Interval to something less than <20sec… lets say 10 or 5 secs…