Can’t create more than max_prepared_stmt_count statements

I kept seeing this error in the logs for a script I wrote which uses prepared statements:

Error Code: 1461
Can’t create more than max_prepared_stmt_count statements

I was a bit perplexed because I had not run into this before. Fortunately, someone else has already blogged about it for me:

https://iammysql.wordpress.com/2012/05/04/cant-create-more-than-max_prepared_stmt_count-statements/

The client for this database server had added new code which was not closing the prepared statements. After I informed the client, he fixed it and the problem went away.