Re: attempted to lock invisible tuple - PG 8.4.1 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: attempted to lock invisible tuple - PG 8.4.1
Date
Msg-id 20091006161256.GJ5929@alvh.no-ip.org
Whole thread Raw
In response to Re: attempted to lock invisible tuple - PG 8.4.1  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: attempted to lock invisible tuple - PG 8.4.1
List pgsql-general
Alvaro Herrera wrote:
> Stuart Bishop wrote:

> > The test case (invisible.sh) and required dump (foodump.sql - 60k) are
> > at http://www.stuartbishop.net/invisible/
>
> Got it, thanks, looking.

Here's a slightly smaller test case; basically I removed the tsearch2
cruft and extra columns in the table.  One thing of note is that if the
COPY commands is reduced to occupy less than one page in the target
table, the problem does not occur.

To reproduce, restore the attached file and run
BEGIN;
SET transaction_isolation TO SERIALIZABLE;
UPDATE Bug2 SET name='foobar' WHERE id=1;
ABORT;


--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Attachment

pgsql-general by date:

Previous
From: Alan McKay
Date:
Subject: LF PostgreSQL virtual Linux host provider in India and/or Asia Pac
Next
From: David Fetter
Date:
Subject: Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5