Bad file descriptor

Bad file descriptor

Post by Ken Menze » Wed, 27 Feb 2002 23:14:34



Hi Maxim,
   This is an error from the operating system and might be more
appropriate on freebsd-stable mailing list.  There are many users of
FreeBSD on this list (including me).  However hopefully someone will
know the answer.  I am going to try and guess that kern.maxfiles=65535
might not be allowed.  Could you try reducing this to say 65000?
Sometimes these high numbers like 65535 are also error codes! (-1
etc).  What is kern.openfiles normally at? I don't normally have
anything with that number of tables open.

I am not sure why you have it set that high anyway.  You must really
have many many tables and also be running something else (like apache)
on the same server.  There may be a bug in freebsd with that many
files open, although I have not heard of one.

I hope this helps,
Ken

----- Original Message -----


Sent: Tuesday, February 26, 2002 7:33 AM
Subject: Bad file descriptor

> Sometimes I have in my .err file Error in accept: Bad file
descriptor
> FreeBSD 4.4, mysql 3.23.47
> startup script:
> -O key_buffer=256M -O table_cache=18000 -O sort_buffer=32M -O
> record_buffer=16M   --log-slow-queries -O long_query_time=180 -O
> max_connect_errors=50 -O back_log=500 --warnings -O

max_allowed_packet=16M
Quote:> --skip-locking  --skip-thread-priority -O wait_timeout=120
> -Ointeractive_timeout=120 -O

flush_time=900  --open-files=30000 -Oquery_buffer_size=17M -O
> thread_cache_size=32

> In my kernel vars:
> /sbin/sysctl -w net.inet.ip.forwarding=1
> /sbin/sysctl -w net.inet.tcp.always_keepalive=1
> /sbin/sysctl -w kern.ipc.somaxconn=4096
> /sbin/sysctl -w net.inet.tcp.delayed_ack=0
> /sbin/sysctl -w net.inet.ip.portrange.last=30000
> /sbin/sysctl -w kern.maxfiles=65535
> /sbin/sysctl -w vfs.vmiodirenable=1
> /sbin/sysctl -w kern.maxfilesperproc=50000
> /sbin/sysctl -w kern.ipc.max_datalen=156
> /sbin/sysctl -w net.inet.tcp.sendspace=32768
> /sbin/sysctl -w net.inet.tcp.recvspace=32768
> /sbin/sysctl -w vfs.maxmallocbufspace=3184230
> /sbin/sysctl -w net.inet.ip.intr_queue_maxlen=200

> What can I do?

> --------------------------------------------------------------------
-
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)


> To unsubscribe, e-mail


Quote:> Trouble unsubscribing? Try:

http://lists.mysql.com/php/unsubscribe.php

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php