Re: [HACKERS] Backend crashes (6.5.2 linux)

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Simms <grim(at)argh(dot)demon(dot)co(dot)uk>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Backend crashes (6.5.2 linux)
Date: 1999-11-01 07:02:04
Message-ID: 381D3AEC.C9EA7FBF@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
>
> Michael Simms <grim(at)argh(dot)demon(dot)co(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrij Korud 1999-11-01 07:03:56 Re: [HACKERS] Trigger aborted on error
Previous Message Tatsuo Ishii 1999-11-01 06:35:33 Re: [HACKERS] sort on huge table