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
          Jeff Dillon
        2. Example.java
          2 kB
          Jack Harper
        3. fine_error_log_query_load_balancing.log
          188 kB
          Jack Harper
        4. QueryTest.png
          112 kB
          Jeff Dillon
        For Gerrit Dashboard: JCBC-1007
        # Subject Branch Project Status CR V

        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