Re: repeatable crash generating two column index - Mailing list pgsql-general

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: repeatable crash generating two column index
Date
Msg-id 20020704160550.GB19504@klamath.dyndns.org
Whole thread Raw
In response to repeatable crash generating two column index  (Mike Harding <mvh@ix.netcom.com>)
List pgsql-general
On Wed, Jul 03, 2002 at 10:58:34AM -0700, Mike Harding wrote:
> CREATE INDEX idx_id_perftest ON perftest (id, astring);
>
> the backend crashes every time.  I see the following in the logs...
>
> 2002-07-03 08:33:29 DEBUG:  server process (pid 53454) was terminated by signal 11
> 2002-07-03 08:33:29 DEBUG:  terminating any other active server processes
> 2002-07-03 08:33:29 DEBUG:  all server processes terminated; reinitializing shared memory and semaphores

Can you get a backtrace using gdb? If possible, recompile Postgres with
debugging symbols (-g), and run gdb on the core file that should be
produced when the backend crashes.

If that's not possible, can you forward me the relavant bits of the
schema, and the script you used to produce the data?

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC



pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: I am being interviewed by OReilly
Next
From: Bruce Momjian
Date:
Subject: Re: I am being interviewed by OReilly