s.in>; 'John R Pierce'
> <pie...@hogranch.com>; pgsql-
> gene...@postgresql.org
> Subject: Re: [GENERAL] Request to share information regarding deadlock in
> postgresql-9.3.6
>
> Hello
>
> > -Original Message-
> > From: pgsql-general-ow...@postgresq
s issue?
>
> Regards,
> Yogesh
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
> Sent: Thursday, November 17, 2016 12:04 PM
> To: pgsql-general@postgresql.org
> Subject: Re:
l.org] On Behalf Of John R Pierce
Sent: Thursday, November 17, 2016 12:04 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request to share information regarding deadlock in
postgresql-9.3.6
On 11/16/2016 6:22 PM, Yogesh Sharma wrote:
> process 5764 is waiting for relation (table
On 11/16/2016 6:22 PM, Yogesh Sharma wrote:
process 5764 is waiting for relation (table) with OID
16459(table2_primary_key), that table is blocked by process 4970 and process
4970 is waiting for a lock on another table, OID 16502(table1), which the first
process has a lock on.
Process 5764:
Dear All,
Thanks for your support.
Could you please share your opinion for deadlock resolution.
Process 5764 waits for AccessShareLock on relation 16459 of database 16385;
blocked by process 4970.
Process 4970 waits for ShareLock on relation 16502 of database 16385; blocked
by process 5764.