Re: Backend crash while indexing large strings

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

Yes, sorry for omitting the crash.

> 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!

Great!  Excellent.  Looking forward to 7.1!

Having just spent last night (midnight to 4 am) installing Oracle, let
me say that I'm going to make my positive best efforts to work with
pgsql.

I was considering using the ACS (http://www.arsdigita.com/ ),
which requries Oracle, but after last night's nightmare, I'm hereby
pledging to work with OpenACS (http://www.openacs.org/ ) which is
a port to Postgres.

/Steve

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Constantin Teodorescu"
Дата:
Сообщение: Re: Problem displaying functions and views in 7.1b3
Следующее
От: "praveenkumar reddy m"
Дата:
Сообщение: please give me the answer