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

Re: BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Regina Obe" <robe(dot)dnd(at)cityofboston(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently
Date: 2008-12-08 01:16:17
Message-ID: 4543.1228698977@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-12-08 02:09:35
Subject: Re: BUG #4564: multi threaded queries corrupt client when server debugging levels are hi
Previous:From: Gevik BabakhaniDate: 2008-12-07 23:50:08
Subject: Re: BUG #4186: set lc_messages does not work

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