Skip site navigation (1) Skip section navigation (2)

Re: Problem Observed in behavior of Create Index Concurrently and Hot Update

From: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update
Date: 2012-11-02 12:02:16
Message-ID: CABOikdO-VN2Bq+jG2MJH4yT5O+CHng-iUmJ0YZ7FW17xd-Fc_A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Oct 31, 2012 at 2:40 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:

>
> >
> > diff --git a/src/backend/utils/cache/relcache.c
> > b/src/backend/utils/cache/relcache.c
> > index a59950e..9cadb3f 100644
> > --- a/src/backend/utils/cache/relcache.c
> > +++ b/src/backend/utils/cache/relcache.c
> > @@ -3355,6 +3355,12 @@ RelationGetIndexList(Relation relation)
> >                 oidvector  *indclass;
> >                 bool            isnull;
> >
> > +               /*
> > +                * Ignore any indexes that are currently being dropped
> > +                */
> > +               if (!index->indisvalid && !index->indisready)
> > +                       continue;
> > +
> >                 /* Add index's OID to result list in the proper order */
> >                 result = insert_ordered_oid(result, index->indexrelid);
>
> Agreed, will fix.
>
>
Thanks Simon.

Looks like a severe data corruption issue. Is there a minor release planned
in near future or would this need one ?

Please let me know if you need any help with this. I investigated this a
bit before posting my analysis (just to ensure that its not a HOT's bug),
but since it involved DROP INDEX CONCURRENTLY, thought it will best be
addressed by you.

Thanks,
Pavan

In response to

pgsql-hackers by date

Next:From: Alexander KorotkovDate: 2012-11-02 12:05:30
Subject: Re: Incorrect behaviour when using a GiST index on points
Previous:From: Pavan DeolaseeDate: 2012-11-02 11:52:07
Subject: Bug in ALTER COLUMN SET DATA TYPE ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group