Обсуждение: Error on Vacuum Full

Поиск
Список
Период
Сортировка

Error on Vacuum Full

От
"Peter Darley"
Дата:
Friends,
    I got the following error while doing a vacuum full: 'NOTICE:  Child itemid
in update-chain marked as unused - can't continue repair_frag'.  I couldn't
find any corresponding message in the log.
    I couldn't find anything in the archives except for a message from 2001
that wasn't really answered.  How big a deal is this, and what can I do
about it?
Thanks,
Peter Darley

Re: Error on Vacuum Full

От
"Peter Darley"
Дата:
Friends,
    To answer the obvious question, I'm using PostgreSQL 7.2.1 on
i686-pc-linux-gnu, compiled by GCC 2.96.
Thanks,
Peter Darley

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Peter Darley
Sent: Monday, October 28, 2002 9:19 AM
To: Pgsql-Admin
Subject: [ADMIN] Error on Vacuum Full


Friends,
    I got the following error while doing a vacuum full: 'NOTICE:  Child itemid
in update-chain marked as unused - can't continue repair_frag'.  I couldn't
find any corresponding message in the log.
    I couldn't find anything in the archives except for a message from 2001
that wasn't really answered.  How big a deal is this, and what can I do
about it?
Thanks,
Peter Darley


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: Error on Vacuum Full

От
Tom Lane
Дата:
"Peter Darley" <pdarley@kinesis-cem.com> writes:
>     I got the following error while doing a vacuum full: 'NOTICE:  Child itemid
> in update-chain marked as unused - can't continue repair_frag'.  I couldn't
> find any corresponding message in the log.
>     I couldn't find anything in the archives except for a message from 2001
> that wasn't really answered.  How big a deal is this, and what can I do
> about it?

It's not a big deal (that's why it's a NOTICE not an error), but I'd
recommend an update to 7.2.3 anyway.

            regards, tom lane