postmaster crash

Started by jerome crouigneauabout 25 years ago2 messagesbugs

jerome_crouigneau@yahoo.fr

about 25 years ago

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

Tom Lane

tgl@sss.pgh.pa.us

about 25 years ago

In reply to: jerome crouigneau (#1)

Re: postmaster crash

=?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