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 ----- From: "Maxim V. Presnyakov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > --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 request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
