Re: Backend died abnormally - postgresql 7.2.1-5

[Cc'ed to -general so that others can help]

On Tue, Jul 16, 2002 at 09:51:48AM -0500, Rick Eicher II wrote:
> > Is the crash reproducible, and if so, can you post the query or
> > situation that causes the crash to occur? (you can enable query
> > logging with debug_print_query in postgresql.conf)
>
> The crash is reproducible. Some examples of a query would be:
>
> Select * from cust_main where last='smith';
> Select * from cust_main;

Are there any additional errors in the logs?

With an error that fundamental, I'd suspect hardware problems, namely
bad RAM. Would it be possible to run memtest86 on the machine?

> I do have some joins queries but I seem to get this error with any of
> query. If I issue the same query four times I will get the error one
> time. I have uncommented this line (and others) in postgresql.conf but
> do not get any log entries after restart.
>
> >
> > Is there a core file in one of your database directories -- and if
> > so, can you get a backtrace from it using gdb? It might also be
> > useful to get a backtrace from a debugging build (--enable-debug).
>
> No core file.

Are you sure your system is setup to allow core dumps -- i.e.
does "ulimit -c" produce "unlimited"?

Also, make sure you're looking in the right place for
core files ($PGDATA/base/$oid_of_db/core)

> Should I get the source and build it instead of using rpms?

Might be a good bet -- at the least, it should produce a more
helpful backtrace.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC