Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.0
-
Untriaged
-
1
-
Unknown
Description
Build: 6.6.0 build 7834
Test: -test tests/n1ql/test_n1ql_fts_flexindex.yml -scope tests/n1ql/scope_flex_index_12nodes.yml
Scale: 2
Cluster config / bucket / indexes created are as attached.
Many such below flex queries (attached query_completed.json), throws error 5000: "n1fty: response_handler: err - cause: search err summary:
select result,SUM(rating) from `other-2` use index (using fts) where result ="SUCCESS" and rating >= 115 and rating <= 250 and `type`="gideon" group by result limit 100
|
|
|
[
|
{
|
"code": 5000,
|
"msg": "n1fty: response_handler: err - cause: search err summary: []",
|
"query": "select result,SUM(rating) from `other-2` use index (using fts) where result =\"SUCCESS\" and rating >= 115 and rating <= 250 and `type`=\"gideon\" group by result limit 100"
|
}
|
]
|
|
|
select result,AVG(rating),MIN(rating),MAX(rating) from `other-2` use index (using fts) where rating >= 200 and rating <= 1000 and `type`="gideon" group by result limit 1000
|
|
|
[
|
{
|
"code": 5000,
|
"msg": "n1fty: response_handler: err - cause: search err summary: []",
|
"query": "select result,AVG(rating),MIN(rating),MAX(rating) from `other-2` use index (using fts) where rating >= 200 and rating <= 1000 and `type`=\"gideon\" group by result limit 1000"
|
}
|
]
|
Explain plan for one of the query:
{
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "IndexFtsSearch",
|
"index": "bucket2_idx1",
|
"index_id": "109b3e1c0c91ab88",
|
"keyspace": "other-2",
|
"namespace": "default",
|
"search_info": {
|
"field": "\"\"",
|
"options": "{\"index\": \"bucket2_idx1\"}",
|
"outname": "out",
|
"query": "{\"query\": {\"conjuncts\": [{\"field\": \"result\", \"term\": \"SUCCESS\"}, {\"field\": \"rating\", \"inclusive_max\": true, \"inclusive_min\": true, \"max\": 250, \"min\": 115}]}, \"score\": \"none\"}"
|
},
|
"using": "fts"
|
},
|
{
|
"#operator": "Fetch",
|
"keyspace": "other-2",
|
"namespace": "default"
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Filter",
|
"condition": "(((((`other-2`.`result`) = \"SUCCESS\") and (115 <= (`other-2`.`rating`))) and ((`other-2`.`rating`) <= 250)) and ((`other-2`.`type`) = \"gideon\"))"
|
},
|
{
|
"#operator": "InitialGroup",
|
"aggregates": [
|
"sum((`other-2`.`rating`))"
|
],
|
"group_keys": [
|
"(`other-2`.`result`)"
|
]
|
}
|
]
|
}
|
},
|
{
|
"#operator": "IntermediateGroup",
|
"aggregates": [
|
"sum((`other-2`.`rating`))"
|
],
|
"group_keys": [
|
"(`other-2`.`result`)"
|
]
|
},
|
{
|
"#operator": "FinalGroup",
|
"aggregates": [
|
"sum((`other-2`.`rating`))"
|
],
|
"group_keys": [
|
"(`other-2`.`result`)"
|
]
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "InitialProject",
|
"result_terms": [
|
{
|
"expr": "(`other-2`.`result`)"
|
},
|
{
|
"expr": "sum((`other-2`.`rating`))"
|
}
|
]
|
},
|
{
|
"#operator": "FinalProject"
|
}
|
]
|
}
|
}
|
]
|
},
|
{
|
"#operator": "Limit",
|
"expr": "100"
|
}
|
]
|
}
|
index defn with other-2 bucket:
{
|
"type": "fulltext-index",
|
"name": "bucket2_idx1",
|
"uuid": "109b3e1c0c91ab88",
|
"sourceType": "couchbase",
|
"sourceName": "other-2",
|
"planParams": {
|
"maxPartitionsPerPIndex": 171
|
},
|
"params": {
|
"doc_config": {
|
"docid_prefix_delim": "",
|
"docid_regexp": "",
|
"mode": "type_field",
|
"type_field": "type"
|
},
|
"mapping": {
|
"analysis": {},
|
"default_analyzer": "standard",
|
"default_datetime_parser": "dateTimeOptional",
|
"default_field": "_all",
|
"default_mapping": {
|
"dynamic": true,
|
"enabled": false
|
},
|
"default_type": "_default",
|
"docvalues_dynamic": true,
|
"index_dynamic": true,
|
"store_dynamic": false,
|
"type_field": "_type",
|
"types": {
|
"gideon": {
|
"default_analyzer": "keyword",
|
"dynamic": false,
|
"enabled": true,
|
"properties": {
|
"build_id": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "build_id",
|
"type": "number"
|
}
|
]
|
},
|
"rating": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "rating",
|
"type": "number"
|
}
|
]
|
},
|
"result": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "result",
|
"type": "text"
|
}
|
]
|
}
|
}
|
}
|
}
|
},
|
"store": {
|
"indexType": "scorch"
|
}
|
},
|
"sourceParams": {}
|
}
|
Error, thats been throwed is not intuitive and also could not see any messages w.r.t to this in logs:
cbcollect logs:
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.120.73.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.120.77.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.120.86.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.121.77.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.123.24.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.123.25.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.123.26.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.96.122.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.96.14.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.96.18.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.96.48.zip
url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1592955881/collectinfo-2020-06-23T234444-ns_1%40172.23.97.74.zip
