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

FTS query got status code: 500

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Major
    • 7.6.0
    • 7.6.0
    • fts

    Description

       

      Build :- 7.6.0-1862
      

      1. Set bleveMaxResultWindow

      [2023-11-28 21:54:13,031] - [on_prem_rest_client:3892] INFO - {"bleveMaxResultWindow": "100000000"}
      [2023-11-28 21:54:13,031] - [on_prem_rest_client:1167] INFO - Making a rest request api=https://172.23.106.31:18094/api/managerOptions verb=PUT params={"bleveMaxResultWindow": "100000000"} client_cert=None verify=False
      [2023-11-28 21:54:13,088] - [on_prem_rest_client:3897] INFO - Updated bleveMaxResultWindow
      [2023-11-28 21:54:13,088] - [fts_base:4319] INFO - updating bleve_max_result_window of node : ip:172.23.106.4 port:8091 ssh_username:root
      [2023-11-28 21:54:13,146] - [on_prem_rest_client:3892] INFO - {"bleveMaxResultWindow": "100000000"}
      [2023-11-28 21:54:13,146] - [on_prem_rest_client:1167] INFO - Making a rest request api=https://172.23.106.4:18094/api/managerOptions verb=PUT params={"bleveMaxResultWindow": "100000000"} client_cert=None verify=False
      [2023-11-28 21:54:13,204] - [on_prem_rest_client:3897] INFO - Updated bleveMaxResultWindow 

      2. Run Queries

      3. Getting Unknown desc = TooManyClauses over field

      [2023-11-28 21:56:05,193] - [task:1799] INFO - ----------------------------------------------------- Query # 49 ----------------------------------------------------
      [2023-11-28 21:56:05,424] - [fts_base:2724] INFO - Running query {"indexName": "custom_index", "size": 10000000, "from": 0, "explain": false, "query": {"field": "manages.reports", "min": "Antonia", "max": "Kagami", "inclusive_min": false, "inclusive_max": false}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}} on node as 172.23.106.4 : Administrator:
      [2023-11-28 21:56:05,425] - [on_prem_rest_client:1167] INFO - Making a rest request api=https://172.23.106.4:18094/api/index/custom_index/query verb=POST params=b'{"indexName": "custom_index", "size": 10000000, "from": 0, "explain": false, "query": {"field": "manages.reports", "min": "Antonia", "max": "Kagami", "inclusive_min": false, "inclusive_max": false}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}}' client_cert=None verify=False
      [2023-11-28 21:56:05,463] - [task:1804] INFO - Status: {'total': 1, 'failed': 1, 'successful': 0, 'errors': {'custom_index_1d00a2d2fb39db42_4c1c5584': 'grpc_client: query got status code: 500, resp: &bleve.SearchResult{Status:(*bleve.SearchStatus)(0xc00773d080), Request:(*bleve.SearchRequest)(0xc00787a9c0), Hits:search.DocumentMatchCollection(nil), Total:0x0, Cost:0x0, MaxScore:0, Took:0, Facets:search.FacetResults(nil)}, err: rpc error: code = Unknown desc = TooManyClauses over field: `manages.reports` [1249 > maxClauseCount, which is set to 1024]'}}
      [2023-11-28 21:56:05,463] - [task:1825] INFO - FTS chose not to run this big query...skipping ES validation
      [2023-11-28 21:56:05,464] - [task:1841] INFO - FTS hits for query: {"field": "manages.reports", "min": "Antonia", "max": "Kagami", "inclusive_min": false, "inclusive_max": false} is 0 (took 0.0ms)
      [2023-11-28 21:56:05,464] - [es_base:517] INFO - ES query '{'query': {'filtered': {'filter': {'range': {'manages.reports': {'gt': 'Antonia', 'lt': 'Kagami'}}}}}}' 
      [2023-11-28 21:56:05,488] - [task:1860] INFO - ES hits for query: {"query": {"filtered": {"filter": {"range": {"manages.reports": {"gt": "Antonia", "lt": "Kagami"}}}}}} on es_index is 482 (took 5ms)
      [2023-11-28 21:56:05,488] - [task:1967] INFO - Skipping N1QL result validation since FTS results are - 0 and es results are - 482.

      Test Logs: http://qa.sc.couchbase.com/job/test_suite_executor/644559/consoleFull

      Attachments

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

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty