Re: Errors when running vacuumdb...

Поиск
Список
Период
Сортировка
От Dominic J. Eidson
Тема Re: Errors when running vacuumdb...
Дата
Msg-id Pine.LNX.4.33.0204021035030.15633-100000@morannon.the-infinite.org
обсуждение исходный текст
Ответ на Re: Errors when running vacuumdb...  ("Dominic J. Eidson" <sauron@the-infinite.org>)
Список pgsql-general
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/


В списке pgsql-general по дате отправления:

Предыдущее
От: "David Esposito"
Дата:
Сообщение: Re: Core dump on PG 7.1.3
Следующее
От: James Leigh
Дата:
Сообщение: dropping large objects