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

[BP to 7.2.4 MB-55053] prepared statement with udf can leak memory

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown

    Description

      CREATE primary index on default;
      UPSERT INTO default(KEY k, VALUE v)
      SELECT "k0"||TO_STR(d) AS k, {"a":d} AS v FROM ARRAY_RANGE(0,10) AS d ;
      CREATE OR REPLACE FUNCTION default:default._default.myudf() {
      ((SELECT RAW d.a FROM default._default._default AS d))
      };
      SELECT d1 FROM default:default._default.myudf() AS d1;

       

      python3 mt.py

      Above script runs 30 threads

      Each execute 300k iterations

      thread 0 – creates dummy udf1()

      thread 1-29 execute prepare statement of SELECT d1 FROM default:default._default.myudf() AS d1;

      check memory it keep leak until prepare statement forced prepare or droped.

      If you don't create dummy udf1() no issue.

       

      cc Donald Haggart Dhanya Gowrish  Bingjie Miao Gaurav Jayaraj 

       

       

      Attachments

        Issue Links

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

          Activity

            People

              bingjie.miao Bingjie Miao
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty