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

Query: query execution failed

    XMLWordPrintable

Details

    • Untriaged
    • Centos 64-bit
    • 1
    • Yes

    Description

      build: 7.0.0-4797

      Cluster configuration:

       

      kv,n1ql,index,fts
      kv
      fts
      

      Buckets:

      default

      bucket data dump is attached (default.json)

      GSI indexes:

      CREATE INDEX `gsi_index_0` ON `default`(((`revision`.`text`).`#text`))
      CREATE INDEX `gsi_index_1` ON `default`(`title`)
      CREATE INDEX `gsi_index_2` ON `default`((all (array `v` for `v` in `languages_known` end)))
      CREATE INDEX `gsi_index_3` ON `default`(((`revision`.`contributor`).`username`))
      CREATE INDEX `gsi_index_4` ON `default`(`dept`)
      CREATE INDEX `gsi_index_5` ON `default`((`revision`.`timestamp`))
      CREATE PRIMARY INDEX `primary_gsi_index` ON `default`
      

      FTS indexes:

      {
       "name": "custom_index_1",
       "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": false
         },
         "default_type": "_default",
         "docvalues_dynamic": true,
         "index_dynamic": true,
         "store_dynamic": false,
         "type_field": "type",
         "types": {
          "emp": {
           "dynamic": false,
           "enabled": true,
           "properties": {
            "manages": {
             "dynamic": false,
             "enabled": true,
             "properties": {
              "team_size": {
               "enabled": true,
               "dynamic": false,
               "fields": [
                {
                 "include_in_all": true,
                 "include_term_vectors": true,
                 "index": true,
                 "name": "team_size",
                 "type": "number"
                }
               ]
              }
             }
            },
            "is_manager": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "is_manager",
               "type": "boolean"
              }
             ]
            },
            "join_date": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "join_date",
               "type": "datetime"
              }
             ]
            },
            "mutated": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "mutated",
               "type": "number"
              }
             ]
            },
            "name": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "analyzer": "keyword",
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "name",
               "type": "text"
              }
             ]
            }
           }
          }
         }
        },
        "store": {
         "indexType": "scorch",
         "mossStoreOptions": {},
         "segmentVersion": 15
        }
       },
       "sourceType": "gocbcore",
       "sourceName": "default",
       "sourceUUID": "1bac06eb2d54fb9e4507172625576848",
       "sourceParams": {},
       "planParams": {
        "maxPartitionsPerPIndex": 1024,
        "numReplicas": 0,
        "indexPartitions": 1
       },
       "uuid": "2880e5af196ea0d2"
      }

      {
       "name": "custom_index_2",
       "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": false
         },
         "default_type": "_default",
         "docvalues_dynamic": true,
         "index_dynamic": true,
         "store_dynamic": false,
         "type_field": "type",
         "types": {
          "emp": {
           "dynamic": false,
           "enabled": true,
           "properties": {
            "manages": {
             "dynamic": false,
             "enabled": true,
             "properties": {
              "reports": {
               "enabled": true,
               "dynamic": false,
               "fields": [
                {
                 "analyzer": "keyword",
                 "include_in_all": true,
                 "include_term_vectors": true,
                 "index": true,
                 "name": "reports",
                 "type": "text"
                }
               ]
              }
             }
            },
            "email": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "analyzer": "keyword",
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "email",
               "type": "text"
              }
             ]
            },
            "is_manager": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "is_manager",
               "type": "boolean"
              }
             ]
            },
            "join_date": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "join_date",
               "type": "datetime"
              }
             ]
            },
            "mutated": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "mutated",
               "type": "number"
              }
             ]
            },
            "salary": {
             "enabled": true,
             "dynamic": false,
             "fields": [
              {
               "include_in_all": true,
               "include_term_vectors": true,
               "index": true,
               "name": "salary",
               "type": "number"
              }
             ]
            }
           }
          }
         }
        },
        "store": {
         "indexType": "scorch",
         "mossStoreOptions": {},
         "segmentVersion": 15
        }
       },
       "sourceType": "gocbcore",
       "sourceName": "default",
       "sourceUUID": "1bac06eb2d54fb9e4507172625576848",
       "sourceParams": {},
       "planParams": {
        "maxPartitionsPerPIndex": 1024,
        "numReplicas": 0,
        "indexPartitions": 1
       },
       "uuid": "4186f037afe988a8"
      }
      

       

      Found an error during test suite execution:

      [2021-03-30 13:57:13,515] - [tuq] [140205625427712] - INFO - RUN QUERY select meta().id from default where type = "emp" and  ( ( ( name = "Cytheria") AND ( email between "chatha@mcdiabetes.com" and "hedda@mcdiabetes.com")) AND ( SOME v IN manages.reports SATISFIES v = "Jerica" END))
      [2021-03-30 13:57:13,515] - [rest_client] [140205625427712] - INFO - query params : statement=select+meta%28%29.id+from+default+where+type+%3D+%22emp%22+and++%28+%28+%28+name+%3D+%22Cytheria%22%29+AND+%28+email+between+%22chatha%40mcdiabetes.com%22+and+%22hedda%40mcdiabetes.com%22%29%29+AND+%28+SOME+v+IN+manages.reports+SATISFIES+v+%3D+%22Jerica%22+END%29%29&scan_consistency=NOT_BOUNDED
      [2021-03-30 13:57:13,619] - [rest_client] [140205625427712] - ERROR - POST http://172.23.123.161:8093/query?statement=select+meta%28%29.id+from+default+where+type+%3D+%22emp%22+and++%28+%28+%28+name+%3D+%22Cytheria%22%29+AND+%28+email+between+%22chatha%40mcdiabetes.com%22+and+%22hedda%40mcdiabetes.com%22%29%29+AND+%28+SOME+v+IN+manages.reports+SATISFIES+v+%3D+%22Jerica%22+END%29%29&scan_consistency=NOT_BOUNDED body:  headers: {'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA=='} error: 500 reason: unknown b'{\n"requestID": "3691bb29-fcf4-449f-bb11-ad0498300b5c",\n"signature": {"id":"json"},\n"results": [\n],\n"errors": [{"code":5000,"msg":"n1fty: response_handler: stream.Recv, err  - cause: rpc error: code = ResourceExhausted desc = grpc_server: Search query reject on not enough quota: query request rejected"}],\n"status": "errors",\n"metrics": {"elapsedTime": "99.61029ms","executionTime": "99.55798ms","resultCount": 0,"resultSize": 0,"serviceLoad": 6,"errorCount": 1}\n}\n' auth: Administrator:password
      [2021-03-30 13:57:13,619] - [tuq] [140205625427712] - ERROR - PROBLEM WITH RESULT. TYPE IS: <class 'dict'> AND CONTENT IS: {'requestID': '3691bb29-fcf4-449f-bb11-ad0498300b5c', 'signature': {'id': 'json'}, 'results': [], 'errors': [{'code': 5000, 'msg': 'n1fty: response_handler: stream.Recv, err  - cause: rpc error: code = ResourceExhausted desc = grpc_server: Search query reject on not enough quota: query request rejected'}], 'status': 'errors', 'metrics': {'elapsedTime': '99.61029ms', 'executionTime': '99.55798ms', 'resultCount': 0, 'resultSize': 0, 'serviceLoad': 6, 'errorCount': 1}}
      [2021-03-30 13:57:13,619] - [flex_index_phase1] [140205625427712] - INFO - Failed to run gsi query: select meta().id from default where type = "emp" and  ( ( ( name = "Cytheria") AND ( email between "chatha@mcdiabetes.com" and "hedda@mcdiabetes.com")) AND ( SOME v IN manages.reports SATISFIES v = "Jerica" END))
      [2021-03-30 13:57:13,619] - [flex_index_phase1] [140205625427712] - ERROR - CBQError: host 172.23.123.161: ERROR:{'requestID': '3691bb29-fcf4-449f-bb11-ad0498300b5c', 'signature': {'id': 'json'}, 'results': [], 'errors': [{'code': 5000, 'msg': 'n1fty: response_handler: stream.Recv, err  - cause: rpc error: code = ResourceExhausted desc = grpc_server: Search query reject on not enough quota: query request rejected'}], 'status': 'errors', 'metrics': {'elapsedTime': '99.61029ms', 'executionTime': '99.55798ms', 'resultCount': 0, 'resultSize': 0, 'serviceLoad': 6, 'errorCount': 1}}
      

      Test execution log and collected server logs are attached

      Attachments

        1. 172.23.123.158-diag.txt.gz
          174 kB
        2. 172.23.123.159-diag.txt.gz
          171 kB
        3. 172.23.123.160-diag.txt.gz
          171 kB
        4. 172.23.123.161-diag.txt.gz
          720 kB
        5. default.json
          311 kB
        6. test (1).log
          341 kB
        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:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty