You have been subscribed to a public bug by Robie Basak (racb):
After upgrading to 15.04 mysql cannot set the file limit and so it
doesn't work well.
/var/log/mysql/error.log shows the following:
[Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested
5000)
[Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
[ERROR] /usr/sbin/mysqld: Can't open file: ... (errno: 24 - Too many open files)
The issue looks to be related to the recent switch to systemd indeed if
I start using upstart everything work fine.
I found out similar issues reported on Debian and the general suggestion
is to add following line to the `mysqld.service` anyway this file is not
present on my installation :
LimitNOFILE=infinity
LimitMEMLOCK=infinity
Other distro stores this file in `/usr/lib/systemd/system/mysqld.service`
I'm not sure how Ubuntu is managing this, maybe with file in dir /etc/default/ ?
I have also tried adding following lines in /etc/security/limits.conf,
but the problem persist:
mysql soft nofile 65535
mysql hard nofile 65535
ProblemType: Bug
DistroRelease: Ubuntu 15.04
Package: mysql-server (not installed)
Uname: Linux 3.19.2-031902-generic x86_64
ApportVersion: 2.16.2-0ubuntu4
Architecture: amd64
CurrentDesktop: Unity
Date: Sat Mar 21 10:17:00 2015
InstallationDate: Installed on 2014-03-10 (375 days ago)
InstallationMedia: Ubuntu 14.04 LTS "Trusty Tahr" - Alpha amd64 (20140309)
SourcePackage: mysql-5.5
UpgradeStatus: Upgraded to vivid on 2015-03-20 (0 days ago)
** Affects: mysql-5.6 (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug mysql-5.6-transition mysqld systemd-boot vivid
--
mysqld: errno: 24 - Too many open files
https://bugs.launchpad.net/bugs/1434758
You received this bug notification because you are a member of Ubuntu Server
Team, which is subscribed to the bug report.
--
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
