Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-6384

[MB-38046] "No such prepared statement" : error code 4040 while/on upgrading to 6.5.0

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.5 Milestone 1
    • Component/s: query
    • Labels:
    • Sprint:
      DOC-2020-S4-Mar08
    • Story Points:
      1

      Description

       

      • Client Side Workarounds (for SDK Java 2.x)
      1. Restart the application server after the server upgrade .This will implicitly clear the client cache, leading it to again prepare
      2.  Change the client code - if they hit a 4040 they clean the cache invalidateQueryCache()and retry. Works only for Java

       

      • Server Side Workarounds

                  Once they upgrade the 1st node (key value service node or any other node) they should :

      1. Increase the prepared statement cache size Settings->Query Settings-> Advanced Query settings-> Prepared Limit to 65K AND
      2. Change N1QL Feature controller under “Settings->Query Settings-> Advanced Query settings" to 8.

       

      This will persist and get reflected for future query service nodes being upgraded and "encoded_plan" will be honored, if needed.

        Attachments

          Issue Links

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

            Activity

            There are no comments yet on this issue.

              People

              Assignee:
              simon.dew Simon Dew
              Reporter:
              wayne Wayne Siu
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Gerrit Reviews

                  There are no open Gerrit changes

                    PagerDuty