Skip to content
Advertisement

How to get rid of MySQL error ‘Prepared statement needs to be re-prepared’

I’ve rewritten my site php-code and added MySQL Stored Procedures.

In my local version everything works fine but after I uploaded my site to hosting server I’m constantly getting fatal error ‘Prepared statement needs to be re-prepared’.

Sometimes page loads, sometimes loading fails and I see this error. What’s that?

Advertisement

Answer

This is a possibility: MySQL bug #42041

They suggest upping the value of table_definition_cache.

You can read about re-preparation in the MySQL docs.

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement