From: | "Paul Ramsey" <pramsey(at)cleverelephant(dot)ca> |
---|---|
To: | "PostGIS Development Discussion" <postgis-devel(at)postgis(dot)refractions(dot)net> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: [postgis-devel] RE: BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently |
Date: | 2008-12-08 19:02:08 |
Message-ID: | 30fe546d0812081102q53f5ff58of75d74b8ea5c13c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Yes, that patch removes the bug.
P.
On Sun, Dec 7, 2008 at 11:51 PM, Obe, Regina <robe(dot)dnd(at)cityofboston(dot)gov> wrote:
> "Regina Obe" <robe(dot)dnd(at)cityofboston(dot)gov> writes:
>> Description: Clustering on GIST INDEX clobbers records in table
>> intermittently
>
>> This doesn't always happen to me but does intermittently, and for others
>> it
>> happens all the time.
>
>> I wonder whether this is fixed by this recent patch:
>> http://archives.postgresql.org/pgsql-committers/2008-12/msg00053.php
>
>> The pre-patch behavior would've depended on the value of a
>> never-initialized struct field, so the erratic behavior is explained
>> by varying contents of memory. I'm unable to make it happen in an
>> assert-enabled build, but that's probably because the initial contents
>> of a palloc'd chunk are never zeroes in such a build.
>
>> regards, tom lane
>
> Tom,
>
> Thanks for the quick response on this.
>
> Paul,
> You think by chance you can test out the patch since you can make this bug
> happen consistently on your build.
>
> Thanks,
> Regina
>
>
>
> ________________________________
>
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure pursuant to
> Massachusetts law. It is intended solely for the addressee. If you received
> this in error, please contact the sender and delete the material from any
> computer.
>
> ________________________________
>
> Help make the earth a greener place. If at all possible resist printing this
> email and join us in saving paper.
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel(at)postgis(dot)refractions(dot)net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-12-08 21:31:41 | Re: BUG #4565: nextval not updated during wal replication, leading to pk violations |
Previous Message | Marc Schablewski | 2008-12-08 17:14:14 | Re: BUG #4565: nextval not updated during wal replication, leading to pk violations |