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

Serverless: authorization error 13014 vs 12037

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • Elixir
    • Elixir
    • query
    • 7.1.5-4416
    • Untriaged
    • 0
    • Unknown

    Description

      Getting different error code for unauthorized access:

      membase.api.exception.CBQError: CBQError: host i-0907328f853e129cb.sdk.sandbox.nonprod-project-avengers.com: ERROR:{'requestID': '9c7c2bc5-0c5e-49e2-923a-e754c09dd54b', 'signature': {'*': '*'}, 'results': [], 'errors': [{'code': 13014, 'msg': 'User does not have credentials to run SELECT queries on default:testrunner-0b4c4248-625e-4075-a845-8b6fecc4d2d3-tlwllk._default._default. Add role query_select on default:testrunner-0b4c4248-625e-4075-a845-8b6fecc4d2d3-tlwllk._default._default to allow the query to run.', 'reason': {'path': 'default:testrunner-0b4c4248-625e-4075-a845-8b6fecc4d2d3-tlwllk._default._default'}}], 'status': 'fatal', 'metrics': {'elapsedTime': '34.6575ms', 'executionTime': '1.844719ms', 'resultCount': 0, 'resultSize': 0, 'serviceLoad': 2, 'errorCount': 1}, 'profile': {'phaseTimes': {'authorize': '1.326346ms', 'instantiate': '19.331µs', 'parse': '293.012µs', 'plan': '155.397µs', 'plan.index.metadata': '14.671µs', 'plan.keyspace.metadata': '5.645µs', 'run': '1.363909ms'}, 'phaseOperators': {'authorize': 1}, 'cpuTime': '288ns', 'requestTime': '2023-05-30T15:05:43.149Z', 'servicingHost': '23e9d5029ee35d3d0a68bdc1ea737eeb', 'executionTimings': {'#operator': 'Authorize', '#planPreparedTime': '2023-05-30T15:05:43.182Z', '#stats': {'#phaseSwitches': 2, 'execTime': '288ns', 'servTime': '1.326058ms'}, 'privileges': {'List': [{'Target': 'default:testrunner-0b4c4248-625e-4075-a845-8b6fecc4d2d3-tlwllk._default._default', 'Priv': 7, 'Props': 0}]}, '~child': {'#operator': 'Sequence', '~children': [{'#operator': 'PrimaryScan3', 'bucket': 'testrunner-0b4c4248-625e-4075-a845-8b6fecc4d2d3-tlwllk', 'index': '#sequentialscan', 'index_projection': {'primary_key': True}, 'keyspace': '_default', 'limit': '1', 'namespace': 'default', 'scope': '_default', 'using': 'sequentialscan'}, {'#operator': 'Fetch', 'bucket': 'testrunner-0b4c4248-625e-4075-a845-8b6fecc4d2d3-tlwllk', 'keyspace': '_default', 'namespace': 'default', 'scope': '_default'}, {'#operator': 'InitialProject', 'discard_original': True, 'preserve_order': True, 'result_terms': [{'expr': 'self', 'star': True}]}, {'#operator': 'Limit', 'expr': '1'}, {'#operator': 'Stream', 'serializable': True}]}, '~versions': ['7.5.0-N1QL', '7.5.0-4416-enterprise']}}, 'controls': {'scan_consistency': 'unbounded', 'queryContext': 'default:testrunner-61548150-cf8c-4caf-831a-b76a186fac6d-20zpf2', 'use_cbo': 'true', 'n1ql_feat_ctrl': '0x4c', 'disabledFeatures': ['(Reserved for future use) (0x40)', 'Golang UDFs (0x8)', 'Encoded Plans (0x4)'], 'stmtType': 'SELECT'}}
       

      Attachments

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

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            pierre.regazzoni Pierre Regazzoni
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty