Re: Troubling On-line Backup LOG messages - Mailing list pgsql-general

From Tom Lane
Subject Re: Troubling On-line Backup LOG messages
Date
Msg-id 18230.1142963652@sss.pgh.pa.us
Whole thread Raw
In response to Troubling On-line Backup LOG messages  ("Thomas F. O'Connell" <tfo@sitening.com>)
Responses Re: Troubling On-line Backup LOG messages  ("Thomas F. O'Connell" <tfo@sitening.com>)
List pgsql-general
"Thomas F. O'Connell" <tfo@sitening.com> writes:
> 2006-03-21 10:38:53 CST 1412 :LOG:  archive recovery complete
> 2006-03-21 10:38:53 CST 1412 :LOG:  could not truncate directory
> "pg_multixact/offsets": apparent wraparound
> 2006-03-21 10:38:53 CST 1412 :LOG:  could not truncate directory
> "pg_multixact/members": apparent wraparound

What file name(s) appear in those directories?  Do you continue to get
the same log messages during subsequent checkpoints?

> followed by dozens of these:
> 2006-03-21 10:39:22 CST 2499 :LOG:  invalid server process ID -1

I've seen this off and on in CVS HEAD, mostly just after provoking a
backend crash ;-).  The message is evidently from the pgstats subsystem.
I think it has to do with backends trying to send stats messages before
they're fully initialized, but haven't tracked it down yet.  It should
be pretty harmless in any case.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PANIC: heap_update_redo: no block
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: Troubling On-line Backup LOG messages