| From: | Yogesh Sharma <Yogesh1(dot)Sharma(at)nectechnologies(dot)in> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Request to share information regarding deadlock in postgresql-9.3.6 |
| Date: | 2016-11-17 02:22:58 |
| Message-ID: | 8F86F8F397DDD345B25EA2EF3E2164829ECBA652@EXCH-MB02-U1.nectechnologies.in |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
It means we have two processes that are each waiting for locks the other have.
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: INSERT INTO table2 ( id , roll_number, name) VALUES( '1', '4','abc' )
Process 4970: REINDEX TABLE table1, table2 etc..
How to resolve this problem?
Regards,
Yogesh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dhaval jaiswal | 2016-11-17 02:30:02 | pg_class (system) table increasing size. |
| Previous Message | Adrian Klaver | 2016-11-17 01:24:44 | Re: Streaming replication failover/failback |