Re: Errors when running vacuumdb... - Mailing list pgsql-general

From Tom Lane
Subject Re: Errors when running vacuumdb...
Date
Msg-id 22736.1017730485@sss.pgh.pa.us
Whole thread Raw
In response to Errors when running vacuumdb...  ("Dominic J. Eidson" <sauron@the-infinite.org>)
Responses Re: Errors when running vacuumdb...  ("Dominic J. Eidson" <sauron@the-infinite.org>)
List pgsql-general
"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
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

pgsql-general by date:

Previous
From: Medi Montaseri
Date:
Subject: sync and cache
Next
From: Heiko Klein
Date:
Subject: selecting random row