Most likely it is that ulimit is too low.  Try the instructions in this blog post (not mine): 

https://ma.ttias.be/increase-open-files-limit-in-mariadb-on-centos-7-with-systemd/

Sent from my iPhone

On Nov 7, 2015, at 12:36 PM, joao@7lan.net wrote:

Hi List,

Sometimes, my mysqld daemon begin to consumes 100% the connection to the server gets unstable and I get flooded in the mysql error log with these messages:

Nov  4 06:17:01 db1 mysqld: 2015-11-04  6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor
Nov  4 06:17:01 db1 mysqld: 2015-11-04  6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor
Nov  4 06:17:01 db1 mysqld: 2015-11-04  6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor
Nov  4 06:17:01 db1 mysqld: 2015-11-04  6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor
Nov  4 06:17:01 db1 mysqld: 2015-11-04  6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor
Nov  4 06:17:01 db1 mysqld: 2015-11-04  6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor

it only stops when I restart the daemon, no query is shown in "show full processlist".

Maybe some kernel adjustment? Any ideia? 

Running centos 7 at the lastest version.


[root@db1 scripts]# yum -y update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: ftpmirror.your.org
 * epel: mirror.nexcess.net
 * extras: ftpmirror.your.org
 * updates: mirrors.lga7.us.voxel.net
No packages marked for update
[root@db1 scripts]# rpm -qa|grep -i MariaDB
MariaDB-shared-10.1.8-1.el7.centos.x86_64
MariaDB-client-10.1.8-1.el7.centos.x86_64
MariaDB-common-10.1.8-1.el7.centos.x86_64
MariaDB-server-10.1.8-1.el7.centos.x86_64


Thanks!

João Reis. 
 
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp