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

[BP MB-55848 to 7.2.0] - memory exceeded quota error with ARRAY_AGG

    XMLWordPrintable

Details

    • 0
    • Yes

    Description

      Using 7.1.3-3479-enterprise

       

      Steps to repro:

      a.  spin up server with kv+n1ql+index

      b.  load travel-sample bucket

      c.  set memory quota to 100MB

      \set -memory_quota 100;

      d.  run below query

      cbq> SELECT city, city_cnt, country, ARRAY_AGG(airportname) AS apnames FROM `travel-sample`.inventory.airport GROUP BY city, country LETTING city_cnt = COUNT(city) ;

       

      ..."errors": [
      		 
              {
      		 
                  "code": 5500,
      		 
                  "msg": "Request has exceeded memory quota"
      		 
              }
      		 
          ],
      		 
          "status": "errors",
      		 
          "metrics": {
      		 
              "elapsedTime": "160.899059ms",
      		 
              "executionTime": "160.809563ms",
      		 
              "resultCount": 1614,
      		 
              "resultSize": 265611,
      		 
              "serviceLoad": 4,
      		 
              "usedMemory": 18446744073709533811,
      		 
              "errorCount": 1
      		 
          }

       

      Attachments

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

        Activity

          People

            ajay.bhullar Ajay Bhullar
            Donald.haggart Donald Haggart
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty