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

[N1QL] Incorrect encoded plan gives incorrect error message.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Resolved
    • Major
    • 6.5.0
    • 4.6.4
    • query
    • 4.6.4-4544
    • Untriaged
    • No

    Description

      1. create an empty bucket default.
      2. create primary index on it.
      3. prepare a statement through UI:
      prepare p1 as explain SELECT * FROM default WHERE k10 > 10 AND k20 > 20 ORDER BY k20;
      4. Encoded plan generated is:
      "encoded_plan": "H4sIAAAJbogA/6xSwW4TMRD9lZF7SVCEknArJ6AbgQQk2iAhBKg7sqepu17bjL1Sqqh8O+NmaUW3B4pQchg/v3nvzXgPirwOhsx5dOjVqVIz5bEjqeJC6hCJMQdWpwd1cn9QW/rRSycJ5ae+tM4wSffXgzrK/CX5yaQN2w75eqvFZKasN7QX9CQeYYFauk4Rdclv6AJ7l4eBxmifrN8JsktW3cz+9FlR1pdPkXsosEFG58jdTfNPO1lZl4mFooM3NttQXmgyWczhWz+fv9AwaYYAzfOmXcyb6RTQG5gsH2csC2M6CvvOiza6DYcr0mVCpiQd5+LdpdtQtI+FmMhdyHXKKKfMPd18l5/8Hwiu2dzGToEfURlFUmOFlfX3gcq1yrTPZW/V++rNJ3gGq3r9AQYh+Py2qitofy+GQKpXH8+gXd4hUq3rs6qG118K/HK0hW1mwu5oluzOY+65PPFVCuVjG/wjU0QmiAvABDKRQ+vhP6b6FQAA//9FY4CqkgMAAA==",

      5. Use an incorrect encoded plan while querying as:
      curl -v http://172.23.107.182:8093/query/service -H "Content-Type: application/json" -d '{"prepared":"p1", "encoded_plan":"H4sIAAAJbogA/7xUQW8TPRD9K9Z8l7RafVpvCIHlVOhGRCqkSpAQgigx9jQxcbyL7YWFKvx2xsmGqkkOpQdOOx6/eX7zZrS3gFaWCtWsMsJCDpCAFWukqOIUlxU6EUoH+S38d3eACX6tqRIJ8ksutVEOqfrjfdBFHZal0z8jagt6FMuDQCOn0KEa2oDOowwTSd0k4Onjj8BDq7BpETrGlNNNlu6PM01Kocuf91L5NJOynwkpohsr/OErIaM7Cm9EbUJr13GWMu3LRSNkgDy4GhMYC7vAaMPQSlN7XVIraQJX5XfCAkmYbjbTBOjGLohv4TVskoeoT/l99c+ybu9zX/Y5Vwq7vSf/QD0/qX56qH+AQS7/Rs4hwbVwwhg0BF+LZn/Sfg053+/IozZtoA2tT1zW0iodtu1Bp8NT9qlO065knXmraf7/fMXT+dkZE1axTnYakUXE2YkBErcw1678QptKzzn0VDGjt9c707GpItCjuYnDCMLtJkBmRoePHNX2ji5eQ+X0N21wgT4a0UrK94bmfHNIMQkOxXpX7PXCilC77aTP6fKcWoCATYh/BYeVcMgqzoRnk+KqePWOnbPBePSGtfzs/etiXLDV3jdkFF28vWSr7E+GotH4shizlx9i+gVsfgcAAP//U7tejYoEAAA=","creds":[

      {"user":"Administrator","pass":"password"}

      ]}'

      6. We see the error message below:
      < Date: Thu, 05 Oct 2017 22:40:36 GMT
      <
      {
      "requestID": "fda2c0a7-c619-4917-8ac7-5eb40ab593fb",
      "errors": [

      { "code": 4070, "msg": "Unable to decode prepared statement - cause: Unrecognizable prepared statement - cause: JSON unmarshalling error: GSI index id 31950c62cc72aca1 not found." }

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

      { "elapsedTime": "121.535µs", "executionTime": "116.684µs", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      Attachments

        Issue Links

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

          Activity

            People

              Donald.haggart Donald Haggart
              Prerna.Manaktala Prerna Manaktala (Inactive)
              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