Re: ERROR: attempted to delete invisible tuple

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: attempted to delete invisible tuple
Дата
Msg-id 5665.1250535581@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: attempted to delete invisible tuple  (Greg Stark <gsstark@mit.edu>)
Ответы Re: ERROR: attempted to delete invisible tuple
Список 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 по дате отправления:

Предыдущее
От: Nuno Mota
Дата:
Сообщение: Re: plpython return setof and yield
Следующее
От: Jeremy Harris
Дата:
Сообщение: Re: Rapid Seek Devices (feature request)