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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026