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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: scrappy(at)hub(dot)org (The Hermit Hacker)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] still getting FATAL errors on btree's...
Date: 1998-04-13 16:31:10
Message-ID: 199804131631.MAA18842@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-04-13 17:01:19 Re: [HACKERS] still getting FATAL errors on btree's...
Previous Message Garrett Wollman 1998-04-13 16:26:59 Re: [HACKERS] Safe/Fast I/O ...