2015-03-21 02:25:58 |
postadelmaga |
bug |
|
|
added bug |
2015-03-21 02:27:58 |
postadelmaga |
bug task added |
|
systemd (Ubuntu) |
|
2015-03-21 02:28:29 |
postadelmaga |
summary |
mysqld & systemd - errno: 24 - Too many open files |
mysql: errno: 24 - Too many open files |
|
2015-03-21 02:28:37 |
postadelmaga |
summary |
mysql: errno: 24 - Too many open files |
mysqld: errno: 24 - Too many open files |
|
2015-03-21 02:28:56 |
postadelmaga |
tags |
amd64 apport-bug mysqld vivid |
amd64 apport-bug mysqld systemd-boot vivid |
|
2015-03-21 02:32:49 |
postadelmaga |
description |
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
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) |
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) |
|
2015-03-23 08:44:18 |
postadelmaga |
mysql-5.5 (Ubuntu): status |
New |
Confirmed |
|
2015-03-23 08:44:39 |
postadelmaga |
mysql-5.5 (Ubuntu): status |
Confirmed |
New |
|
2015-03-23 09:19:25 |
postadelmaga |
affects |
mysql-5.5 (Ubuntu) |
mysql-5.6 (Ubuntu) |
|
2015-03-24 07:46:39 |
Didier Roche-Tolomelli |
bug task deleted |
systemd (Ubuntu) |
|
|
2015-03-24 17:47:27 |
Robie Basak |
tags |
amd64 apport-bug mysqld systemd-boot vivid |
amd64 apport-bug mysql-5.6-transition mysqld systemd-boot vivid |
|
2015-03-24 17:47:35 |
Robie Basak |
mysql-5.6 (Ubuntu): milestone |
|
ubuntu-15.04 |
|
2015-03-24 17:47:40 |
Robie Basak |
bug |
|
|
added subscriber Robie Basak |
2015-03-24 17:47:45 |
Robie Basak |
bug |
|
|
added subscriber Ubuntu Server Team |
2015-03-28 03:08:24 |
postadelmaga |
bug task added |
|
systemd (Ubuntu) |
|
2015-03-28 07:22:28 |
Martin Pitt |
bug task deleted |
systemd (Ubuntu) |
|
|
2015-03-30 11:54:12 |
Robie Basak |
mysql-5.6 (Ubuntu): importance |
Undecided |
Medium |
|
2015-03-30 11:54:17 |
Robie Basak |
mysql-5.6 (Ubuntu): status |
New |
Triaged |
|
2015-04-01 09:30:40 |
Robie Basak |
bug task added |
|
ubuntu-release-notes |
|
2015-04-01 09:30:47 |
Robie Basak |
mysql-5.6 (Ubuntu): status |
Triaged |
Invalid |
|
2015-04-20 08:47:42 |
Martin Pitt |
mysql-5.6 (Ubuntu): milestone |
ubuntu-15.04 |
|
|
2015-04-23 08:52:59 |
Robie Basak |
ubuntu-release-notes: status |
New |
Fix Released |
|
2015-12-12 21:58:58 |
viegelinsch |
bug |
|
|
added subscriber viegelinsch |