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

[N1QL] union all query hangs and doesn't time out

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • 7.0.0-3938
    • Untriaged
    • 1
    • Yes

    Description

      Create travel-sample bucket
      set query timeout to 10s

      run

      select type from `travel-sample` union all select name from `travel-sample`

      Previously on 7.0.0-3874, this query runs fine, now in 3938 it hangs, and ignores query timeout

      Logs attached

      Explain:

      {
          "#operator": "UnionAll",
          "~children": [
              {
                  "#operator": "Sequence",
                  "~children": [
                      {
                          "#operator": "PrimaryScan3",
                          "index": "def_primary",
                          "index_projection": {
                              "primary_key": true
                          },
                          "keyspace": "travel-sample",
                          "namespace": "default",
                          "using": "gsi"
                      },
                      {
                          "#operator": "Fetch",
                          "keyspace": "travel-sample",
                          "namespace": "default"
                      },
                      {
                          "#operator": "Parallel",
                          "~child": {
                              "#operator": "Sequence",
                              "~children": [
                                  {
                                      "#operator": "InitialProject",
                                      "result_terms": [
                                          {
                                              "expr": "(`travel-sample`.`type`)"
                                          }
                                      ]
                                  }
                              ]
                          }
                      }
                  ]
              },
              {
                  "#operator": "Sequence",
                  "~children": [
                      {
                          "#operator": "PrimaryScan3",
                          "index": "def_primary",
                          "index_projection": {
                              "primary_key": true
                          },
                          "keyspace": "travel-sample",
                          "namespace": "default",
                          "using": "gsi"
                      },
                      {
                          "#operator": "Fetch",
                          "keyspace": "travel-sample",
                          "namespace": "default"
                      },
                      {
                          "#operator": "Parallel",
                          "~child": {
                              "#operator": "Sequence",
                              "~children": [
                                  {
                                      "#operator": "InitialProject",
                                      "result_terms": [
                                          {
                                              "expr": "(`travel-sample`.`name`)"
                                          }
                                      ]
                                  }
                              ]
                          }
                      }
                  ]
              }
          ]
      }
      

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              ajay.bhullar Ajay Bhullar
              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