Re: Backend crash while indexing large strings - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Backend crash while indexing large strings
Date
Msg-id 13192.981671134@sss.pgh.pa.us
Whole thread Raw
In response to Backend crash while indexing large strings  (pgsql-bugs@postgresql.org)
Responses Re: Backend crash while indexing large strings  (Stephen van Egmond <svanegmond@bang.dhs.org>)
List pgsql-bugs
pgsql-bugs@postgresql.org writes:
> The attached sql crashed Postgres 7.0.2 on a debian linux system
> (intel), using the packages 7.0.2-6.

I get

FATAL 1:  btree: failed to add item to the page in _bt_sort (2)
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.

Is that the same thing you see?

The script does not seem to trigger the failure in current sources,
so I suspect the equal-keys changes I made awhile back fixed it.
But I will dig into the crash and make sure.  Many thanks for providing
a self-contained test case!

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Backend crash while indexing large strings
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] Create index problem ( _bt_sort )