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

Re: Very strange postgresql behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: arnaulist(at)andromeiberica(dot)com
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Very strange postgresql behaviour
Date: 2007-01-29 15:35:53
Message-ID: 10668.1170084953@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Arnau <arnaulist(at)andromeiberica(dot)com> writes:
>    I have postgresql 7.4.2 running on debian and I have the oddest 
> postgresql behaviour I've ever seen.

Is this specific to these two rows?  If so it might be a case of this
bug, which was repaired in 7.4.13:

http://archives.postgresql.org/pgsql-general/2006-05/msg00756.php
http://archives.postgresql.org/pgsql-committers/2006-05/msg00174.php

2006-05-19 12:31  tgl

	* src/backend/executor/nodeIndexscan.c (REL7_4_STABLE): Fix nasty
	bug in nodeIndexscan.c's detection of duplicate tuples during a
	multiple (OR'ed) indexscan.  It was checking for duplicate
	tuple->t_data->t_ctid, when what it should be checking is
	tuple->t_self.	The trouble situation occurs when a live tuple has
	t_ctid not pointing to itself, which can happen if an attempted
	UPDATE was rolled back.  After a VACUUM, an unrelated tuple could
	be installed where the failed update tuple was, leading to one live
	tuple's t_ctid pointing to an unrelated tuple.	If one of these
	tuples is fetched by an earlier OR'ed indexscan and the other by a
	later indexscan, nodeIndexscan.c would incorrectly ignore the
	second tuple.  The bug exists in all 7.4.* and 8.0.* versions, but
	not in earlier or later branches because this code was only used in
	those releases.  Per trouble report from Rafael Martinez Guerrero.

REINDEX wouldn't fix this, although a table dump and reload would.

			regards, tom lane

PS: please don't spam multiple lists with the same question.

In response to

Responses

pgsql-admin by date

Next:From: Tom DongDate: 2007-01-29 17:01:26
Subject: Postgres encyrption export
Previous:From: Robert D OdenDate: 2007-01-29 15:03:13
Subject: Terminating a query that appears to be hung

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