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

Поиск
Список
Период
Сортировка
От Jerry Gamache
Тема Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze
Дата
Msg-id 4B73196A.3030100@idilia.com
обсуждение исходный текст
Ответ на Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Jerry Gamache
Дата:
Сообщение: Re: BUG #5321: Parallel restore temporarily deadlocked by autovacuum analyze
Следующее
От: Koichi Suzuki
Дата:
Сообщение: Bug on pg_lesslog