Re: Troubling On-line Backup LOG messages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
Cc: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Troubling On-line Backup LOG messages
Date: 2006-03-21 17:54:12
Message-ID: 18230.1142963652@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thomas F. O'Connell" <tfo(at)sitening(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-21 18:03:02 Re: [GENERAL] A real currency type
Previous Message Josh Berkus 2006-03-21 17:39:09 Re: [GENERAL] A real currency type