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

Misleading error messages returned on deleted buckets+prepared stmts

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • 4.5.0
    • 4.0.0
    • query
    • Security Level: Public
    • None
    • Untriaged
    • Unknown

    Description

      I noticed this while running prepared automation new tests.

      1.Create bucket+index
      2. create prepared stmt
      3. execute prepared stmt – works as expected.

      4. Delete bucket
      5. Create bucket + index
      6. execute prepared stmt – Fails with error on Node being unavailable, while infact the prepared stmt is no longer available? or not relevant anymore?

      Here is the error I see

      Note: My index node, bucket, indexes everything is in place, My guess is the prepared stmt is not found and hence the error.

      Ketakis-MacBook-Pro:testrunner ketaki$ curl -v 10.6.2.164:8093/query/service -u Administrator:password -d 'prepared="kg123"'
      * About to connect() to 10.6.2.164 port 8093 (#0)
      *   Trying 10.6.2.164...
      * Adding handle: conn: 0x7fbc81004000
      * Adding handle: send: 0
      * Adding handle: recv: 0
      * Curl_addHandleToPipeline: length: 1
      * - Conn 0 (0x7fbc81004000) send_pipe: 1, recv_pipe: 0
      * Connected to 10.6.2.164 (10.6.2.164) port 8093 (#0)
      * Server auth using Basic with user 'Administrator'
      > POST /query/service HTTP/1.1
      > Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==
      > User-Agent: curl/7.30.0
      > Host: 10.6.2.164:8093
      > Accept: */*
      > Content-Length: 16
      > Content-Type: application/x-www-form-urlencoded
      > 
      * upload completely sent off: 16 out of 16 bytes
      < HTTP/1.1 200 OK
      < Content-Length: 498
      < Content-Type: application/json; version=1.0.0
      < Date: Fri, 28 Aug 2015 19:14:27 GMT
      < 
      {
          "requestID": "530f08f3-9196-49f4-84be-9e2ea15f0487",
          "signature": {
              "*": "*"
          },
          "results": [
          ],
          "errors": [
              {
                  "code": 5000,
                  "msg": "index deleted or node hosting the index is down - cause: queryport.indexNotFound"
              }
          ],
          "status": "errors",
          "metrics": {
              "elapsedTime": "23.982625ms",
              "executionTime": "23.83809ms",
              "resultCount": 0,
              "resultSize": 0,
              "errorCount": 1
          }
      }
      

      Attachments

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

        Activity

          People

            Sitaram.Vemulapalli Sitaram Vemulapalli
            ketaki Ketaki Gangal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty