[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@rogers.com>
PGP Key ID: DB3C29FC