noordsij writes:
> After a few hours of watching strange things happening I finally stumbled
> on the cause.
> Very short summary: the postgres binary needs to be linked to libpthread,
> as this will ensure a special fork() inside libthr (the FreeBSD libpthread
> implementation/wrapper) is used w
After a few hours of watching strange things happening I finally stumbled
on the cause.
Very short summary: the postgres binary needs to be linked to libpthread,
as this will ensure a special fork() inside libthr (the FreeBSD libpthread
implementation/wrapper) is used which correctly deals with a
On 07/25/2011 05:57 PM, Alvaro Herrera wrote:
> Excerpts from Robert Haas's message of lun jul 25 11:20:55 -0400 2011:
>> On Sun, Jul 24, 2011 at 5:06 PM, noordsij wrote:
Any idea what query triggered this?
>>>
>>> Only up to which stored procedure (which itself contains multiple
>>> statemen
Excerpts from Robert Haas's message of lun jul 25 11:20:55 -0400 2011:
> On Sun, Jul 24, 2011 at 5:06 PM, noordsij wrote:
> >> Any idea what query triggered this?
> >
> > Only up to which stored procedure (which itself contains multiple
> > statements).
>
> If you provide a reproducible test case
On Sun, Jul 24, 2011 at 5:06 PM, noordsij wrote:
>> Any idea what query triggered this?
>
> Only up to which stored procedure (which itself contains multiple
> statements).
If you provide a reproducible test case, we can probably get this fixed.
Otherwise, we probably can't.
--
Robert Haas
Ent
> Any idea what query triggered this?
Only up to which stored procedure (which itself contains multiple
statements).
However, in a new fresh FreeBSD environment (under virtualbox) I can
trigger a similar (my guess is it is the same issue) segmentation fault
reliably.
Application is a Python we
On Thu, Jun 30, 2011 at 3:32 AM, Dennis wrote:
> For some reason a 9.0.4 server which has always run completely stable, and
> without any recent changes, crashed ("WARNING: terminating connection
> because of crash of another server process" ..)
>
> Since it is not a debug build the backtrace is
The following bug has been logged online:
Bug reference: 6086
Logged by: Dennis
Email address: dennis.noord...@helsinki.fi
PostgreSQL version: 9.0.4
Operating system: FreeBSD 8.2 (64 bit)
Description:Segmentation fault
Details:
For some reason a 9.0.4 server which h