Re: Solved? Re: 8.2.4 signal 11 with large transaction

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: Solved? Re: 8.2.4 signal 11 with large transaction
Дата
Msg-id 20070720153926.da2557d3.wmoran@collaborativefusion.com
обсуждение исходный текст
Ответ на Solved? Re: 8.2.4 signal 11 with large transaction  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-general
In response to Bill Moran <wmoran@collaborativefusion.com>:

> In response to "Scott Marlowe" <scott.marlowe@gmail.com>:
[snip]
> I'm starting to wonder if the OS could be sending the sig 11?
>
> ... time warp ...
>
> Yup, that was it.  The OS was limiting the amount of memory a single
> process could use via kern.maxdsiz (FreeBSD).  This was evident with
> ulimit -d.
>
> So, the fact remains that PG 8.1 returns an out of memory error when
> it hits this, and PG 8.2 coredumps.  Is the 8.2 behaviour expected/
> planned?  The out of memory error I would expect, the coredump I
> would not.

It just occurred to me that there's another wildcard in this one.
The 8.1 system I tested was on FreeBSD 5.5, while both 8.2 systems
were running on FreeBSD 6.2.  I wonder if FreeBSD has changed
which signal gets sent on memory exhaustion?

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Solved? Re: 8.2.4 signal 11 with large transaction
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.2.4 signal 11 with large transaction