Re: BUG #11025: could not access status of transaction 7

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #11025: could not access status of transaction 7
Дата
Msg-id 20140724165415.GH5475@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: BUG #11025: could not access status of transaction 7  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #11025: could not access status of transaction 7  (enzesheng <enzesheng@gmail.com>)
Список pgsql-bugs
Tom Lane wrote:
> shiguangsheng@huawei.com writes:
> > PostgreSQL version: 8.3.17
>
> 8.3 is long out of support (and 8.3.17 even more so).
>
> > I added a function that is used to scan the specified table.
>
> You didn't show us enough of that function to be sure, but I rather
> suspect that you're failing to pay attention to the
> XMIN/XMAX COMMITTED/INVALID status bits.

Also need to check HEAP_XMAX_IS_MULTI.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 9.2.7 on Power 8 / AIX 7.1
Следующее
От: David Leverton
Дата:
Сообщение: Re: BUG #10533: 9.4 beta1 assertion failure in autovacuum process