postgres (zombie)

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: postgres (zombie)
Date: 1999-01-25 11:02:10
Message-ID: 36AC4F32.6B757A22@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I am sending this mail on hackers list because the bug list seems to be
dissapeared !

Something strange start happening on my PostgreSQL server :

Linux RedHat 5.2 i386 Pentium machine 64 Mb RAM
PostgreSQL 6.4.2 official release

there are a number of maximum 6 users working simultaneously but not so
hard on the database that isn't so big (2 Mb dumped).
the clients are Tcl/Tk programs. 3 clients are accesing server from a
local network, 3 or 4 clients are accesing server through a serial 115
kb line through a CISCO.

Till now, everything went ok, but sometimes, in the last few days, I
found some postgres (<zombie>) processes and when every client is
logging out, another postgres <zombie> process appears. I had to kill
-SIGTERM the master, wait for 5 or 6 seconds and then restart it again.

When 1 postgres <zombie> process is appearing, the current working
clients can work ahead, no problem at all. But newer connections aren't
accepted.

=======
I am not sure, but I think that the serial line is broked sometimes and
the client-server communication has small interrupts.
Could it be possible that these problems hang up postgresql so bad ?

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

Browse pgsql-hackers by date

  From Date Subject
Next Message Cary O'Brien 1999-01-25 15:05:00 Re: [HACKERS] Postgres Speed or lack thereof
Previous Message Peter T Mount 1999-01-25 10:22:56 Problem with 6.5 and tables >2Gb