From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgres 7.0.3 core dumps |
Date: | 2001-01-17 20:51:06 |
Message-ID: | 3A6605BA.180F90F4@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
>
> Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> > Anyway I look at http://www.selectacast.net/~jks/postgres/gdb3.txt The
> > backend was in ExecEvalVar () when it crashed.
>
> It sort of looks like the plan generated for a mergejoin must have been
> bogus, but with only routine names to go on, it's hard to tell more.
> Ways to get more info:
>
> * Recompile backend with -g (--enable-debug), so that next coredump will
> provide a more informative backtrace;
>
What do I pass into make to do this?
> * Run postmaster with -d2 so that queries are logged. You'l need to
> have compiled with #define ELOG_TIMESTAMPS (uncomment this in
> src/include/config.h after configuring) so that log entries have PID
> identifiers, which you'll then be able to correlate to the PID of the
> crashed backend. This'll tell us just what the failed backend had been
> doing.
>
> If it is a select from cursor that's dying, we'll really need the query
> log so that we can see what the cursor definition was...
>
>From my postgres log (this wasn't from a crash, I'm just showing you
what the cursor was like):
ProcessUtility: BEGIN;
query: DECLARE cname CURSOR FOR SELECT u.userkey, u.profile, u.config,
u.rules FROM usertable u, directory d WHERE u.podkey = 2 AND u.status =
2 AND u.subper AND NOT u.banned AND u.userkey = d.userkey AND d.status
IN(2, 5);
<...>
query: FETCH 100 FROM cname;
ProcessUtility: FETCH 100 FROM cname;
> regards, tom lane
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Robert B. Easter | 2001-01-17 20:53:30 | Re: Using max() MUCH slower in v7.1 |
Previous Message | J.H.M. Dassen (Ray) | 2001-01-17 20:47:45 | Re: Errors compiling 7.0.3 on Solaris 7 |