Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0, 10.1, 10.1.44, 10.2, 10.3, 10.4
-
None
-
Debian Stretch on AMD64 and ARM64
Description
We have a system that makes extensive use of stored routines. For some time we have seen occasional sqlState 42000 "FUNCTION <function-name> does not exist" exceptions on our production servers. It look a while to figure out a set of use cases that reliably reproduced the problem. However, we have now done that and it appears that the point at which the number of entries in the sp cache exceeds the 'stored_program_cache' configuration value (which we had set to the default of 256), subsequent CALL operations on the connection in question fail with "FUNCTION <function-name> does not exist". This situation remains until either the connection is closed and reopened or something causes the sp cache "version" to be incremented.
For the time being we will simply increase the value of 'stored_program_cache' to avoid hitting the limit. However, presumably the server should continue to operate as normal in the event where the cache limit is reached.