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

JS UDF: If a javascript function contains a transaction, even after the transaction commits, the metrics shows "transactionRemainingTime"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.1.0
    • 7.1.0
    • query
    • None
    • Untriaged
    • 1
    • Unknown

    Description

      cbq> EXECUTE FUNCTION doDelivery(1,7,"2022-01-10 11:07:35.066141");
      {
          "requestID": "e66e7cc7-295a-4fab-b04c-cfcc9e7de3c1",
          "signature": null,
          "results": [
          [
              1,
              2418
          ]
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "51.530981ms",
              "executionTime": "51.420036ms",
              "resultCount": 1,
              "resultSize": 31,
              "serviceLoad": 3,
              "transactionElapsedTime": "22.330848ms",
              "transactionRemainingTime": "14.977660267s"
          }
      } 

       

      function doDelivery(w_id,o_carrier_id,ol_delivery_d){
       
          try{
              var querybegin=BEGIN WORK;
              querybegin.close();
       
              var result = [];
               var d_id=1;
                  var params = [d_id,w_id];
                  var query= N1QL('EXECUTE DELIVERY_getNewOrder',params);
                  var newOrder = [];
                  for (const row of query) {
                       newOrder.push(row);
                   }
                  query.close();
       
                  if (newOrder.length == 0){
                      /*## No orders for this district: skip it. Note: This must be reported if > 1%*/
                      var query = COMMIT WORK;
                      return;
                      }
                  var no_o_id = newOrder[0]['NO_O_ID'];
       
                  params = [no_o_id, d_id, w_id];
                  var query = N1QL('EXECUTE DELIVERY_getCId',params);
                  var rs = [];
      ....
      ....
       
              var query = COMMIT WORK;
              query.close();
       
              return result;
          }catch (error){     var query = ROLLBACK WORK;              throw error;
          }
      

       

      Attachments

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

        Activity

          People

            kamini.jagtiani Kamini Jagtiani
            kamini.jagtiani Kamini Jagtiani
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                PagerDuty