Re: Errors when running vacuumdb...

On Tue, 2 Apr 2002, Dominic J. Eidson wrote:

> On Tue, 2 Apr 2002, Tom Lane wrote:
> > "Dominic J. Eidson" <sauron@the-infinite.org> writes:
> > > when I run vacuumdb -a -v, I get:
> > > NOTICE:  Rel pg_attribute: Uninitialized page 1 - fixing
> > > ... more lines for page 2 through 50 ...
> > > NOTICE:  Rel pg_attribute: Uninitialized page 51 - fixing
> > > Any idea what causes this?
> > This is not good --- VACUUM is trying to recover from finding all-zero
> > pages in your table.  I would expect that the messages wouldn't recur
> > after you vacuum the table once; if they are repeatable then something
>
> I just re-ran vacuumdb -a -z, and the same errors ocurred.

[snip]

> No idea. :) I dropped the DB, and recreated - ran vacuumdb against it, and
> get no errors. I'm currently in the process of re-populating the DB
> (should take a few hours) - but will re-run vacuumdb -a -z, once it's
> done.

Database fully populated. Re-ran vacuumdb -a -z , and it runs clean.


--
Dominic J. Eidson
                                        "Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/              http://www.the-infinite.org/~dominic/