Uploaded image for project: 'Couchbase Java Client'
  1. Couchbase Java Client
  2. JCBC-1007

N1QL Queries not Load Balancing between Query Nodes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 2.3.4
    • 2.3.0
    • N1QL
    • None
    • Couchbase Server 4.5.0

    Description

      Problem

      I am seeing N1QL queries not load balancing between available query nodes. This causes excessive CPU on the heavy hit node.

      Description

      Using a 4 node 4.5.0 vagrant cluster, 2 nodes are Data only, and 2 nodes (103 and 104) are Query/Index nodes. When issuing a simple N1QL query in a loop, one node receives more than twice the query load. Sample code and screenshot attached.

      I used the beer-sample bucket, and deleted the primary index. I created a covering index:

      create index name_idx on `beer-sample`(name);

      ASK

      Please determine why the query requests are not more evenly distributed

      Attachments

        1. App.java
          2 kB
        2. Couchbase-Java-Client-2.3.4-distrib-vf1.zip
          15.81 MB
        3. Couchbase-Java-Client-2.3.4-SNAPSHOT-distrib-vf2.zip
          15.27 MB
        4. Example.java
          2 kB
        5. fine_error_log_query_load_balancing.log
          188 kB
        6. LoadBalanceTestSDK2.2.3.jar
          5.88 MB
        7. LoadBalanceTestSDK2.2.4.jar
          6.00 MB
        8. LoadBalanceTestSDK2.3.3.jar
          6.56 MB
        9. QueryTest.png
          QueryTest.png
          112 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            subhashni Subhashni Balakrishnan (Inactive)
            jdillon Jeff Dillon (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty