Re: Backend crash while indexing large strings

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Backend crash while indexing large strings
Дата
Msg-id 13192.981671134@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Backend crash while indexing large strings  (pgsql-bugs@postgresql.org)
Ответы Re: Backend crash while indexing large strings  (Stephen van Egmond <svanegmond@bang.dhs.org>)
Список 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 по дате отправления:

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Backend crash while indexing large strings
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] Create index problem ( _bt_sort )