List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 27 1999 10:14pm
Subject:Table is full error message in /var/log/messages
View as plain text  
>>>>> "Chris" == Chris Unger <cunger@stripped> writes:

Chris> 	Below is a snippet from the /var/log/messages on a machine. I am hoping
Chris> this is a problem with mysql 3.22.20a and that the simple upgrade to 3.23.x
Chris> will solve the problem...

Chris> 	Any help would be greatly appreciated. If you need more info, please let
Chris> me know!


Chris> Mysqladmin reports this:
Chris> mysqladmin  Ver 7.8 Distrib 3.22.20a, for unknown-freebsd2.2.7 on i386


Chris> /var/log/messages:
Chris> [charm] ~/EUsers/testing> tail /var/log/messages
Chris> Jun 21 16:24:43 charm syslogd: /dev/ttyp0: Too many open files in system
Chris> Jun 21 16:24:43 charm last message repeated 3 times
Chris> Jun 21 16:24:43 charm /kernel: file: table is full
Chris> Jun 21 16:24:43 charm syslogd: /dev/ttyp0: Too many open files in system
Chris> Jun 21 16:24:43 charm last message repeated 3 times
Chris> Jun 21 16:24:43 charm /kernel: file: table is full
Chris> Jun 21 16:24:43 charm syslogd: /dev/ttyp0: Too many open files in system
Chris> Jun 21 16:24:43 charm last message repeated 3 times
Chris> Jun 21 16:24:43 charm /kernel: file: table is full
Chris> Jun 21 16:24:43 charm last message repeated 28 times

Hi!

The above means that your FreeBSD kernel doesn't have enough file
descriptors!

You need to recomile your kernel with more file descriptors!

You may also be able to do as root:

sysctl -w kern.maxfiles=100000 <-- can be any number you like
sysctl -w kern.maxfilesperproc=100000
ulimit -n 100000

Regards,
Monty
Thread
Table is full error message in /var/log/messagesChris Unger22 Jun
  • Re: Table is full error message in /var/log/messagesSasha Pachev22 Jun
  • Table is full error message in /var/log/messagesMichael Widenius28 Jun