Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-15154 Query engine Memory growth with large number concurrent clients/queries.
  3. MB-15408

Cannot create index on bucket with saslAuth=True and with saslPassword

    XMLWordPrintable

Details

    • Technical task
    • Resolution: Fixed
    • Major
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • None
    • version=4.0.0-3232

    Description

      1. Install CB Server on 6 Server
      2. Create a cluster in following:
      a) 107 - n1ql
      b) 108 - kv
      c) 110 - kv
      d) 111 - index
      3. Create a bucket with authType=sasl and saslPassword=password
      http://172.23.106.107:8091/pools/default/buckets with param: bucketType=membase&evictionPolicy=valueOnly&threadsNumber=3&ramQuotaMB=677&proxyPort=11211&authType=sasl&name=bucket0&flushEnabled=1&replicaNumber=1&replicaIndex=1&saslPassword=password
      4. Try and create a primary index -
      CREATE+PRIMARY+INDEX+ON+bucket0++USING+GSI

      • Authentication Error

        "2015-06-21 23:04:35 | ERROR | MainProcess | test_thread | [tuq_helper.create_primary_index]
        ERROR during index creation CBQError: host 172.23.106.107: ERROR:{u'status': u'stopped', u'errors': [{u'msg': u'Authorization Failed Keyspace bucket0', u'code': 10000}], u'results': [], u'metrics': {u'elapsedTime': u'6.227579ms', u'executionTime': u'6.059373ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'0aa3806b-6496-4b37-a523-43f87d4b5233', u'signature': None}"
        

        5. Create secondary index -
        CREATE INDEX employee5d986f69010b4ab88a051dc199f414f7job_title ON bucket0(job_title) USING GSI WITH

        {'nodes': ['172.23.106.111:8091']}

        Authentication error with bucket:

        2015-06-21 23:04:59 | ERROR | MainProcess | Cluster_Thread | [task.execute] CBQError: host 172.23.106.107: ERROR:{u'status': u'stopped', u'errors': [{u'msg': u'Authorization Failed Keyspace bucket0', u'code': 10000}], u'results': [], u'metrics': {u'elapsedTime': u'12.493055ms', u'executionTime': u'12.325664ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'f610a59e-b401-42b2-a180-a62b656c5569', u'signature': None}
        

      TC:
      ./testrunner -i /tmp/tuqvm.ini -t 2i.indexscans_2i.SecondaryIndexingScanTests.test_multi_create_query_explain_drop_index,groups=simple:equals:no_orderby_groupby:range,dataset=default,use_gsi_for_primary=True,use_gsi_for_secondary=True,standard_buckets=1,sasl_buckets=1,doc-per-day=50,nodes_init=4,verify_using_index_status=True,get-cbcollect-info=True,get-logs=True,get-coredumps=True

      Attachments

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

        Activity

          People

            colm Colm Mchugh (Inactive)
            ritam.sharma Ritam Sharma
            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