Re: [HACKERS] initdb problem

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: jwieck(at)debis(dot)com
Cc: emkxp01(at)mtcc(dot)demon(dot)co(dot)uk, meskes(at)online-club(dot)de, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] initdb problem
Date: 1998-08-28 03:37:08
Message-ID: 199808280337.XAA03382@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> Hi all,
>
> I don't know if this is really related to the initdb problem
> discussion (haven't followed it enough). But seems so because
> it fixes a damn problem during index tuple insertion on
> CREATE TABLE into pg_attribute_relid_attnum_index.
>
> Anyway - this bug was really hard to find. During startup the
> relcache reads in some prepared information about index
> strategies from a file and then reinitializes the function
> pointers inside the scanKey data. But for sake it assumed
> single attribute index tuples (hasn't that changed recently).
> Thus not all the strategies scanKey entries where initialized
> properly, resulting in invalid addresses for the btree
> comparision functions.
>
> With the patch at the end the regression tests passed
> excellent except for the sanity_check that crashed at vacuum
> and the misc test where the select unique1 from onek2 outputs
> the two rows in different order.
>
> Bruce, could you please apply it?
Jan, this is great. It would have taken me a long time to find this.
Why my platform did not fail is a real mystery.

Patch applied. I am looking at the vacuum problem now.

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1998-08-28 03:52:45 Re: [HACKERS] initdb problem
Previous Message Jan Wieck 1998-08-28 03:24:18 Re: [HACKERS] initdb problem