Re: ERROR: attempted to delete invisible tuple

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: attempted to delete invisible tuple
Дата
Msg-id 4288.1250530885@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: attempted to delete invisible tuple  (Bryan Murphy <bmurphy1976@gmail.com>)
Ответы Re: ERROR: attempted to delete invisible tuple
Список pgsql-general
Bryan Murphy <bmurphy1976@gmail.com> writes:
> On Mon, Aug 17, 2009 at 12:17 PM, Tom Lane <tgl@sss.pgh.pa.us> 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 ...

> Latest checkpoint's NextXID:          0/308829887

Hmm, well, they're in the past *now*, but by less than 20000
transactions.  You said this was a production DB so that might not
represent very much elapsed time.  Does the DELETE still fail?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Bob Gobeille
Дата:
Сообщение: psql command line editor
Следующее
От: Nuno Mota
Дата:
Сообщение: Re: plpython return setof and yield