Re: [HACKERS] still getting FATAL errors on btree's...

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] still getting FATAL errors on btree's...
Дата
Msg-id 199804131631.MAA18842@candle.pha.pa.us
обсуждение исходный текст
Ответ на still getting FATAL errors on btree's...  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: [HACKERS] still getting FATAL errors on btree's...  (The Hermit Hacker <scrappy@hub.org>)
Re: [HACKERS] still getting FATAL errors on btree's...  (Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl>)
Список pgsql-hackers
>
>
> I'm still getting the following BTP_CHAIN errors on my btree index.  Funny
> thing is that its the *same* index each time, and this is after dropping
> and rebulding it...
>
> ...where next to investigate?  Recommendations?  IMHO, this is critical
> enough to hold off a v6.3.2 release :(

Obiously there is something strange going on, or many more people would
be seeing it.  The question is what.

Could it be the data?  Concentrate on that table, load only half, and
see if it happens.  Try loading first half of the file twice, to the
file is the same size, but the data is only from the first half.  Try it
with the second half too.  Does the problem change.  If so, there is
something in the data that is causing the problem.

Is it something that we can repeat?  Can you put it on the ftp server
with a script so others can check it?  If you load just that table into
an empty database, does the problem still occur?


>
>
> FATAL 1:  btree: BTP_CHAIN flag was expected in radhist_userid (access =
> bt_read)
> FATAL 1:  btree: BTP_CHAIN flag was expected in radhist_userid (access =
> bt_read)
> FATAL 1:  btree: BTP_CHAIN flag was expected in radhist_userid (access =
> bt_read)
> FATAL 1:  btree: BTP_CHAIN flag was expected in radhist_userid (access =
> bt_read)
> FATAL 1:  btree: BTP_CHAIN flag was expected in radhist_userid (access =
> bt_read)
>
>
>
>


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

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

Предыдущее
От: Garrett Wollman
Дата:
Сообщение: Re: [HACKERS] Safe/Fast I/O ...
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] still getting FATAL errors on btree's...