Details
-
Bug
-
Resolution: Fixed
-
Test Blocker
-
7.6.0
-
Untriaged
-
0
-
Yes
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
- relates to
-
MB-59653 Unable to run n1fty queries: n1fty, error authenticating with cbauthAuthentication
- Closed
For Gerrit Dashboard: MB-59625 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
200919,1 | MB-59625: Toy build for grpc client unavailable | trinity | n1fty | Status: ABANDONED | -2 | 0 |
200927,5 | MB-59625: Improve conn pool logging | master | n1fty | Status: ABANDONED | -2 | 0 |
200944,3 | MB-59625: Improve conn pool logging | trinity | n1fty | Status: MERGED | +2 | +1 |
201095,2 | MB-59625: add expo backoff loop with retryCount | trinity | cbgt | Status: ABANDONED | -2 | 0 |
201096,5 | MB-59625: fix availableHosts calculation | trinity | n1fty | Status: MERGED | +2 | +1 |
201697,7 | MB-59625,MB-59653 improve conn pools update | trinity | n1fty | Status: MERGED | +2 | +1 |
201734,2 | Merge remote-tracking branch 'couchbase/trinity' | master | n1fty | Status: MERGED | +2 | +1 |
201884,4 | MB-59625 fix cfg subscription | trinity | n1fty | Status: MERGED | +2 | +1 |
202366,1 | Merge remote-tracking branch 'couchbase/trinity' | master | n1fty | Status: MERGED | +2 | +1 |
203582,3 | MB-59625: fix security settings change handler | trinity | n1fty | Status: MERGED | +2 | +1 |
203611,1 | Merge remote-tracking branch 'couchbase/trinity' | master | n1fty | Status: MERGED | +2 | +1 |