Re: Savepoint weirdness

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Savepoint weirdness
Дата
Msg-id 27938.1092590011@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Savepoint weirdness  (Gavin Sherry <swm@linuxworld.com.au>)
Ответы Re: Savepoint weirdness
Список pgsql-hackers
Gavin Sherry <swm@linuxworld.com.au> writes:
> Jason Godden pointed out some weird savepoint behaviour on IRC and i've
> narrowed this down to a simpler case.

The answer turns out to be that GetSnapshotData is miscomputing snapshot
xmin and RecentGlobalXmin when inside a subtransaction: it omits our own
top transaction ID from the set of open transactions.  The presence of
the unique index makes a difference because in the unique-index-check
code, we check the existing rows using the bogus data, and actually end
up concluding that the original rows being updated are globally dead,
and marking them so.

I'm surprised that we didn't find this one much earlier :-(
        regards, tom lane


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