Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum errors and warnings - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum errors and warnings
Date
Msg-id 5778.1008030763@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum errors and warnings  ("Rich Ryan" <rich@usedcars.com>)
List pgsql-general
Tree view 
"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 by date:

Previous
From: "Paul Laub"
Date:
Subject: Re: referential integrity on existing table
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] How to get database schema without pg_dump?