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

[BP 7.2.0 MB-53107] [N1QL] insert returning does not trigger memory quota

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 7.2.0
    • 7.1.2
    • query
    • 7.1.2-3390
    • Untriaged
    • 1
    • No

    Description

      Basically we are seeing that this insert does not trigger a memory quota exceeded

      empty bucket default

      curl -v -u Administrator:password http://172.23.104.110:8093/query/service -d 'statement=insert into default (key, value) values("1", { "abcd": { "def": repeat("abcd", 29990), "arr": array_repeat(repeat("efgh", 1000), 5000)}}) returning *&memory_quota=1'

      but if we do select * from default; where the only document is above, we are seeing the memory quota is exceeded, but the returning in insert will return the exact same document

      insert into default (key a, value v ) select a, { "abcd": { "def": repeat("abcd", 29990), "arr": array_repeat(repeat("efgh", 1000), 5000)}} as v from ["1"] as a returning abcd.def ;

      this does trigger memory quota error

      Attachments

        For Gerrit Dashboard: MB-54040
        # Subject Branch Project Status CR V

        Activity

          People

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