Thread

1. postmaster crash

   jerome crouigneau <jerome_crouigneau@yahoo.fr> — 2001-02-27T14:41:00Z

   Hello,
   
   I've got a problem with the 7.0.2 version of Postgres.
   In production, the postmaster stops frequently alone
   (about one time per hour).
   Error message:
   postmaster: ServerLoop; select failed; No child
   processes
   
   And we have to restart it each hour.
   Any idea ?
   
   Thanks for your help
   
   Jérôme Crouigneau
   Medianet Technologies
   
   
   ___________________________________________________________
   Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, 
   Yahoo! Messenger : http://fr.messenger.yahoo.com
   
   

2. Re: postmaster crash

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-02-28T15:27:39Z

   =?iso-8859-1?q?jerome=20crouigneau?= <jerome_crouigneau@yahoo.fr> writes:
   > I've got a problem with the 7.0.2 version of Postgres.
   > In production, the postmaster stops frequently alone
   > (about one time per hour).
   > Error message:
   > postmaster: ServerLoop; select failed; No child
   > processes
   
   This is a known bug --- the postmaster's routine for catching ECHILD
   signals needs to save and restore errno.  We have not made a patch for
   7.0.*, but you could probably adapt the patch that was applied to
   current sources:
   
   http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/postmaster/postmaster.c.diff?r1=1.198&r2=1.199&f=c
   
   The changes in reaper() are probably the only critical part.
   
   			regards, tom lane