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

Flex:System Test: 5000: Internal Error: n1fty: response_handler: err

    XMLWordPrintable

Details

    • 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

      Attachments

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

        Activity

          Build couchbase-server-7.0.0-2451 contains n1fty commit 0653703 with commit message:
          MB-40111: [BP] Return errors only if errors are actually available

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-2451 contains n1fty commit 0653703 with commit message: MB-40111 : [BP] Return errors only if errors are actually available

          Build couchbase-server-6.6.0-7843 contains n1fty commit 0653703 with commit message:
          MB-40111: [BP] Return errors only if errors are actually available

          build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.0-7843 contains n1fty commit 0653703 with commit message: MB-40111 : [BP] Return errors only if errors are actually available

          Verified with 6.6.0-7843

          girish.benakappa Girish Benakappa added a comment - Verified with 6.6.0-7843

          People

            abhinav Abhinav Dangeti
            girish.benakappa Girish Benakappa
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty