Re: WEIRD! postmaster: segfault with sub select??!

On Sun, Jan 3, 2010 at 8:31 AM, Reto <primzahl(at)gmail(dot)com> wrote:
> Hi everybody,
>
> I'm facing a strange problem with a relatively simple sub select
> whereas everything else runs perfect on this machine (PG 8.4.2 @
> Fedora 12, Core2 E4600, 4GB, 2 x 320GB).
>
> # SELECT DISTINCT name FROM bbr_parts WHERE id IN (SELECT part_id FROM
> bbr_v_office_to_parts WHERE office_id=39 AND office_type=9);
>
> server closed the connection unexpectedly
>        This probably means the server terminated abnormally
>        before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.

Look at the postmaster logs for the error which caused the crash.
There should be something there even if it seg faulted.

Also, can you get a backtrace? Even with your current build if you
attach to the backend that you're connected to and get a backtrace
that could be useful. (run "select pg_backend_pid()" and then attach
to that pid in gdb, type "c" and then after the crash run
"backtrace").

The most useful would be to get a coredump from a debugging build but
the two things above would be a good start.

--
greg