Bug 32418

Summary:	kernel table full
Product:	Base System	Reporter:	Alla El Gohary <allaelgohary>
Component:	kern	Assignee:	silby
Status:	Closed FIXED
Severity:	Affects Only Me
Priority:	Normal
Version:	Unspecified
Hardware:	Any
OS:	Any

Description Alla El Gohary 2001-12-01 00:40:01 UTC

dear pgsql-bugs
i'm running postgresql 7.1.2 on freebsd4.3 my application consists of several components running on win32s clients some of the modules interact with each other on the network using udp and tcp packets i have nearly 14 clients running on the server i mentioned before on a workgroup network using a 3com 10/100 switch
while the traffic is high i mean all the clients are interacting together the server hangs up and all the connections to the server stops
even pinging doesn't reply.
at first i switched to freebsd 3.1 i thought its something related to freebsd but again the same thing happened but this time a message poped up on the server
"sdec kernel table full" and the server hang up
when i restart the server everything comes back to normal
i'm connecting to the server from the win32s clients through postgresql ODBC driver v7
i run the postmaster using /usr/local/pgsql/bin/postmaster -i -S -o -F
please if there's a solution to that reply me back ASAP

How-To-Repeat: overload on the clients

Comment 1 Aleksandr A Babaylov 2001-12-01 04:34:07 UTC

Alla El Gohary writes:
> 
> >Number:         32418
> >Category:       kern
> >Synopsis:       kernel table full
> >Confidential:   no
> >Severity:       critical
> >Priority:       high
> >Responsible:    freebsd-bugs
> >State:          open
> >Quarter:        
> >Keywords:       
> >Date-Required:
> >Class:          sw-bug
> >Submitter-Id:   current-users
> >Arrival-Date:   Fri Nov 30 16:40:01 PST 2001
> >Closed-Date:
> >Last-Modified:
> >Originator:     Alla El Gohary
> >Release:        4.3 ,3.1
> >Organization:
> Back&Front Technologies
> >Environment:
> >Description:
> dear pgsql-bugs
> i'm running postgresql 7.1.2 on freebsd4.3 my application consists of several components running on win32s clients some of the modules interact with each other on the network using udp and tcp packets i have nearly 14 clients running on the server i mentioned before on a workgroup network using a 3com 10/100 switch
> while the traffic is high i mean all the clients are interacting together the server hangs up and all the connections to the server stops
> even pinging doesn't reply.
> at first i switched to freebsd 3.1 i thought its something related to freebsd but again the same thing happened but this time a message poped up on the server
> "sdec kernel table full" and the server hang up
> when i restart the server everything comes back to normal
> i'm connecting to the server from the win32s clients through postgresql ODBC driver v7
> i run the postmaster using /usr/local/pgsql/bin/postmaster -i -S -o -F
> please if there's a solution to that reply me back ASAP
Please add  -l /some_log_file
to postmaster's flags and look at log file after hang

-- 
@BABOLO      http://links.ru/

Comment 2 silby freebsd_committer

2002-02-24 07:49:14 UTC

State Changed
From-To: open->feedback

This looks like you are just running out of processes; 
how many megs of ram does this system have, and what 
do you have maxusers set to?

Comment 3 silby freebsd_committer

2002-02-24 07:56:13 UTC

Responsible Changed
From-To: freebsd-bugs->silby

I'm assigning this to myself as a reminder for me to implement 
rate-limited, informative warnings about the system being out 
of processes.

Comment 4 silby freebsd_committer

2003-06-26 05:17:06 UTC

State Changed
From-To: feedback->closed

The changes inspired by this have been committed.