Re: PostgreSQL crashes with Qmail-SQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL crashes with Qmail-SQL
Date
Msg-id 21565.1011921135@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL crashes with Qmail-SQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL crashes with Qmail-SQL
List pgsql-hackers
I said:
> Yeah, I do recall that some versions had a tmp-scrubber that didn't make
> any exception for socket files.  But it's kind of a big coincidence to
> assume that would happen just while Michael was running his benchmark.

... or maybe not.  I just looked back at Michael's benchmark page and
observed that the extrapolated time to complete the run in question was
over 24 hours (and the first two parts of the script would've taken
more than 12).  If he'd left the machine alone for a couple of days
while the script ran, maybe it's credible that a /tmp-scrubber did its
thing meanwhile.

That still leaves us with all the defunct postmaster children to explain
though.  Hmm.  I wonder exactly what the postmaster does when someone
forcibly removes its socket file... probably system-dependent, but I
could certainly believe getting into a busy-wait loop of select/accept.
That doesn't look like it should prevent SIGCHLD from getting noticed,
though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL crashes with Qmail-SQL
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL crashes with Qmail-SQL