RE: Re: PostgreSQL; Strange error

> >> Warning: PostgreSQL query failed: FATAL 1: my bits moved
> >> right off the end of the world! Recreate index
> >> pg_attribute_relid_attnum_index.
>
> This is an internal "can't happen" failure condition,
> presumably arising from some weird corner-case bug in btree
> index manipulation. We have seen sporadic reports of this
> failure, mostly from people using lots of large objects,
> but no one has yet provided a test case that allows
> the problem to be reproduced from scratch. When I'm in an

Just use gdb to prevent parent btree page update after
split and you'll get that error next time when splitting
new, unpointed from parent, right sibling.
In real life you have !0 probability to get same case
without gdb just by pg_ctl -m fast stop, not to mention
pg_ctl -m immediate stop, power off and OS' crash.

> optimistic mood I think that the bug might be fixed in 7.1,
> but it's hard to say for sure because I've never seen this
> failure happen myself.

Just add elog(ERROR) after split to see this.
This is what I made to test new btree runtime recovery code
in 7.1.

Vadim