Bug #527: server hangs up and refuses any connection

Started by PostgreSQL Bugs Listover 24 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

Alla El Gohary (allaelgohary@bftech.com.eg) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
server hangs up and refuses any connection

Long 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

Sample Code

No file was uploaded with this report

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #527: server hangs up and refuses any connection

pgsql-bugs@postgresql.org writes:

"sdec kernel table full" and the server hang up

Sounds to me like you're running out of kernel file-table slots or some
such. Please read the Postgres documentation on configuring kernel
resources.

regards, tom lane