Re: Troubling On-line Backup LOG messages

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Troubling On-line Backup LOG messages
Дата
Msg-id 18230.1142963652@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Troubling On-line Backup LOG messages  ("Thomas F. O'Connell" <tfo@sitening.com>)
Ответы Re: Troubling On-line Backup LOG messages  ("Thomas F. O'Connell" <tfo@sitening.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PANIC: heap_update_redo: no block
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Re: Troubling On-line Backup LOG messages