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

RQG: Incorrect result for count query using a secondary index with MOI

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.0.0
    • 5.0.0
    • query, secondary-index
    • 4.7.0-1505 with MOI Indexes
    • Untriaged
    • Yes

    Description

      {noformat}

      This is a regression from 4.6 and it the mismatch in results for this query is seen only with MOI indexes.With gsi the test passes.

      Queries which give mismatch:

      sql_query :: SELECT COUNT( varchar_field1 ) FROM simple_table WHERE bool_field1 != false
      n1ql_query :: SELECT COUNT( varchar_field1 ) FROM simple_table_db_6839_simple_table WHERE bool_field1 != false

      How to run the test?
      ./testrunner.py -i local.ini -p gsi_type=memory_optimized -t rqg.test_rqg.RQGTests.test_rqg_concurrent_with_secondary,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_aggregate_functions.txt.zip,database=simple_table_db,reset_database=True,concurreny_count=5,index_quota_percent=30,password=password,use_mysql=True,replicas=0,run_query_with_secondary=True,run_explain_with_hints=True,total_queries=2000,record_failure=True,check_covering_index=True,failure_record_path=/tmp,
      skip_cleanup=False,ram_quota=8000,indexer_memQuota=5000

      Example ini file:
      [global]
      port:8091
      username:root
      password:couchbase
      index_port:9102
      index_path:/data/indexer

      [servers]
      1:SERVER_1

      [SERVER_1]
      ip:172.23.107.165
      index_port:9102
      port:8091
      services=n1ql,kv,index

      [membase]
      rest_username:Administrator
      rest_password:password

      Please do change the memory settings before you run the test using following steps:

      python27 scripts/install.py -i ${resource_tuq} -p vbuckets=${vbucket_number},version=${version_number},product=cb,parallel=True,init_nodes=False
      echo "Sleeping for 10 secs post installation...."
      sleep 10
      curl -X POST http://172.23.107.165:8091/pools/default -d memoryQuota=21000 -d indexMemoryQuota=5000
      curl http://172.23.107.165:8091/node/controller/setupServices -d "services=kv,n1ql,index"
      curl -X POST http://172.23.107.165:8091/settings/web -d port=8091 -d username=Administrator -d password=password
      sleep 10

      This test succeeded in 4.6

      Warning msg in UI and Logs after the test finished:
      Warning: approaching max index RAM. Indexer RAM on node "127.0.0.1" is 88%, which is at or above the threshold of 75%. (repeated 18 times)

      Total number of indexes created on the machine: 1014

      Memory usage of machine:
      [root@slv-s20301_c ~]# free -m

                   total       used       free     shared    buffers     cached

      Mem:         31981      11423      20557          0        264       1293

      -/+ buffers/cache:       9865      22115

      Swap:        10575         74      10501

      [root@slv-s20301_c ~]# df -k .

      Filesystem           1K-blocks    Used Available Use% Mounted on

      /dev/mapper/VolGroup00-lv_root

                            35146488 7722772  25631716  24% /

      {noformat}

      Attachments

        1. backup.tar
          3.02 MB
        2. logs.zip
          72.13 MB
        3. logs.zip
          61.82 MB
        4. queryexplain
          6 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty