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

Query Tab in UI:UI hangs after long running queries on a dataset containing 82k docs

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • 5.0.0
    • 5.0.0
    • query_tools
    • 5.0.0-1755
    • Untriaged
    • No

    Description

      1. create bucket default with 82k similar docs.
      2. Execute this query:
        SELECT meta().id, (SELECT RAW SUM(item.memory) FROM default as item)[0] total FROM orders LET items = (SELECT VMs.* FROM default.VMs ORDER BY VMs.memory)
      1. Above query takes 1 min to execute and returns results.
      2. Try changing the query in editor, I am not able to edit the query.The UI just hangs.

      Example document:

      {
      "tasks": [
      {
      "Marketing": [
      {
      "region2": "International",
      "region1": "South"
      },
      {
      "region2": "South"
      }
      ],
      "Developer": [
      "IOS",
      "Indexing"
      ]
      },
      "Sales",
      "QA"
      ],
      "name": [
      {
      "FirstName": "employeefirstname-9"
      },
      {
      "MiddleName": "employeemiddlename-9"
      },
      {
      "LastName": "employeelastname-9"
      }
      ],
      "address": [
      [
      {
      "city": "Delhi"
      },
      {
      "street": "12th street"
      }
      ],
      [
      {
      "country": "EUROPE",
      "apartment": 123
      }
      ]
      ],
      "email": "9-mail@couchbase.com",
      "mutated": 0,
      "hobbies": {
      "hobby": [
      {
      "sports": [
      "Badminton",
      "Football",
      "Basketball"
      ]
      },
      {
      "dance": [
      "hip hop",
      "bollywood",
      "contemporary"
      ]
      },
      "art"
      ]
      },
      "department": "Support",
      "join_yr": [
      2013,
      2015,
      2012
      ],
      "_id": "query-testemployee10153.1877827-0",
      "VMs": [
      {
      "RAM": 10,
      "os": "ubuntu",
      "name": "vm_10",
      "memory": 10
      },
      {
      "RAM": 10,
      "os": "windows",
      "name": "vm_11",
      "memory": 10
      },
      {
      "RAM": 10,
      "os": "centos",
      "name": "vm_12",
      "memory": 10
      },
      {
      "RAM": 10,
      "os": "macos",
      "name": "vm_13",
      "memory": 10
      }
      ]
      }

      Attachments

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

        Activity

          People

            eben Eben Haber
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty