Uploaded image for project: 'Couchbase Java Client'
  1. Couchbase Java Client
  2. JCBC-2122

QueryOptionTest.noProfileRequestedGivesEmptyProfile returns profile

    XMLWordPrintable

Details

    • Bug
    • Resolution: Incomplete
    • Major
    • None
    • None
    • None
    • None
    • 0

    Description

      QueryOptionTest.noProfileRequestedGivesEmptyProfile

      Cluster: Capella provisioned 7.6

      The test created below query request: 

      query_result {
        content {
          content_as_bytes: "{\"default\":{\"foo\":\"bar\"}}"
        }
        meta_data {
          request_id: "f1223e0b-1810-43f9-b247-944b2210fb4d"
          client_context_id: "a624e9cd-308d-4345-b716-86a67971915b"
          status: SUCCESS
          signature: "{\"*\":\"*\"}"
          profile: "{\"requestTime\":\"2024-02-08T09:47:54.127Z\",\"phaseOperators\":{\"filter\":1,\"indexScan\":1,\"indexScan.GSI\":1,\"stream\":1,\"fetch\":1,\"project\":1,\"authorize\":1},\"servicingHost\":\"svc-dqisea-node-003.q3eog8gunyibntyw.nonprod-project-avengers.com:8091\",\"optimizerEstimates\":{\"cardinality\":0.010000000000000002,\"cost\":2.4161100000000006},\"cpuTime\":\"70.243\302\265s\",\"phaseCounts\":{\"filter\":1,\"indexScan\":1,\"indexScan.GSI\":1,\"fetch\":1},\"executionTimings\":{\"#stats\":{\"execTime\":\"1.282\302\265s\",\"servTime\":\"4.698\302\265s\",\"#phaseSwitches\":4},\"~child\":{\"~children\":[{\"keyspace\":\"default\",\"spans\":[{\"exact\":true,\"range\":[{\"inclusion\":3,\"low\":\"\\\"5c97db88-eff4-4dad-a26b-a411e4707624\\\"\",\"high\":\"\\\"5c97db88-eff4-4dad-a26b-a411e4707624\\\"\"}]}],\"#operator\":\"IndexScan3\",\"using\":\"gsi\",\"#stats\":{\"#phaseSwitches\":7,\"kernTime\":\"14.322\302\265s\",\"usedMemory\":550,\"execTime\":\"21.692\302\265s\",\"servTime\":\"1.613167ms\",\"#itemsOut\":1,\"#itemsIn\":1},\"namespace\":\"default\",\"index\":\"#primary\",\"optimizer_estimates\":{\"cost\":1.205,\"size\":1,\"fr_cost\":1.205,\"cardinality\":0.1},\"index_id\":\"53dedc04151d5161\"},{\"#stats\":{\"#phaseSwitches\":10,\"kernTime\":\"1.659144ms\",\"usedMemory\":1966,\"execTime\":\"20.777\302\265s\",\"servTime\":\"469.419\302\265s\",\"#itemsOut\":1,\"#itemsIn\":1},\"namespace\":\"default\",\"keyspace\":\"default\",\"optimizer_estimates\":{\"cost\":2.4160000000000004,\"size\":1,\"fr_cost\":2.4160000000000004,\"cardinality\":0.1},\"#operator\":\"Fetch\"},{\"~children\":[{\"#stats\":{\"execTime\":\"8.39\302\265s\",\"#phaseSwitches\":8,\"#itemsOut\":1,\"kernTime\":\"2.154786ms\",\"usedMemory\":1966,\"#itemsIn\":1},\"optimizer_estimates\":{\"cost\":2.4161000000000006,\"size\":1,\"fr_cost\":2.4161000000000006,\"cardinality\":0.010000000000000002},\"#operator\":\"Filter\",\"condition\":\"((meta(`default`).`id`) = \\\"5c97db88-eff4-4dad-a26b-a411e4707624\\\")\"},{\"#stats\":{\"execTime\":\"4.181\302\265s\",\"#phaseSwitches\":7,\"#itemsOut\":1,\"kernTime\":\"2.166957ms\",\"#itemsIn\":1},\"optimizer_estimates\":{\"cost\":2.4161100000000006,\"size\":1,\"fr_cost\":2.4161100000000006,\"cardinality\":0.010000000000000002},\"#operator\":\"InitialProject\",\"result_terms\":[{\"star\":true,\"expr\":\"self\"}],\"discard_original\":true,\"preserve_order\":true}],\"#stats\":{\"execTime\":\"7.449\302\265s\",\"#phaseSwitches\":1},\"#operator\":\"Sequence\"},{\"#stats\":{\"execTime\":\"4.531\302\265s\",\"#phaseSwitches\":3,\"#itemsOut\":1,\"#itemsIn\":1},\"optimizer_estimates\":{\"cost\":2.4161100000000006,\"size\":1,\"fr_cost\":2.4161100000000006,\"cardinality\":0.010000000000000002},\"#operator\":\"Stream\",\"serializable\":true}],\"#stats\":{\"execTime\":\"1.941\302\265s\",\"#phaseSwitches\":2},\"#operator\":\"Sequence\"},\"privileges\":{\"List\":[{\"Props\":0,\"Priv\":7,\"Target\":\"default:default\"}]},\"#operator\":\"Authorize\",\"~versions\":[\"7.6.0-N1QL\",\"7.6.0-2071-enterprise\"],\"#planPreparedTime\":\"2024-02-08T09:47:54.128Z\"},\"phaseTimes\":{\"plan.keyspace.metadata\":\"3.653\302\265s\",\"plan.index.metadata\":\"22.651\302\265s\",\"project\":\"4.181\302\265s\",\"run\":\"2.21186ms\",\"parse\":\"326.514\302\265s\",\"instantiate\":\"16.746\302\265s\",\"filter\":\"8.39\302\265s\",\"indexScan\":\"1.634859ms\",\"indexScan.GSI\":\"1.634859ms\",\"stream\":\"4.531\302\265s\",\"fetch\":\"490.196\302\265s\",\"authorize\":\"5.98\302\265s\",\"plan\":\"193.247\302\265s\"}}"
        }
      } 

      while we expect the `meta_data` not to contain `profile` key.

      Attaching driver and performer logs for reference. 

      Thanks!

      Attachments

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

        Activity

          People

            aaliya.haque Aaliya Haque
            aaliya.haque Aaliya Haque
            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