Search Postgresql Archives

Re: ERROR: attempted to delete invisible tuple

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Aug 17, 2009 at 6:17 PM, Tom Lane<tgl@xxxxxxxxxxxxx> wrote:
> Hm, what's your current XID counter?  (pg_controldata would give an
> approximate answer.)  I'm wondering if the xmax's are marked committed
> but are in the future ...
>

FWIW that doesn't look right. That would result in
HeapTupleBeingUpdated. The only case where it could result in
"invisible" is if it's our own xid.

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)

-- 
greg
http://mit.edu/~gsstark/resume.pdf

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux