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

Unable to run n1fty queries with custom index - gRPC client unavailable

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • 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


       

      Unable to run FTS queries via n1ql when index on which it should run is also specified:

      [2023-11-13 03:09:16,221] - [task:1799] INFO - ----------------------------------------------------- Query # 3 ----------------------------------------------------
      [2023-11-13 03:09:16,345] - [fts_base:2724] INFO - Running query {"indexName": "custom_index", "size": 10000000, "from": 0, "explain": false, "query": {"field": "name", "match_phrase": "Sirena Thomas"}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}} on node as 172.23.122.131 : Administrator:
      [2023-11-13 03:09:16,345] - [on_prem_rest_client:1167] INFO - Making a rest request api=http://172.23.122.131:8094/api/index/custom_index/query verb=POST params=b'{"indexName": "custom_index", "size": 10000000, "from": 0, "explain": false, "query": {"field": "name", "match_phrase": "Sirena Thomas"}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}}' client_cert=None verify=False
      [2023-11-13 03:09:16,349] - [task:1804] INFO - Status: {'total': 1, 'failed': 0, 'successful': 1}
      [2023-11-13 03:09:16,349] - [task:1841] INFO - FTS hits for query: {"field": "name", "match_phrase": "Sirena Thomas"} is 1 (took 0.158183ms)
      [2023-11-13 03:09:16,349] - [es_base:517] INFO - ES query '{'query': {'match_phrase': {'name': 'Sirena Thomas'}}}' 
      [2023-11-13 03:09:16,352] - [task:1860] INFO - ES hits for query: {"query": {"match_phrase": {"name": "Sirena Thomas"}}} on es_index is 1 (took 1ms)
      [2023-11-13 03:09:16,352] - [task:1873] INFO - SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
      [2023-11-13 03:09:16,352] - [task:1924] INFO - Running N1QL query: select meta().id from default where type='emp' and search(default, {"field": "name", "match_phrase": "Sirena Thomas"})
      [2023-11-13 03:09:16,406] - [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+%22name%22%2C+%22match_phrase%22%3A+%22Sirena+Thomas%22%7D%29
      [2023-11-13 03:09:16,410] - [task:1936] INFO - N1QL hits for query: "select meta().id from default where type='emp' and search(default, {\"field\": \"name\", \"match_phrase\": \"Sirena Thomas\"})" is 1 (took 2.165794ms)
      [2023-11-13 03:09:16,410] - [task:1945] INFO - SUCCESS: Docs returned by FTS = docs returned by N1QL, doc_ids verified
      [2023-11-13 03:09:16,410] - [task:1924] INFO - Running N1QL query: select meta().id from default where type='emp' and search(default, {"field": "name", "match_phrase": "Sirena Thomas"},{"index": "custom_index"})
      [2023-11-13 03:09:16,459] - [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+%22name%22%2C+%22match_phrase%22%3A+%22Sirena+Thomas%22%7D%2C%7B%22index%22%3A+%22custom_index%22%7D%29
      [2023-11-13 03:09:16,462] - [task:1960] INFO - N1QL query execution is failed.
      [2023-11-13 03:09:16,462] - [task:1961] ERROR - n1fty: gRPC client unavailable, try refreshing

       

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

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty