File: Table is Full

[sycncs]

I have this error (File: Table is full). When I checked, I could not find anything wrong. But it is affecting databases...can someone advice me? Thanks in advance.

[Veron Le]

Can you try to recycle power, It seems that too many user login at this time.

[avsrini]

Hi Lauren,
You have to increase the no. of open file (nfile) in kernel.

schedule an outage and do this, modifing the kernel requires a reboot.

Srini.

[avsrini]

Hi Lauren,
Your system is exceeding the no. of open file size. You have to increase the nfiles parameter in your kernel.


give sar -v 2 3 and check the file-sz column.
first no. shows the current no of open files and the second no. shows the maximum configured open files.

Also you can try increasing the MAXFILES parameters.

[Rajeev Shukla]

Yes it seems that the limit for the number of files opened has exceeded the value set by OS in the kernel. You need to increase the nfile in your kernel.


Rajeev

[Michael Tully]

You can also utilise 'glance' to see what is being used.

(/opt/perf/bin/glance) if it is installed.

Using kmtune will give you the current information:
# kmtune -l -q nproc
# kmtune -l -q maxusers

You'll need to increase most likely both parameters, which will mean a new kernel and a reboot.

[sycncs]

Thank you very very much, folks!! I am so impressed and touched by the strong close ties we have here.
I will take your valuable advice now and rectify the problem.

Thanks very much again! Cheers.

[Brian Watkins · Accepted solution]

This has always worked for me:

1. Start glance
2. Look at the System Tables Report (shortcut to this is the "t" key)

Are any of these paramters at 80% utilization or higher? If so, you should consider making a backup of your current kernel and increasing the affected values by at least 10 or 20%.

After the reboot, repeat the steps above to see what the utilization levels are, and continue to monitor them, especially during peak processing hours when the errors have been happening.

Hope this helps!

[sycncs]

Hi Brian

Thank you very much.
Indeed it works. :-)