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.
In response to
pgsql-bugs by date
|Next:||From: Koichi Suzuki||Date: 2010-02-11 14:35:35|
|Subject: Bug on pg_lesslog|
|Previous:||From: Alvaro Herrera||Date: 2010-02-10 20:26:24|
|Subject: Re: BUG #5321: Parallel restore temporarily deadlocked by