From: | "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Errors when running vacuumdb... |
Date: | 2002-04-02 16:36:01 |
Message-ID: | Pine.LNX.4.33.0204021035030.15633-100000@morannon.the-infinite.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 2 Apr 2002, Dominic J. Eidson wrote:
> On Tue, 2 Apr 2002, Tom Lane wrote:
> > "Dominic J. Eidson" <sauron(at)the-infinite(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | James Leigh | 2002-04-02 16:46:59 | dropping large objects |
Previous Message | David Esposito | 2002-04-02 16:12:10 | Re: Core dump on PG 7.1.3 |