Re: [GENERAL] "FATAL 1: my bits moved right off the end of theworld!" - Mailing list pgsql-general

From Ed Loehr
Subject Re: [GENERAL] "FATAL 1: my bits moved right off the end of theworld!"
Date
Msg-id 38446682.4746C051@austin.rr.com
Whole thread Raw
In response to Re: [GENERAL] "FATAL 1: my bits moved right off the end of the world!"  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
Responses Re: [GENERAL] "FATAL 1: my bits moved right off the end of theworld!"
List pgsql-general
Peter Eisentraut wrote:

> This is getting to be our favourite error message...
>
> It is caused by a corrupted B-Tree index. Drop and recreate that one.

Thanks.  Unfortunately, the lack of context to the error message makes it difficult
to identify which index is "that one."  The message was last showing up during the
process of dropping/recreating a series of triggers and functions via "psql -f"
without any table inserts/updates.

Cheers.
Ed Loehr

>
>
> On Tue, 30 Nov 1999, Ed Loehr wrote:
>
> > I have run into this error message a few times now in various circumstances
> > (using pgsql v6.5.2 on Linux 2.2.5-15smp):
> >
> >     "FATAL 1:  my bits moved right off the end of the world!"
> >
> > Does anyone have a clue as to what scenarios cause this?  (It apparently comes
> > from line 506 of .../src/backend/access/nbtree/nbtpage.c)
> >
> > I've had the luxury of being early in development and being able to rebuild my
> > DB to remove the symptom, but that will soon change.
> >
> > Thanks in advance,
> > Ed Loehr
> >
> >
> > ************
> >
> >
>
> --
> Peter Eisentraut                  Sernanders vaeg 10:115
> peter_e@gmx.net                   75262 Uppsala
> http://yi.org/peter-e/            Sweden
>
> ************


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Date & Time
Next
From: Ed Loehr
Date:
Subject: Re: [GENERAL] Date & Time