Re: [BUGS] Unpredictable signal 11 crashes on Mac OS X (SOLVED[?])

2003-10-13 Thread Tom Lane
Gareth Boden <[EMAIL PROTECTED]> writes: > Bizarrely, it came down to an infinite recursion in a plpgsql function > we were using which exhausted memory and crashed the db server. Is > there any way of limiting stack depth/having some sort of monitor on > these functions to prevent this behaviou

Re: [BUGS] Unpredictable signal 11 crashes on Mac OS X (SOLVED[?])

2003-10-08 Thread Gareth Boden
On Wednesday, October 8, 2003, at 03:54 PM, Tom Lane wrote: Gareth Boden <[EMAIL PROTECTED]> writes: We've been having a lot of problems with unpredicatable crashes with 7.3.4 on OS X Server (10.2.6 and 10.2.8 exhibit the same behaviour). Have you looked into the possibility of bad hardware? I ro

Re: [BUGS] Unpredictable signal 11 crashes on Mac OS X

2003-10-08 Thread Gareth Boden
On Wednesday, October 8, 2003, at 03:54 PM, Tom Lane wrote: Gareth Boden <[EMAIL PROTECTED]> writes: We've been having a lot of problems with unpredicatable crashes with 7.3.4 on OS X Server (10.2.6 and 10.2.8 exhibit the same behaviour). Have you looked into the possibility of bad hardware?

Re: [BUGS] Unpredictable signal 11 crashes on Mac OS X

2003-10-08 Thread Tom Lane
Gareth Boden <[EMAIL PROTECTED]> writes: > We've been having a lot of problems with unpredicatable crashes with > 7.3.4 on OS X Server (10.2.6 and 10.2.8 exhibit the same behaviour). Have you looked into the possibility of bad hardware? I routinely test PG on OS X (10.2.6 currently) and have ne

[BUGS] Unpredictable signal 11 crashes on Mac OS X

2003-10-08 Thread Gareth Boden
Hi, We've been having a lot of problems with unpredicatable crashes with 7.3.4 on OS X Server (10.2.6 and 10.2.8 exhibit the same behaviour). Having run with verbose logging for some time, we have not noticed any real consistency in the types of queries which are causing the crash recently. A few