Re: FATAL: could not read statistics message - Mailing list pgsql-general

From Tom Lane
Subject Re: FATAL: could not read statistics message
Date
Msg-id 13096.1147820806@sss.pgh.pa.us
Whole thread Raw
In response to Re: FATAL: could not read statistics message  ("Tony Wasson" <ajwasson@gmail.com>)
Responses Re: FATAL: could not read statistics message  ("Tony Wasson" <ajwasson@gmail.com>)
List pgsql-general
"Tony Wasson" <ajwasson@gmail.com> writes:
> When I saw the same error as you, the stats collector process was
> missing.

The collector, or the buffer process?  The reported message would be
emitted by the buffer process, after which it would immediately exit.
(The collector would go away too once it noticed EOF on its input.)
By and by the postmaster should start a fresh pair of processes.

IIRC, the postmaster's spawning is rate-limited to once a minute,
so if the new buffer were immediately dying with the same error,
that would explain your observation of once-a-minute messages.

This all still leaves us no closer to understanding *why* the recv()
is failing, though.  What it does suggest is that the problem is a
hard, repeatable error when it does occur, which makes me loath to
put in the quick-fix "retry on EAGAIN" that I previously suggested.
If it is a hard error then that will just convert the problem into
a busy-loop that'll eat all your CPU cycles ... not much of an
improvement ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: bytea hex input/output
Next
From: Tom Lane
Date:
Subject: Re: Partitioning on ip4 datatype using <<=