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

wrong phaseCounts.fetch in system:completed_requests

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Cheshire-Cat, 6.6.1
    • 6.6.2, 7.0.0
    • query
    • Untriaged
    • 1
    • Unknown

    Description

      Set completed-threshold to 0 so that every thing will be recorded.

      curl -u Administrator:password http://localhost:8093/admin/settings -XPOST -d '{"completed-threshold":0}'
      

      Repro:

      DELETE FROM system:completed_requests;
      insert into default values ("k01", {"a":1});
      select * from default use keys "k01";
      select * from default use keys "k01";
      select * from default use keys "k01";
      select * from system:completed_requests;
      
      

      Observe phaseCounts.fetch of statement of "select * from default use keys "k01""
      It shows 3 entries of 3 different values 1,2,3

      Attachments

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

        Activity

          Build couchbase-server-7.0.0-4685 contains query commit f6045ec with commit message:
          MB-44938. Reset count

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-4685 contains query commit f6045ec with commit message: MB-44938 . Reset count

          Mihir KamdarWayne Siu Please approve this 6.6.2

          Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - Mihir Kamdar Wayne Siu Please approve this 6.6.2

          I am fine taking this in 6.6.2. Wayne Siu are you okay too ?

          mihir.kamdar Mihir Kamdar (Inactive) added a comment - I am fine taking this in 6.6.2. Wayne Siu are you okay too ?
          wayne Wayne Siu added a comment -

          Yes, let's take it in 6.6.2.

          wayne Wayne Siu added a comment - Yes, let's take it in 6.6.2.

          Build couchbase-server-6.6.2-9566 contains query commit 6f6d3fd with commit message:
          MB-44938. Reset count

          build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.2-9566 contains query commit 6f6d3fd with commit message: MB-44938 . Reset count

          Verified on 7.0.0-4705 and 6.6.2-9569

          I see following consistent count for phaseCounts:

                  "completed_requests": {
                      "elapsedTime": "1.758533ms",
                      "errorCount": 0,
                      "node": "127.0.0.1:8091",
                      "phaseCounts": {
                          "fetch": 1
                      },
                      "phaseOperators": {
                          "authorize": 1,
                          "fetch": 1
                      },
                      "phaseTimes": {
                          "authorize": "49.278µs",
                          "fetch": "319.785µs",
                          "instantiate": "21.97µs",
                          "parse": "831.108µs",
                          "plan": "68.572µs",
                          "run": "662.482µs"
                      },
                      "remoteAddr": "127.0.0.1:37464",
                      "requestId": "235a6320-ab12-40f2-aa73-62024774ce69",
                      "requestTime": "2021-03-16T14:08:49.864-07:00",
                      "resultCount": 1,
                      "resultSize": 57,
                      "scanConsistency": "unbounded",
                      "serviceTime": "1.608706ms",
                      "state": "completed",
                      "statement": "select * from default use keys \"k01\";",
                      "userAgent": "Go-http-client/1.1 (CBQ/2.0)",
                      "users": "Administrator"
                  } 

          pierre.regazzoni Pierre Regazzoni added a comment - Verified on 7.0.0-4705 and 6.6.2-9569 I see following consistent count for phaseCounts:         "completed_requests" : {             "elapsedTime" : "1.758533ms" ,             "errorCount" : 0 ,             "node" : "127.0.0.1:8091" ,             "phaseCounts" : {                 "fetch" : 1             },             "phaseOperators" : {                 "authorize" : 1 ,                 "fetch" : 1             },             "phaseTimes" : {                 "authorize" : "49.278µs" ,                 "fetch" : "319.785µs" ,                 "instantiate" : "21.97µs" ,                 "parse" : "831.108µs" ,                 "plan" : "68.572µs" ,                 "run" : "662.482µs"             },             "remoteAddr" : "127.0.0.1:37464" ,             "requestId" : "235a6320-ab12-40f2-aa73-62024774ce69" ,             "requestTime" : "2021-03-16T14:08:49.864-07:00" ,             "resultCount" : 1 ,             "resultSize" : 57 ,             "scanConsistency" : "unbounded" ,             "serviceTime" : "1.608706ms" ,             "state" : "completed" ,             "statement" : "select * from default use keys \"k01\";" ,             "userAgent" : "Go-http-client/1.1 (CBQ/2.0)" ,             "users" : "Administrator"         }

          People

            pierre.regazzoni Pierre Regazzoni
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty