Details
-
Bug
-
Resolution: Fixed
-
Critical
-
Cheshire-Cat
-
Untriaged
-
1
-
Yes
Description
Build: 7.0.0-5129
- Create cluster with kv, kv+query, fts
- Load travel-sample
- Create fts index like below:
{
"type": "fulltext-index",
"name": "second",
"uuid": "60f5a5a0cff8b73a",
"sourceType": "gocbcore",
"sourceName": "travel-sample",
"sourceUUID": "3e5d5b07817a2a96a5f0b7d334cd382d",
"planParams": {
"maxPartitionsPerPIndex": 1024,
"indexPartitions": 1
},
"params": {
"doc_config": {
"docid_prefix_delim": "",
"docid_regexp": "",
"mode": "type_field",
"type_field": "type"
},
"mapping": {
"analysis": {},
"default_analyzer": "keyword",
"default_datetime_parser": "dateTimeOptional",
"default_field": "_all",
"default_mapping": {
"dynamic": true,
"enabled": true
},
"default_type": "_default",
"docvalues_dynamic": false,
"index_dynamic": true,
"store_dynamic": false,
"type_field": "_type"
},
"store": {
"indexType": "scorch",
"segmentVersion": 15
}
},
"sourceParams": {}
}
- Run Flex query: select meta().id from `travel-sample`._default._default USE INDEX(USING FTS) where name = 'Atifly' . It returns below results:
[
{
"id": "airline_10226"
}
]
- Now, delete the fts index
- Run the same query again. It throws below error:
[
{
"code": 5000,
"msg": "n1fty: response_handler: stream.Recv, err - cause: rpc error: code = PermissionDenied desc = grpc_server: Search err: grpc_auth: auth err: grpc_auth: preparePerms err: index not found",
"query": "select meta().id from `travel-sample`._default._default USE INDEX(USING FTS) where name = 'Atifly'"
}
]
- Explain of the same query shows its trying to get results from deleted index
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexFtsSearch",
"bucket": "travel-sample",
"covers": [
"cover (((`_default`.`name`) = \"Atifly\"))",
"cover ((meta(`_default`).`id`))"
],
"index": "second",
"index_id": "60f5a5a0cff8b73a",
"keyspace": "_default",
"namespace": "default",
"scope": "_default",
"search_info": {
"field": "\"\"",
"options": "{\"index\": \"second\"}",
"outname": "out",
"query": "{\"query\": {\"field\": \"name\", \"term\": \"Atifly\"}, \"score\": \"none\"}"
},
"using": "fts"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Filter",
"condition": "cover (((`_default`.`name`) = \"Atifly\"))"
},
{
"#operator": "InitialProject",
"result_terms": [
{
"expr": "cover ((meta(`_default`).`id`))"
}
]
}
]
}
}
]
}