← Back to team overview

touch-packages team mailing list archive

[Bug 1434758] [NEW] mysqld: errno: 24 - Too many open files

 

Public bug reported:

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.5 (Ubuntu)
     Importance: Undecided
         Status: New

** Affects: systemd (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug mysqld systemd-boot vivid

** Also affects: systemd (Ubuntu)
   Importance: Undecided
       Status: New

** Summary changed:

- mysqld & systemd - errno: 24 - Too many open files
+ mysql: errno: 24 - Too many open files

** Summary changed:

- mysql: errno: 24 - Too many open files
+ mysqld: errno: 24 - Too many open files

** Tags added: systemd-boot

** Description changed:

  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)

-- 
You received this bug notification because you are a member of Ubuntu
Touch seeded packages, which is subscribed to systemd in Ubuntu.
https://bugs.launchpad.net/bugs/1434758

Title:
  mysqld: errno: 24 - Too many open files

Status in mysql-5.5 package in Ubuntu:
  New
Status in systemd package in Ubuntu:
  New

Bug 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

  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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1434758/+subscriptions


Follow ups

References