Public bug reported:
Binary package hint: mysql-server-5.0
Hi,
after a period of time (depending on the usage / settings of max fds) i got the
following error:
mysqld[19434]: 100921 12:37:00 [ERROR] Error in accept: Too many open files
followed by:
mysqld[19434]: 100921 12:55:18 [ERROR] /usr/sbin/mysqld: Sort aborted
period.
First, i thought, this was due to to many requests at a time etc. but after
some time, i found the real problem (or at least what i think is the real
problem):
mysql-server left over some file descriptors from temporary tables. I see a lot
of them after some time:
lsof -n -u mysql | grep "(deleted)"
mysqld 4078 mysql 5u REG 0,20 0 2296091262
/dev/shm/ibNUtjVP (deleted)
mysqld 4078 mysql 6u REG 0,20 0 2296091263
/dev/shm/ibNx10ED (deleted)
mysqld 4078 mysql 7u REG 0,20 0 2296091264
/dev/shm/ibu2EIor (deleted)
mysqld 4078 mysql 8u REG 0,20 0 2296091295
/dev/shm/ibkBzLii (deleted)
mysqld 4078 mysql 12u REG 0,20 0 2296091302
/dev/shm/ibmZ6XDb (deleted)
mysqld 4078 mysql 27u REG 0,20 551196 2296100778
/dev/shm/MYrmT98Z (deleted)
mysqld 4078 mysql 346u REG 0,20 306240 2296096285
/dev/shm/MY7AdNjg (deleted)
mysqld 4078 mysql 351u REG 0,20 306228 2296096551
/dev/shm/MY367oH1 (deleted)
mysqld 4078 mysql 355u REG 0,20 306188 2296097302
/dev/shm/MYrTsJ7r (deleted)
mysqld 4078 mysql 356u REG 0,20 306216 2296096796
/dev/shm/MYDCukv6 (deleted)
mysqld 4078 mysql 365u REG 0,20 305988 2296104576
/dev/shm/MY4kY9Rx (deleted)
(after about 20 mins of uptime)
As you may see, the tmp directory points to /dev/shm to speed up
operation for temp tables.
I cannot verify which query exactly left over those fds because not
every query seem to be a problem, at least from what i could test...
As there is no other package for 08.04 LTS i would like to get this
fixed somewhere.
I've raised the limit for open fds to around 16k now, so the problem
only occours once a month... but this is still not accepable.
I'll provide as much information as possible, if needed.
Regards,
Sven
** Affects: mysql-dfsg-5.0 (Ubuntu)
Importance: Undecided
Status: New
--
mysql-server-5.0 on 08.04 LTS leaks filedescriptors
https://bugs.launchpad.net/bugs/644288
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
