Re: repeatable crash generating two column index

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(at)rogers(dot)com>
PGP Key ID: DB3C29FC