maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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@xxxxxxxx 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp