Re: ERROR: attempted to delete invisible tuple - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: attempted to delete invisible tuple
Date
Msg-id 5665.1250535581@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: attempted to delete invisible tuple  (Greg Stark <gsstark@mit.edu>)
Responses Re: ERROR: attempted to delete invisible tuple  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> Excluding the cases where our own xid is in the tuple I think the
> relevant cases are either

> xmin aborted or in progress (or in future)
> MOVED_OFF and xvac committed
> MOVED_IN and xvac aborted or is in progress (or in future)

Ah.  I hadn't bothered to check the code in detail before asking about
the current XID.  Given subsequent data, it seems that current XID must
have moved past xvac while we were wondering about it.  This could mean
either corrupted xvac values, or that the crash caused current XID to go
backwards (suggesting loss of both the current pg_control and a big
chunk of WAL).  Since multiple tuples on different pages were involved,
I'm inclined to believe the second theory.

            regards, tom lane

pgsql-general by date:

Previous
From: Nuno Mota
Date:
Subject: Re: plpython return setof and yield
Next
From: Jeremy Harris
Date:
Subject: Re: Rapid Seek Devices (feature request)