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

FTS: SEARCH_QUERY() function query execution failed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • Cheshire-Cat
    • 7.0.0
    • 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

          marco.greco Marco Greco added a comment -

          Evgeny Makarenko http://172.23.126.166/builds/latestbuilds/couchbase-server/toybuilds/12541/couchbase-server-enterprise-7.0.0-12541-centos7.x86_64.rpm has some temp code to do http request validation.
          Should fix the issue.
          Could you try it and let me know?

          marco.greco Marco Greco added a comment - Evgeny Makarenko http://172.23.126.166/builds/latestbuilds/couchbase-server/toybuilds/12541/couchbase-server-enterprise-7.0.0-12541-centos7.x86_64.rpm has some temp code to do http request validation. Should fix the issue. Could you try it and let me know?

          Toy build works fine. Suggested scenario is tested and passed. 

          evgeny.makarenko Evgeny Makarenko (Inactive) added a comment - Toy build works fine. Suggested scenario is tested and passed. 

          Build couchbase-server-7.0.0-4832 contains query commit a5026e5 with commit message:
          MB-45327 temporary http request user extraction waiting for cbauth

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-4832 contains query commit a5026e5 with commit message: MB-45327 temporary http request user extraction waiting for cbauth

          Evgeny Makarenko can you verify and close this issue. Thanks.

          pierre.regazzoni Pierre Regazzoni added a comment - Evgeny Makarenko  can you verify and close this issue. Thanks.

          verified for build 7.0.0-4907

          evgeny.makarenko Evgeny Makarenko (Inactive) added a comment - verified for build 7.0.0-4907

          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