Re: [BUGS] BUG #6086: Segmentation fault

2011-07-26 Thread Tom Lane
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

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-26 Thread noordsij
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

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-25 Thread Stefan Kaltenbrunner
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

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-25 Thread Alvaro Herrera
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

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-25 Thread Robert Haas
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

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-24 Thread noordsij
> 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

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-21 Thread Robert Haas
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

[BUGS] BUG #6086: Segmentation fault

2011-07-01 Thread Dennis
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