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

• 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.