Re: VACUUM/t_ctid bug (was Re: GiST concurrency commited)

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема Re: VACUUM/t_ctid bug (was Re: GiST concurrency commited)
Дата
Msg-id 200508301158.37593.mweilguni@sime.com
обсуждение исходный текст
Ответ на Re: VACUUM/t_ctid bug (was Re: GiST concurrency commited)  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: VACUUM/t_ctid bug (was Re: GiST concurrency commited)  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
Am Dienstag, 30. August 2005 11:25 schrieb Teodor Sigaev:
> Fixed in 8.0, 7.4 and 7.3 branches.
>
> Tom Lane wrote:
> > Teodor Sigaev <teodor@sigaev.ru> writes:
> >>http://www.sigaev.ru/gist/concur.pl
> >>http://www.sigaev.ru/gist/concur.sh
> >
> > BTW, these scripts seem to indicate that there's a GIST or
> > contrib/intarray problem in the 8.0 branch.  I was trying to use 'em
> > to test REL8_0_STABLE branch tip to verify my t_ctid chain backpatch,
> > and I pretty consistently see "Problem with update":
> >
> > Start: parallel mode with 4 flows
> > Problem with update {77,77}:0 count:1 at concur.pl line 91.
> > Issuing rollback() for database handle being DESTROY'd without explicit
> > disconnect(). Problem with update {43,24}:3 count:1 at concur.pl line 91.
> > Issuing rollback() for database handle being DESTROY'd without explicit
> > disconnect(). Problem with update {43,43}:2 count:1 at concur.pl line 91.
> > Issuing rollback() for database handle being DESTROY'd without explicit
> > disconnect(). 1 flow finish. Stats: ni:75000 nu:1661 nd:216 nv:13(nf:3)
> > nt:780 All flow finish; status: 255; elapsed time: 265.48 sec
> >
> > Is this something that can be fixed for 8.0.4?
> >
> >             regards, tom lane

Since 7.4 we have troubles with ltree (seldom corruption of buffer cache, not 
on-disk), might this bug be somehow related to the ltree problem?
7.2 was rock-stable with ltree.

Best regards,
Mario Weilguni


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Pre-allocated free space for row updating (like
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: VACUUM/t_ctid bug (was Re: GiST concurrency commited)