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

Alvaro Herrera <alvherre@commandprompt.com> writes:
> 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?

The other details showed the blockage as being on table_x though.
Was that a typo in obscuring the details, or did the cancel really
happen on an unrelated table?

            regards, tom lane