FYI, we moved our users to our other master (duel master setup) sever (01) and it is now exhibiting the exact same symptoms. doesn't use the parameters defined in /etc/security/limits.conf, so when you launch mysql through the service command (and so, under upstart), it overrides those defined limits and uses the default 1024.
It (01) had the same exact configuration as this failing server (02) and is our fail over master should this one (02) die. The solution is to modify the file that defines the upstart service, it is located in /etc/init/and add the following lines This worked for me on Ubuntu 15.10.
Ubuntu: 12.04 LTS (Linux mysql02 3.2.0-40-generic #64-Ubuntu SMP Mon Mar 25 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux) My SQL: Ubuntu distro 5.5.31 Apparmor: REMOVED!
Server has been running rock solid for over a year. An update has caused the problem and we cannot figure it out what it is.
Consequently, you need to reconfigure your SAS installation to be able to use Java 7.
We have even tried to roll back to My SQL 5.5.30 but with no luck. My SQL error log entries: 130430 [ERROR] Error in accept: Too many open files 130430 [ERROR] /usr/sbin/mysqld: Can't open file: './eci_elite_test/fclvod.frm' (errno: 24) 130430 [ERROR] /usr/sbin/mysqld: Can't open file: './eci_elite_test/fcnote.frm' (errno: 24) 130430 [ERROR] /usr/sbin/mysqld: Can't open file: './eci_elite_test/ffcont.frm' (errno: 24) 130430 [ERROR] /usr/sbin/mysqld: Can't open file: './eci_elite_test/ffcontv.frm' (errno: 24) 130430 [ERROR] /usr/sbin/mysqld: Can't open file: './eci_elite_test/ffnote.frm' (errno: 24) 130430 [ERROR] /usr/sbin/mysqld: Can't open file: './eci_elite_test/frcfcl.frm' (errno: 24) yes, we have restarted My SQL every time we make changes.We have one table that is being reported as missing (and it is for some reason): 30430 Inno DB: Error: trying to open a table, but could not Inno DB: open the tablespace file './oti_lw_prod/apinvoice_charges.ibd'!Important: Before starting this process, read through the entire note so that you are aware of all preliminary requirements and potential issues as well as optional ways to accomplish these tasks.9.3 TS1M2." This section explains how to download and then install a supported JRE 7 from the Oracle website.
After upgrading packages got tons of ' Can't open file' error messages, which broke all my sites :(...
Thanks a million for saving me a lot of headache and time.