Gday All,

Ive noticed recently that when i do my nightly mysqldump, im getting lots of problems. Namely that a lot of services stop responding. Most of my services do rely on mysql, so im thinking its mysql related at the moment, but im willing to consider other things..

Looking through the logs arround that time i have this

May 27 08:19:44 broken mysqld[4109]: 090527  8:19:44 [ERROR] Error in accept: Too many open files
May 28 08:10:04 broken mysqld[4109]: 090528  8:10:02 [ERROR] Error in accept: Too many open files
May 28 08:10:18 broken mysqld[4109]: 090528  8:10:18 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:18 broken mysqld[4109]: 090528  8:10:18 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:20 broken mysqld[4109]: 090528  8:10:20 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:10:20 broken mysqld[4109]: 090528  8:10:20 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:21 broken mysqld[4109]: 090528  8:10:21 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:21 broken mysqld[4109]: 090528  8:10:21 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:22 broken mysqld[4109]: 090528  8:10:22 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:22 broken mysqld[4109]: 090528  8:10:22 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:23 broken mysqld[4109]: 090528  8:10:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:23 broken mysqld[4109]: 090528  8:10:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:24 broken mysqld[4109]: 090528  8:10:24 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:24 broken mysqld[4109]: 090528  8:10:24 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:25 broken mysqld[4109]: 090528  8:10:25 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:25 broken mysqld[4109]: 090528  8:10:25 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:26 broken mysqld[4109]: 090528  8:10:26 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:26 broken mysqld[4109]: 090528  8:10:26 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:27 broken mysqld[4109]: 090528  8:10:27 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:27 broken mysqld[4109]: 090528  8:10:27 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:28 broken mysqld[4109]: 090528  8:10:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:28 broken mysqld[4109]: 090528  8:10:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:29 broken mysqld[4109]: 090528  8:10:29 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:29 broken mysqld[4109]: 090528  8:10:29 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:30 broken mysqld[4109]: 090528  8:10:30 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:30 broken mysqld[4109]: 090528  8:10:30 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:31 broken mysqld[4109]: 090528  8:10:31 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:31 broken mysqld[4109]: 090528  8:10:31 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:37 broken mysqld[4109]: 090528  8:10:37 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:37 broken mysqld[4109]: 090528  8:10:37 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:41 broken mysqld[4109]: 090528  8:10:41 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:41 broken mysqld[4109]: 090528  8:10:41 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:43 broken mysqld[4109]: 090528  8:10:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:43 broken mysqld[4109]: 090528  8:10:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:11:09 broken mysqld[4109]: 090528  8:11:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:11:09 broken mysqld[4109]: 090528  8:11:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:11:27 broken mysqld[4109]: 090528  8:11:27 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:11:39 broken mysqld[4109]: 090528  8:11:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:11:39 broken mysqld[4109]: 090528  8:11:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:11:41 broken mysqld[4109]: 090528  8:11:41 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:11:41 broken mysqld[4109]: 090528  8:11:41 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:11:56 broken mysqld[4109]: 090528  8:11:56 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:11:56 broken mysqld[4109]: 090528  8:11:56 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:12:33 broken mysqld[4109]: 090528  8:12:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:12:33 broken mysqld[4109]: 090528  8:12:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:12:43 broken mysqld[4109]: 090528  8:12:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:12:43 broken mysqld[4109]: 090528  8:12:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:13:28 broken mysqld[4109]: 090528  8:13:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:13:28 broken mysqld[4109]: 090528  8:13:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:13:39 broken mysqld[4109]: 090528  8:13:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:13:39 broken mysqld[4109]: 090528  8:13:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:14:59 broken mysqld[4109]: 090528  8:14:59 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:14:59 broken mysqld[4109]: 090528  8:14:59 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:15:10 broken mysqld[4109]: 090528  8:15:10 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528  8:17:48 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528  8:17:48 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528  8:17:49 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528  8:17:49 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528  8:17:49 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528  8:17:49 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:17:50 broken mysqld[4109]: 090528  8:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:17:50 broken mysqld[4109]: 090528  8:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:17:59 broken mysqld[4109]: 090528  8:17:59 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:17:59 broken mysqld[4109]: 090528  8:17:59 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:00 broken mysqld[4109]: 090528  8:18:00 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:01 broken mysqld[4109]: 090528  8:18:01 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:01 broken mysqld[4109]: 090528  8:18:01 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:09 broken mysqld[4109]: 090528  8:18:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:18:09 broken mysqld[4109]: 090528  8:18:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:09 broken mysqld[4109]: 090528  8:18:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:18:09 broken mysqld[4109]: 090528  8:18:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:19:01 broken mysqld[4109]: 090528  8:19:01 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:19:01 broken mysqld[4109]: 090528  8:19:01 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:19:08 broken mysqld[4109]: 090528  8:19:08 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:19:08 broken mysqld[4109]: 090528  8:19:08 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:20:06 broken mysqld[4109]: 090528  8:20:06 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:20:06 broken mysqld[4109]: 090528  8:20:06 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:00 broken mysqld[4109]: 090528  8:22:00 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:22:00 broken mysqld[4109]: 090528  8:22:00 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:15 broken mysqld[4109]: 090528  8:22:15 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:22:15 broken mysqld[4109]: 090528  8:22:15 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:16 broken mysqld[4109]: 090528  8:22:16 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:17 broken mysqld[4109]: 090528  8:22:17 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:18 broken mysqld[4109]: 090528  8:22:18 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:18 broken mysqld[4109]: 090528  8:22:18 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:24 broken mysqld[4109]: 090528  8:22:24 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:22:24 broken mysqld[4109]: 090528  8:22:24 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:38 broken mysqld[4109]: 090528  8:22:38 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:22:38 broken mysqld[4109]: 090528  8:22:38 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:22:39 broken mysqld[4109]: 090528  8:22:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:22:39 broken mysqld[4109]: 090528  8:22:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:22:40 broken mysqld[4109]: 090528  8:22:40 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:09:33 broken mysqld[4109]: 090528 22:09:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:09:33 broken mysqld[4109]: 090528 22:09:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:09:54 broken mysqld[4109]: 090528 22:09:54 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:09:54 broken mysqld[4109]: 090528 22:09:54 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:09:54 broken mysqld[4109]: 090528 22:09:54 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:09:54 broken mysqld[4109]: 090528 22:09:54 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:10:17 broken mysqld[4109]: 090528 22:10:17 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:10:17 broken mysqld[4109]: 090528 22:10:17 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:14:28 broken mysqld[4109]: 090528 22:14:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:14:28 broken mysqld[4109]: 090528 22:14:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:14:33 broken mysqld[4109]: 090528 22:14:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:14:33 broken mysqld[4109]: 090528 22:14:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:14:43 broken mysqld[4109]: 090528 22:14:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:14:43 broken mysqld[4109]: 090528 22:14:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:17:23 broken mysqld[4109]: 090528 22:17:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:17:23 broken mysqld[4109]: 090528 22:17:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:17:23 broken mysqld[4109]: 090528 22:17:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:17:23 broken mysqld[4109]: 090528 22:17:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:17:42 broken mysqld[4109]: 090528 22:17:42 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:17:42 broken mysqld[4109]: 090528 22:17:42 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:17:45 broken mysqld[4109]: 090528 22:17:45 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:17:45 broken mysqld[4109]: 090528 22:17:45 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:19:55 broken mysqld[4109]: 090528 22:19:55 [ERROR] Error in accept: Too many open files
broken:/var/log# 

basicly mysql ranting that it has too many open files.. but i dont know why, nor how to fix it.. Any thoughts? I dont know weather its related but a mysql update did come down the other day aarround the same time it happened.

For reference, running Debian Etch.

Any help/ideas would be muchly appreciated.

_________________
ServerAdmin - www.our-lan.com
"Diplomacy is the art of saying nice doggy whilst looking for a really big stick"
"In my experiece, any attempt to make any system idiot proof will only challenge God to make a better idiot"

In your my.cnf file use 'open_files_limit' to raise the limit on open files. I think the default is 1024, so you might try something like:

open_files_limit = 2048

Don't forget to restart mysqld....