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

FTS: SEARCH_QUERY() function query execution failed

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 7.0.0
    • Cheshire-Cat
    • query

    Description

      build: 7.0.0-4797

      Steps to reproduce:

      • create custer: [kv:n1ql:index, index:n1ql:fts]
      • load attached data into test_bucket
      • create the following GSI indexes:

       

       CREATE PRIMARY INDEX `#primary` ON `test_bucket`
      

      • Create the following FTS indexes:

       

      {
       "name": "idx_test_bucket_fts",
       "type": "fulltext-index",
       "params": {
        "doc_config": {
         "docid_prefix_delim": "",
         "docid_regexp": "",
         "mode": "type_field",
         "type_field": "type"
        },
        "mapping": {
         "default_analyzer": "standard",
         "default_datetime_parser": "dateTimeOptional",
         "default_field": "_all",
         "default_mapping": {
          "dynamic": true,
          "enabled": true
         },
         "default_type": "_default",
         "docvalues_dynamic": true,
         "index_dynamic": true,
         "store_dynamic": false,
         "type_field": "_type"
        },
        "store": {
         "indexType": "scorch",
         "mossStoreOptions": {},
         "segmentVersion": 15
        }
       },
       "sourceType": "gocbcore",
       "sourceName": "test_bucket",
       "sourceUUID": "ae5b29a2f81d7868c9d2777fa535be0a",
       "sourceParams": {},
       "planParams": {
        "maxPartitionsPerPIndex": 1024,
        "numReplicas": 0,
        "indexPartitions": 1
       },
       "uuid": "3a42b3e2720e92a1"
      }
      

      {
       "name": "idx_test_bucket_fts-copy",
       "type": "fulltext-index",
       "params": {
        "doc_config": {
         "docid_prefix_delim": "",
         "docid_regexp": "",
         "mode": "type_field",
         "type_field": "type"
        },
        "mapping": {
         "default_analyzer": "standard",
         "default_datetime_parser": "dateTimeOptional",
         "default_field": "_all",
         "default_mapping": {
          "dynamic": true,
          "enabled": true
         },
         "default_type": "_default",
         "docvalues_dynamic": true,
         "index_dynamic": true,
         "store_dynamic": false,
         "type_field": "_type"
        },
        "store": {
         "indexType": "scorch",
         "mossStoreOptions": {},
         "segmentVersion": 15
        }
       },
       "sourceType": "gocbcore",
       "sourceName": "test_bucket",
       "sourceUUID": "ae5b29a2f81d7868c9d2777fa535be0a",
       "sourceParams": {},
       "planParams": {
        "maxPartitionsPerPIndex": 1024,
        "numReplicas": 0,
        "indexPartitions": 1
       },
       "uuid": "18d24a41ebebd861"
      }
      

       

      {
       "name": "idx_test_bucket_fts-copy_alias",
       "type": "fulltext-alias",
       "params": {
        "targets": {
         "idx_test_bucket_fts-copy": {}
        }
       },
       "sourceType": "nil",
       "sourceUUID": "",
       "sourceParams": {},
       "planParams": {},
       "uuid": "7dfba9f293a3cea2"
      }
      

      {
       "name": "idx_test_bucket_fts_alias",
       "type": "fulltext-alias",
       "params": {
        "targets": {
         "idx_test_bucket_fts": {}
        }
       },
       "sourceType": "nil",
       "sourceUUID": "",
       "sourceParams": {},
       "planParams": {},
       "uuid": "294124a67100a4d5"
      }
      

      • run the following query:

      select primary_key from `test_bucket` where meta().id in (select raw ht.id from (SELECT result.hits FROM SEARCH_QUERY('idx_test_bucket_fts', { 'explain' : FALSE, 'fields' : [ 'string_field' ], 'highlight' : {}, 'query' : { 'query' : 'string_field:test_string' }, 'size':100}) AS result) aa unnest aa.hits as ht) order by primary_key
      

      Response is:

      [
        {
          "code": 5010,
          "msg": "Error evaluating ExpressionScan. - cause: Issue with accessing node information for rest endpoint nodesExt - cause: nodesExt"
        }
      ]
      

       

       

       

       

      Attachments

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

        Activity

          People

            evgeny.makarenko Evgeny Makarenko (Inactive)
            evgeny.makarenko Evgeny Makarenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty