mysql_pconnect(): send of 5 bytes failed with errno=32 Broken pipe

Question

I've been using the same DB abstraction library for years. But today it started writing these Notice (8) messages in my log.

The application is working correctly but every time a script connects to the DB the same notice is logged.

I cannot think what might have changed. This is happening on my local dev machine.

OS X 10.6.2
PHP 5.3.0 (cli) 
mysql Ver 14.12 Distrib 5.0.87
mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $

Answer 1

If someone is struggling with this issue, here is the fix:

Try changing/setting up wait_timeout in your mysql my.cnf config file:

wait_timeout=3600

This config file is located in the /etc/mysql/my.cnf (Ubuntu/Debian) and /usr/local/mysql/my.cnf (OSX).

Restart mysql server and it should work.