Re: [HACKERS] posmaster failed under high load

On Wed, 5 May 1999, Bruce Momjian wrote:

> Date: Wed, 5 May 1999 11:17:27 -0400 (EDT)
> From: Bruce Momjian <maillist@candle.pha.pa.us>
> To: Tom Lane <tgl@sss.pgh.pa.us>
> Cc: Oleg Bartunov <oleg@sai.msu.su>, hackers@postgreSQL.org
> Subject: Re: [HACKERS] posmaster failed under high load
> 
> > Oleg Bartunov <oleg@sai.msu.su> writes:
> > > That's why I noticed 10 or more (postmaster) processes, which eventually
> > > gone after 30-40 minutes.
> > 
> > Could those be new backends that have been forked off the main
> > postmaster, but haven't yet gotten around to changing their ps info?
> > I'm not sure what would block a new backend for many minutes before
> > it did that, however.  Can you attach to one of these processes with
> > a debugger and get a backtrace to show what it's doing?
> 
> I can't imagine what they would be waiting for, but it seems like a good
> guess.
> 

After more than 1 hour postmaster processes still running   76  ?  S    0:00 postmaster -i -B 1024 -S
-D/usr/local/pgsql/data/-o -Fe  651  ?  SW   0:00 (postmaster) 693  ?  SW   0:00 (postmaster) 694  ?  SW   0:00
(postmaster)698  ?  S    0:00 /usr/local/pgsql/bin/postgres localhost httpd apod idle  699  ?  SW   0:00 (postmaster)
700 ?  S    0:00 /usr/local/pgsql/bin/postgres localhost httpd apod idle  701  ?  SW   0:00 (postmaster) 702  ?  S
0:00/usr/local/pgsql/bin/postgres localhost httpd apod idle 
 
18:48[om]:/usr/local/etc/httpd/conf>psg post
  76  ?  S    0:00 postmaster -i -B 1024 -S -D/usr/local/pgsql/data/ -o -Fe  651  ?  SW   0:00 (postmaster) 693  ?  SW
0:00 (postmaster) 694  ?  SW   0:00 (postmaster) 698  ?  S    0:00 /usr/local/pgsql/bin/postgres localhost httpd apod
idle 699  ?  SW   0:00 (postmaster) 700  ?  S    0:00 /usr/local/pgsql/bin/postgres localhost httpd apod idle  701  ?
S   0:00 /usr/local/pgsql/bin/postgres localhost httpd apod idle  702  ?  S    0:00 /usr/local/pgsql/bin/postgres
localhosthttpd apod idle 
 
19:30[om]:/usr/local/etc/httpd/conf>

It's interesting, that process with pid 701 migrates from 
(postmaster) to postgres with normal ps output !
It seems postgres lives with his own life :-)

regards,    Oleg

> 
> -- 
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83