Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze
Дата
Msg-id 20100210150619.GB4922@alvh.no-ip.org
обсуждение исходный текст
Ответ на BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze  ("Jerry Gamache" <jerry.gamache@idilia.com>)
Ответы Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze  (Jerry Gamache <jerry.gamache@idilia.com>)
Список pgsql-bugs
Дерево обсуждения 
Jerry Gamache wrote:

> The restore resumed while I was writing this report, and I saw these new
> entries in the logs:
>
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "database1.public.table_y"
> ERROR:  canceling autovacuum task
> CONTEXT:  automatic analyze of table "database1.public.table_y"

This is what I would have expected to happen almost immediately ... what
are your autovacuum settings?  And what's your deadlock timeout?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Oleg Serov
Дата:
Сообщение: Re: BUG #5314: Error in nested composite types in plpgsql.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze