Re: Solved? Re: 8.2.4 signal 11 with large transaction - Mailing list pgsql-general

From Bill Moran
Subject Re: Solved? Re: 8.2.4 signal 11 with large transaction
Date
Msg-id 20070720153926.da2557d3.wmoran@collaborativefusion.com
Whole thread Raw
In response to Solved? Re: 8.2.4 signal 11 with large transaction  (Bill Moran <wmoran@collaborativefusion.com>)
List 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 by date:

Previous
From: Bill Moran
Date:
Subject: Solved? Re: 8.2.4 signal 11 with large transaction
Next
From: Tom Lane
Date:
Subject: Re: 8.2.4 signal 11 with large transaction