Re: Errors when running vacuumdb...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Errors when running vacuumdb...
Date: 2002-04-02 06:54:45
Message-ID: 22736.1017730485@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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
really strange is going on. But the real question is why such pages
are in the file in the first place.

What PG version are you running? Have you had any crashes or other
strange events lately?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Heiko Klein 2002-04-02 06:57:21 selecting random row
Previous Message Medi Montaseri 2002-04-02 05:28:27 sync and cache