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

Flex:rpc error: code = PermissionDenied:preparePerms err: index not found

    XMLWordPrintable

Details

    • 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`))"
                                    }
                                ]
                            }
                        ]
                    }
                }
            ]
        }
        

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            girish.benakappa Girish Benakappa
            girish.benakappa Girish Benakappa
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty