Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-37445

COUCHBASE_NUM_VBUCKETS should reject non factors of 1024

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • bug-backlog
    • 6.5.0
    • query
    • uname -a
      Linux couch01 4.19.0-6-amd64 #1 SMP Debian 4.19.67-2+deb10u1 (2019-09-20) x86_64 GNU/Linux
    • Untriaged
    • Unknown

    Description

      First I understand that vBuckets != 1024 is not supported (but we do have 64 vBuckets for macOS).

      When exploring Eventing performance characteristics on a non-MDS one node server ( e.g. why is it slow on a single Linux node) at various vBuckets settings 1024, 512, 256, 128 and 64 - these all worked.

       

      SELECT count cnt, type from `travel-sample` group by type

      1968 airport
      917 hotel
      4495 landmark
      24024 route
      187 airline 

      I then tried 340 (which is not a factor of 1024) to emulate a 3 node KV system my eventing test worked as expected BUT N1QL queries did not.   

      1024/340 = 3.0117

      We get wrong answers via N1QL if COUCHBASE_NUM_VBUCKETS is set to a non factor of 1024:

      export COUCHBASE_NUM_VBUCKETS=340

      install couchbase and setup then load `travel-sample` run these two queries

      SELECT count cnt from `travel-sample`

      cnt
      31591

       

      SELECT count cnt, type from `travel-sample` group by type

      4 airline
      18 airport
      8 hotel
      56 landmark
      312 route
       

      SELECT count cnt from `travel-sample` where type = 'hotel'  

      cnt
      917
       

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            kamini.jagtiani Kamini Jagtiani
            jon.strabala Jon Strabala
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty