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

Unable to run n1fty queries: n1fty, error authenticating with cbauthAuthentication

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 7.6.0
    • 7.6.0
    • fts

    Description

      subcomponent: custom-map-n1ql-rqg-scorch-match-phrase_6.5_P1

      Server version: 7.6.0-1767

      Job Logs: 

      [2023-11-13 03:59:47,090] - [task:1799] INFO - ----------------------------------------------------- Query # 1 ----------------------------------------------------
      [2023-11-13 03:59:47,138] - [fts_base:2724] INFO - Running query {"indexName": "custom_index", "size": 10000000, "from": 0, "explain": false, "query": {"field": "email", "match_phrase": "amara@mcdiabetes.com"}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}} on node as 172.23.109.101 : Administrator:
      [2023-11-13 03:59:47,138] - [on_prem_rest_client:1167] INFO - Making a rest request api=http://172.23.109.101:8094/api/index/custom_index/query verb=POST params=b'{"indexName": "custom_index", "size": 10000000, "from": 0, "explain": false, "query": {"field": "email", "match_phrase": "amara@mcdiabetes.com"}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}}' client_cert=None verify=False
      [2023-11-13 03:59:47,150] - [task:1804] INFO - Status: {'total': 1, 'failed': 0, 'successful': 1, 'errors': {}}
      [2023-11-13 03:59:47,150] - [task:1841] INFO - FTS hits for query: {"field": "email", "match_phrase": "amara@mcdiabetes.com"} is 13 (took 0.295084ms)
      [2023-11-13 03:59:47,150] - [es_base:517] INFO - ES query '{'query': {'match_phrase': {'email': 'amara@mcdiabetes.com'}}}' 
      [2023-11-13 03:59:47,153] - [task:1860] INFO - ES hits for query: {"query": {"match_phrase": {"email": "amara@mcdiabetes.com"}}} on es_index is 13 (took 1ms)
      [2023-11-13 03:59:47,153] - [task:1873] INFO - SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
      [2023-11-13 03:59:47,153] - [task:1924] INFO - Running N1QL query: select meta().id from default where type='emp' and search(default, {"field": "email", "match_phrase": "amara@mcdiabetes.com"})
      [2023-11-13 03:59:47,189] - [on_prem_rest_client:4453] INFO - query params : statement=select+meta%28%29.id+from+default+where+type%3D%27emp%27+and+search%28default%2C+%7B%22field%22%3A+%22email%22%2C+%22match_phrase%22%3A+%22amara%40mcdiabetes.com%22%7D%29
      [2023-11-13 03:59:48,530] - [task:1960] INFO - N1QL query execution is failed.
      [2023-11-13 03:59:48,531] - [task:1961] ERROR - n1fty: gRPC client unavailable, try refreshing
      [2023-11-13 03:59:48,531] - [task:1924] INFO - Running N1QL query: select meta().id from default where type='emp' and search(default, {"field": "email", "match_phrase": "amara@mcdiabetes.com"},{"index": "custom_index"})
      [2023-11-13 03:59:48,590] - [on_prem_rest_client:4453] INFO - query params : statement=select+meta%28%29.id+from+default+where+type%3D%27emp%27+and+search%28default%2C+%7B%22field%22%3A+%22email%22%2C+%22match_phrase%22%3A+%22amara%40mcdiabetes.com%22%7D%2C%7B%22index%22%3A+%22custom_index%22%7D%29
      [2023-11-13 03:59:48,594] - [task:1960] INFO - N1QL query execution is failed.
      [2023-11-13 03:59:48,594] - [task:1961] ERROR - n1fty: response_handler: stream.Recv, err  - cause: rpc error: code = Unauthenticated desc = error authenticating with cbauthAuthentication failure
      [2023-11-13 03:59:48,594] - [task:1924] INFO - Running N1QL query: select meta().id,* from default where type='emp' and search(default, {"field": "email", "match_phrase": "amara@mcdiabetes.com"},{"index": "custom_index"})
      [2023-11-13 03:59:48,650] - [on_prem_rest_client:4453] INFO - query params : statement=select+meta%28%29.id%2C%2A+from+default+where+type%3D%27emp%27+and+search%28default%2C+%7B%22field%22%3A+%22email%22%2C+%22match_phrase%22%3A+%22amara%40mcdiabetes.com%22%7D%2C%7B%22index%22%3A+%22custom_index%22%7D%29
      [2023-11-13 03:59:48,657] - [task:1960] INFO - N1QL query execution is failed.
      [2023-11-13 03:59:48,657] - [task:1961] ERROR - n1fty: response_handler: stream.Recv, err  - cause: rpc error: code = Unauthenticated desc = error authenticating with cbauthAuthentication failure 

      Test Job link: http://qa.sc.couchbase.com/job/test_suite_executor/636588/consoleFull

      Attachments

        Issue Links

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

          Activity

            People

              sarthak.dua Sarthak Dua
              sarthak.dua Sarthak Dua
              Votes:
              0 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty