Re: Vacuum errors and warnings

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum errors and warnings
Дата
Msg-id 5778.1008030763@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum errors and warnings  ("Rich Ryan" <rich@usedcars.com>)
Список pgsql-general
"Rich Ryan" <rich@usedcars.com> writes:
> Vacuuming
> (These messages I receive every night)
> NOTICE:  RegisterSharedInvalid: SI buffer overflow
> NOTICE:  RegisterSharedInvalid: SI buffer overflow
> NOTICE:  InvalidateSharedInvalid: cache state reset

These are ignorable.

> NOTICE:  Rel r_maryland: Uninitialized page 730 - fixing
> NOTICE:  Index cfsoidmaryland: pointer to EmptyPage (blk 730 off 4) - fixing
> NOTICE:  Index cfsoidmaryland: pointer to EmptyPage (blk 730 off 8) - fixing

These are not good.  Is it possible you've got disk hardware problems?

A possible answer is to rebuild that damaged index with REINDEX, but if
the problems keep coming back then you've got something very wrong.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Paul Laub"
Дата:
Сообщение: Re: referential integrity on existing table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] How to get database schema without pg_dump?