maria-discuss team mailing list archive

[joao@xxxxxxxx]

Yep, without a way to reproduce the error it gets funnier :D

BUT, I remembered something, this is a new installation of an old server and I got some similar errors in the past. 

I saved the old configuration and I have this:

[mysqld]

open_files_limit = 24000


This new server have the default open_files_limit config.

 MariaDB [(none)]> show global variables like 'open%';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| open_files_limit | 1024  |
+------------------+-------+
1 row in set (0.01 sec)

MariaDB [(none)]> 

Maybe thats the problem... I think because the many files tokudb uses in my datadir. 

will increase and see what happens.. If you guys have any additional information that might help please let me know.

[root@db1 ~]# ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 15057
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 15057
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited


Thanks!

7 de novembro de 2015 às 18:05, "Colin Charles" <colin@xxxxxxxxxxx> escreveu:
>> On 8 Nov 2015, at 03:36, joao@xxxxxxxx wrote:
>> 
>> 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
> 
> Sometimes, is a problem ;-) Its much better if we can always repeat it
> 
> what is open_files_limit set to in my.cnf? also what is the ulimit set at?
> --
> Colin Charles, Chief Evangelist, MariaDB Corporation
> blog: http://bytebot.net/blog | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot