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

From Bruce Momjian
Subject Re: [GENERAL] "FATAL 1: my bits moved right off the end of the world!"
Date
Msg-id 199911301958.OAA18607@candle.pha.pa.us
Whole thread Raw
In response to "FATAL 1: my bits moved right off the end of the world!"  (Ed Loehr <ELOEHR@austin.rr.com>)
List pgsql-general
> 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.

Drop index and recreate.  7.0 will say that specifically.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] "FATAL 1: my bits moved right off the end of the world!"
Next
From: "Dale Anderson"
Date:
Subject: Date & Time