Re: ERROR: No one parent tuple was found

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: ERROR: No one parent tuple was found
Дата
Msg-id x7d6mhgp0c.fsf@onceler.kciLink.com
обсуждение исходный текст
Ответ на Re: ERROR: No one parent tuple was found  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
>>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:

BM> Uh, I know we fixed this in 7.3, but I don't remember the cause in 7.2.X.

BM> ---------------------------------------------------------------------------

BM> Renê Salomão wrote:
>> Hi list,
>>
>> After run "VACCUM FULL VERBOSE ANALYZE" the following message appears:
>> "ERROR:  No one parent tuple was found"...
>> What can be causing this problem?

When I asked this question a few months ago, I got an answer from Tom
Lane.  Basically, some transaction wasn't properly closed.  My
solution was dump/restore.  I think he proposed some other possible
fix, but I didn't bother with it.

As soon as RT gets up to snuff with 7.3, I'm moving up again... but
that dump/restore sure takes a looong time with 100+ million
records. ;-(


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: DBD::Pg & DBD::PgPP Cpan question
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: all backends (pg7.2.3 / redhat 7.2) die due to unexpected signal 14 (SIGALRM)