I'm am getting this occasionally on our VM server, generally during a MySQL import from the CLI. Unfortunately, as the server is in production it then causes all the sites to go off-line and mysql server must be restarted.
Here's the error when performing the MySQL import: ERROR 23 (HY000) at line 2008: Out of resources when opening file './ae/' (Errcode: 24)
And the error in /var/log/mysql.log 120806 17:46:18 [Note] Event Scheduler: Loaded 0 events 120806 17:46:18 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.61' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 120830 16:20:26 [ERROR] Error in accept: Too many open files
Do you know a simple fix? I'm just concerned that this may happen when no one is around to restart mysql and cause the service to be offline for longer than 2 mins.