Re: [HACKERS] Aborted Transaction During Vacuum

Поиск
Список
Период
Сортировка
От G. Anthony Reina
Тема Re: [HACKERS] Aborted Transaction During Vacuum
Дата
Msg-id 37B4ECCD.DF56BA7D@nsi.edu
обсуждение исходный текст
Ответы Re: [HACKERS] Aborted Transaction During Vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom and Oliver,
   I added the patch and re-built everything. No more problems with the
vacuum analyze (knock on wood since this is still Friday the 13th).
   Tom, does this patch address the problem you found in your
EndPortalAllocMode comments? I'm just wondering whether another patch
will be needed or if this one should cover the problem.

Thanks again for the help guys.
-Tony


Tom wrote:
> (a) vacuum.c does a CommitTransaction to commit its final table's
>   worth of fixes.

> (b) CommitTransaction calls EndPortalAllocMode.

> (c) vacuum calls vc_shutdown, which tries to remove pg_vlock,   and reports an error when the unlink() call fails.

> (d) during error cleanup, AbortTransaction is called.

> (e) AbortTransaction calls EndPortalAllocMode.  There has been no
>   intervening StartPortalAllocMode, so the portal's context stack
>    is empty.  EndPortalAllocMode tries to free a nonexistent memory
>   context (or, if you have asserts turned on, dies with an assert
>    failure).  Ka-boom.





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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: How to get 'psql -q' runs really quiet ?
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] Re: We won!