Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze - Mailing list pgsql-bugs

From Jerry Gamache
Subject Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze
Date
Msg-id 4B73196A.3030100@idilia.com
Whole thread Raw
In response to Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-bugs
Alvaro Herrera wrote:
> Jerry Gamache wrote:
>
>> Yes, I have PID in the logs now. Problem was observed around 13h30,
>> and there was no log output between 13h18 and 13h30.
>> There are messages for table_b (pid 18350) and table_c (pid 18406),
>> but none for table_a.
>>
>
> Eh, but according to the pg_locks snap you posted, the PID holding the
> table_b lock is (was?) 20490.
>
>
20490 is the relid of table_b. The PID holding the lock on table_b is 18406.

pgsql-bugs by date:

Previous
From: Jerry Gamache
Date:
Subject: Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze
Next
From: Koichi Suzuki
Date:
Subject: Bug on pg_lesslog