Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21859

FUNCTION xxx does not exist error when stored procedure cache limit is reached

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.0, 10.1, 10.1.44, 10.2, 10.3, 10.4
    • 10.4
    • Stored routines
    • 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.

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            joebr Joe Branton
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.