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