Re: postmaster dies (was Re: Very disappointing performance)

Tom Lane writes...
>secret <secret(at)kearneydev(dot)com> writes:
>>>>> PostgreSQL is also crashing 1-2 times a day on me, although I have a
>>>>> handy perl script to keep it alive now <grin>...
>
>> basically the server randomly dies with a:
>> ERROR: postmaster: StreamConnection: accept: Invalid argument
>> pmdie 3
>> (then signals all children to drop dead)
>
>Hmm. That shouldn't happen, especially not randomly; if the accept
>works the first time then it should work forever after, since the
>arguments being passed in never change.
>
>[snip]
>
>An alternative possibility is to run the postmaster under truss so you
>can see what arguments are passed to the kernel on every kernel call,
>but that'd generate a pretty verbose logfile.
>

FWIW...

If your (secret's) system uses strace, you can tell it to filter
just specific calls or groups of calls. For example,

strace -f -s 256 -e trace=network -o /tmp/strace.log -p <postmaster pid>

Should trace all the network operations of the postmaster and
all the children. I'm not sure if the socket reads/writes will
be included or not. The -s sets the 'snapshot' length.

Truss probably has similar options that can be enabled in some
baroque manner.

-- cary