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

[Query] execute long prepare first show explain error until execution is complete

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • Morpheus
    • 7.1.0
    • UI
    • None
    • 7.1.0-2534
    • Untriaged
    • 1
    • Unknown

    Description

      To repro:

      • from query/UDF create function: 

        function sleep(delay) {
            var start = new Date().getTime();
            while (new Date().getTime() < start + delay);
            return delay;
        } 

      • create a long running prepare statement 

        prepare sleep1min as select sleep(60000); 

      • from query UI execute statement 

        execute sleep1min 

      You will first see "explain" error but query is still executing:

      Then result will finally show:

      This might be confusing for user and think the prepare statement failed to execute.

       

      Attachments

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

        Activity

          People

            eben Eben Haber
            pierre.regazzoni Pierre Regazzoni
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty