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

N1ql functional test test_prepared_buckets failure:msg': 'Authorization Failed Keyspace keyspaces', 'code': 10000

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.0.0
    • 5.0.0
    • query
    • 4.7.0-1468, This is a regression from 4.6
    • Untriaged
    • Yes

    Description

      Test which fails:
      tuqquery.tuq_system.SysCatalogTests.test_prepared_buckets
       
      How to run the test?
      This test is run on a 4 node cluster,each having kv,index and n1ql on it.
      Its part of the following test suite:
      conf/tuq/py-n1ql-prepared.conf 
       
      python testrunner.py -i local.ini -c conf/tuq/py-n1ql-prepared.conf -p gsi_type=forestdb,primary_indx_type=GSI,nodes_init=4,doc-per-day=1,get-cbcollect-info=True
       
      Example local.ini:
      [global]
      port:8091
      username:root
      password:couchbase
       
      [servers]
      1:vm1
      2:vm2
      3:vm3
      4:vm4
       
      [vm1]
      ip:172.23.106.234
      services:kv,index,n1ql
       
      [vm2]
      ip:172.23.107.105
      services:kv,index,n1ql
      	
      [vm3]
      ip:172.23.106.170
      services:kv,index,n1ql
       
      [vm4]
      ip:172.23.106.70
      services:kv,index,n1ql
       
      [membase]
      rest_username:Administrator
      rest_password:password
      [tuq_client]
      goroot:/root/n1ql/go
      gopath:/root/n1ql/gocode
       
      Error reported:
      ======================================================================
      ERROR: test_prepared_buckets (tuqquery.tuq_system.SysCatalogTests)
      ----------------------------------------------------------------------
      Traceback (most recent call last):
        File "pytests/tuqquery/tuq_system.py", line 72, in test_prepared_buckets
          self.prepared_common_body()
        File "pytests/tuqquery/tuq.py", line 3972, in prepared_common_body
          result_with_prepare = self.run_cbq_query(query=prepared, is_prepared=True, encoded_plan=encoded_plan)['results']
        File "pytests/tuqquery/tuq.py", line 4055, in run_cbq_query
          raise CBQError(result, server.ip)
      CBQError: CBQError: host 172.23.106.234: ERROR:{'status': 'stopped', 'errors': [{'msg': 'Authorization Failed Keyspace keyspaces', 'code': 10000}], 'results': [], 'metrics': {'elapsedTime': '2.583331ms', 'executionTime': '2.530126ms', 'resultSize': 0, 'resultCount': 0, 'errorCount': 1}, 'requestID': '433ab61e-3481-4fc3-9bef-22ca8f9f0a65', 'signature': '{"*":"*"}'}
       
       
      Log from jenkins console:
       
      ./testrunner -i /tmp/n1ql_set4.ini gsi_type=memory_optimized,primary_indx_type=GSI,nodes_init=4,doc-per-day=1,get-cbcollect-info=True -t tuqquery.tuq_system.SysCatalogTests.test_prepared_buckets,named_prepare=catalog_prepare,encoded_prepare=True
       
      Test Input params:
      {'encoded_prepare': 'True', 'doc-per-day': '1', 'logs_folder': '/data/workspace/cen006-p0-n1ql-vset03-09-prepared_gsi/logs/testrunner-16-Dec-16_10-08-52/test_21', 'gsi_type': 'memory_optimized', 'primary_indx_type': 'GSI', 'conf_file': 'conf/tuq/py-encoded-prepare.conf', 'num_nodes': 4, 'cluster_name': 'n1ql_set4', 'named_prepare': 'catalog_prepare', 'ini': '/tmp/n1ql_set4.ini', 'case_number': 21, 'get-cbcollect-info': 'True', 'spec': 'py-encoded-prepare', 'nodes_init': '4'}
      [2016-12-16 10:15:24,058] - [rest_client:1754] INFO - Node version in cluster 4.7.0-1468-enterprise
      [2016-12-16 10:15:24,078] - [rest_client:1763] INFO - Node versions in cluster [u'4.7.0-1468-enterprise', u'4.7.0-1468-enterprise', u'4.7.0-1468-enterprise', u'4.7.0-1468-enterprise']
      [2016-12-16 10:15:24,078] - [basetestcase:160] INFO - ==============  basetestcase setup was started for test #21 test_prepared_buckets==============
      [2016-12-16 10:15:24,078] - [basetestcase:168] INFO - any cluster operation in setup will be skipped
      [2016-12-16 10:15:24,079] - [basetestcase:171] INFO - ==============  basetestcase setup was finished for test #21 test_prepared_buckets ==============
      [2016-12-16 10:15:24,081] - [remote_util:168] INFO - connecting to 172.23.106.234 with username : root password : couchbase ssh_key: 
      [2016-12-16 10:15:24,249] - [remote_util:202] INFO - Connected to 172.23.106.234
      [2016-12-16 10:15:24,392] - [remote_util:168] INFO - connecting to 172.23.106.234 with username : root password : couchbase ssh_key: 
      [2016-12-16 10:15:24,560] - [remote_util:202] INFO - Connected to 172.23.106.234
      [2016-12-16 10:15:26,058] - [tuq:104] INFO - ----------------------------------------------------------------------------------------------------
      [2016-12-16 10:15:26,059] - [tuq:105] INFO - Temp fix for MB-16888
      [2016-12-16 10:15:26,608] - [remote_util:2379] INFO - running command.raw on 172.23.106.234: killall -9 cbq-engine
      [2016-12-16 10:15:26,706] - [remote_util:2416] INFO - command executed successfully
      [2016-12-16 10:15:26,707] - [remote_util:2379] INFO - running command.raw on 172.23.106.234: killall -9 indexer
      [2016-12-16 10:15:26,806] - [remote_util:2416] INFO - command executed successfully
      [2016-12-16 10:15:26,807] - [basetestcase:382] INFO - sleep for 10 secs. wait for indexer ...
      [2016-12-16 10:15:36,810] - [tuq:111] INFO - ----------------------------------------------------------------------------------------------------
      [2016-12-16 10:15:36,810] - [tuq:3987] INFO - ----------------------------------------------------------------------------------------------------
      [2016-12-16 10:15:36,820] - [rest_client:2758] INFO - query params : scan_consistency=REQUEST_PLUS&creds=%5B%5D&statement=SELECT+%2A+FROM+system%3Akeyspaces
      [2016-12-16 10:15:37,015] - [tuq:4057] INFO - TOTAL ELAPSED TIME: 190.199232ms
      [2016-12-16 10:15:37,015] - [tuq:3987] INFO - ----------------------------------------------------------------------------------------------------
      [2016-12-16 10:15:37,023] - [rest_client:2758] INFO - query params : scan_consistency=REQUEST_PLUS&creds=%5B%5D&statement=PREPARE+catalog_prepare_edfd+from+SELECT+%2A+FROM+system%3Akeyspaces
      [2016-12-16 10:15:37,036] - [tuq:4057] INFO - TOTAL ELAPSED TIME: 8.590038ms
      [2016-12-16 10:15:37,036] - [tuq:3987] INFO - ----------------------------------------------------------------------------------------------------
      ERROR
       
       
      Uploading logs
      

      Attachments

        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:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty