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

unable to decode prepared statement

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 4.5.0
    • 4.5.0
    • query
    • 3 nodes
      build version 2566
      1 bucket: default
      primary index on default
      3 indexes like CREATE INDEX I1 ON default(a,b) WHERE a is valued
    • Untriaged
    • Yes

    Description

      In the course of investigating MB-19659, I have run into a problem with prepared statements. I thought this bug had been fixed.

      I installed 2566 on a machine, and ran statement curl http://172.23.123.102:8093/query/service -d "statement=prepare select count(1) from default where a = ? and b = ?"

      Based on the results, I assembled this request

      curl http://172.23.123.100:8093/query/service -H "Content-Type: application/json" -d '

      { "encoded_plan": "H4sIAAAJbogA/7RTwY7aMBD9FcvlAFJYkRC2IVJV9dIWqYdVOVYrcOIhuHWc1LFZWpR+e8cmsApsD0Xam+N5fvPmzcuBgsorDnxVS6ZoSmlAFSsBTzzk2XQa3o/vs7fROE42yXgexcl4MoniiMM8jmYzRFc1aGYqTdMDffP8QZfw0yI3IORPvhWSa0D+b33QB2u2lRa/HcqDbmJZKA77ZY76kaXagW4QcjyR4XDNYcOsNOu7NVuPRidMv5L1KyUY9lwe3a0Fd4DHgG6ENKBXpzaH85OLPkQ0ZMekBY7vUqMttAEVTigKFiHtPlYCR6azeTaBZBbP8yTJ4/kGqz/gV1Oz3C/iyNtt5voWb1TjTfnKVAFO1GdRbJ0HA9doEDnhC5VL24gK7ZsG9Ev11Ku3LUKwrAqkLhpB26Dv8QPTTEqQ50XctKmP3j1vtOLCeDV0OPzHqsg7MghHhClOXoJkHSRChy/lLhSyM/lJV7bGdqwoNBTMQJcMq8ww9PssHGLl3MbKY4tGXDGh4hK4wNf/TRdcjq9u0PQqm+gMetDVd8hdijQ0aOvKDXsME+xrBzwLa18e58TgrEMErbXYCQkF+L+j21Z6SmsaXhm8NBpY6elpIwrFjNU+xBjOlCpbZpgYrBnY43vkh5ppIA1IbEtO8shGVyXp2pCnLSCEYTre+/hk7kTbvwEAAP//H56ogO4EAAA=", "prepared": "d1db3316-6b72-48f8-9248-00242de94255", "args":["A1","B2"]}

      This request failed:

      {
      "requestID": "c339e667-7578-4744-9115-68e2c801b9a1",
      "errors": [

      { "code": 4070, "msg": "Unable to decode prepared statement - cause: Unrecognizable prepared statement - cause: JSON unmarshalling error: json: cannot unmarshal bool into Go value of type value.Value" }

      ],
      "status": "fatal",
      "metrics":

      { "elapsedTime": "78.352µs", "executionTime": "76.518µs", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      Attachments

        For Gerrit Dashboard: MB-19692
        # Subject Branch Project Status CR V

        Activity

          People

            gerald Gerald Sangudi (Inactive)
            johan.larson Johan Larson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty