Re: 2nd try @NetBSD/2.0 Alpha - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: 2nd try @NetBSD/2.0 Alpha
Date
Msg-id 20051019110023.GC5422@svana.org
Whole thread Raw
In response to Re: 2nd try @NetBSD/2.0 Alpha  (Larry Rosenman <ler@lerctr.org>)
Responses Re: 2nd try @NetBSD/2.0 Alpha
List pgsql-hackers
On Tue, Oct 18, 2005 at 10:07:26PM -0500, Larry Rosenman wrote:
> >...or attach with a debugger like gdb.
>
> d'oh.  I go stupid occasionally :)
>
> If someone wants me to, I can try that.

Yes, actually. See, its dying in the seg test already with:
 -- Open intervals SELECT '0..'::seg AS seg;
! ERROR:  floating-point exception
! DETAIL:  An invalid floating-point operation was signaled. This
probably means an out-of-range result or an invalid operation, s
uch as division by zero. SELECT '0...'::seg AS seg;
! ERROR:  floating-point exception
! DETAIL:  An invalid floating-point operation was signaled. This
probably means an out-of-range result or an invalid operation, s
uch as division by zero.

You need to attach a debugger to find out where that error is actually
happenening. Just startup the backend, connect to it and connect gdb to
the newly spawned backend and just run that query by hand. Then you
should get the backtrace at SIGFPE.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Question about Ctrl-C and less
Next
From: Szima Gábor
Date:
Subject: collector/autovacuum after crash (8.1beta3)