Re: [GENERAL] "FATAL 1: my bits moved right off the end of the world!"

> 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