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

[UI][QWB] multiple inserts execution not working

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • Morpheus
    • Morpheus
    • UI
    • None
    • 7.6.0-1955
    • Untriaged
    • 0
    • Unknown

    Description

      I am trying to execute these inserts through QWB

      INSERT INTO default VALUES("K001", {"c1": false, "c3": 10, "a1": [10, 11]});
      INSERT INTO default VALUES("K002", {"c2": false, "c3": 10, "a1": [10, 11]});
      INSERT INTO default VALUES("K003", {"c1": true, "c3": 11, "a1": [11, 12]});
      INSERT INTO default VALUES("K004", {"c2": true, "c3": 11, "a1": [11, 12]});
      INSERT INTO default VALUES("K005", {"c1": false, "c2": false, "c3": 20, "a1": [20, 21]});
      INSERT INTO default VALUES("K006", {"c1": false, "c2": true, "c3": 20, "a1": [20, 21]});
      INSERT INTO default VALUES("K007", {"c1": true, "c2": false, "c3": 21, "a1": [21, 22]});
      INSERT INTO default VALUES("K008", {"c1": true, "c2": true, "c3": 21, "a1": [21, 22]});
      INSERT INTO default VALUES("K009", {"c3": 100, "a1": [100, 101, 102]});
      

      The QWB seems to get stuck on the 3rd statement, but we see that that document got inserted, but the QWB is stuck on executing for that statement. Also these inserts work through cbq and one at a time in the UI, its only when we are trying to execute them all through the UI at once. Attaching screenshots and logs

      {
          "_sequence_num": 1,
          "_sequence_query": "INSERT INTO default VALUES(\"K001\", {\"c1\": false, \"c3\": 10, \"a1\": [10, 11]});",
          "_sequence_query_status": "success",
          "_sequence_result": {
            "results": []
          }
        },
        {
          "_sequence_num": 2,
          "_sequence_query": "\nINSERT INTO default VALUES(\"K002\", {\"c2\": false, \"c3\": 10, \"a1\": [10, 11]});",
          "_sequence_query_status": "success",
          "_sequence_result": {
            "results": []
          }
        },
        {
          "_sequence_num": 3,
          "_sequence_query": "\nINSERT INTO default VALUES(\"K003\", {\"c1\": true, \"c3\": 11, \"a1\": [11, 12]});",
          "_sequence_query_status": "executing",
          "_sequence_result": {
            "status": "Executing statement"
          }
        }
      ]
      

      Attachments

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

        Activity

          People

            Pramada.Kolichala Pramada Kolichala
            ajay.bhullar Ajay Bhullar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty