Re: repeatable crash generating two column index

From: Mike Harding <mvh(at)ix(dot)netcom(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: repeatable crash generating two column index
Date: 2002-07-04 18:13:44
Message-ID: 1025806425.587.22.camel@netcom1.netcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using the stock freebsd port installation.

Interestingly, this morning, I was able to create the index fine.

Then I dropped it and did an index just using id;

Then I dropped that and tried the original index again over both
columns.

I then get errors like

ERROR: MemoryContextAlloc: invalid request size 2353010684
ERROR: MemoryContextAlloc: invalid request size 1885489220

and the third and fourth time I tried it it worked!

I'll try running the regression test later today...

- Mike H.

On Thu, 2002-07-04 at 10:04, Tom Lane wrote:
> Mike Harding <mvh(at)ix(dot)netcom(dot)com> writes:
> > CREATE INDEX idx_id_perftest ON perftest (id, astring);
> > 2002-07-03 08:33:29 DEBUG: server process (pid 53454) was terminated by signal 11
>
> [ scratches head... ] Seems something awfully broken about your
> installation. Are you able to run the regression tests successfully?
>
> Can you provide a debugger backtrace from the corefile left by the
> crashing backend?
>
> regards, tom lane
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-04 18:22:43 Re: query problem in 7.2.1: serious planner issue
Previous Message Francisco Reyes 2002-07-04 18:06:31