Re: [HACKERS] Backend crashes (6.5.2 linux) - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] Backend crashes (6.5.2 linux)
Date
Msg-id 381D3AEC.C9EA7FBF@krs.ru
Whole thread Raw
In response to Re: [HACKERS] Backend crashes (6.5.2 linux)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> Michael Simms <grim@argh.demon.co.uk> writes:
> > The postmaster stderr says:
> > FATAL 1:  my bits moved right off the end of the world!
> 
> Hmm.  That error is coming out of the btree index code.  Vadim knows
> that code better than anyone else, so he might have something to say
> here, but my past-midnight recollection is that we've seen that error
> being triggered when there are oversize entries in the index (where
> "oversize" = "more than half a disk page").  It's a bug, for sure,
> but what you probably want right now is a workaround.  Do you have any
> entries in indexed columns that are over 4K, and can you get rid of them?

This FATAL means that index is broken (some prev insertion
was interrupted by elog(ERROR) or backend crash) - try to rebuild...
WAL should fix this bug.

Vadim


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] sort on huge table
Next
From: "Andrij Korud"
Date:
Subject: Re: [HACKERS] Trigger aborted on error