Re: BUG: Infinite syslog() loop - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG: Infinite syslog() loop
Date
Msg-id 29990.1051304558@sss.pgh.pa.us
Whole thread Raw
In response to BUG: Infinite syslog() loop  (Erik Walthinsen <omega@temple-baptist.com>)
Responses Re: BUG: Infinite syslog() loop
List pgsql-bugs
Erik Walthinsen <omega@temple-baptist.com> writes:
> Apr 22 04:00:02 alpha postgres[362]: [1] DEBUG:  statistics collector
> process (pid 364) exited with exit code 1
> Apr 22 04:00:02 alpha postgres[362]: [2] DEBUG:  statistics collector
> process (pid 17945) exited with exit code 1
> . . . .
> Apr 22 04:16:32 alpha postgres[362]: [445836] DEBUG:  statistics collector
> process (pid 1629) exited with exit code 1

> The machine is a stock Debian Woody box, up to date, with no local changes
> to the postgres configuration at all.  It's running 7.2.1-2woody2.

Hmm.  Evidently the pgstat subprocess is dying immediately on launch.
Checking the archives, I see that back then pgstat was in the habit of
reporting its woes on stderr no matter what the elog destination was
supposed to be :-(.  So the actually useful message went to postmaster
stderr, which more than likely is routed to /dev/null by your postmaster
startup script.

If you want to try to figure out what went wrong, you could alter the
start script to enable collection of stderr output and then try to
reproduce the problem.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: parallel pg installation and functions gotcha
Next
From: Tom Lane
Date:
Subject: Re: pg_dump and vacuum fail on tables with no columns