Deadlock when inserting from multiple processes

From: Dave Johansen <davejohansen(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Deadlock when inserting from multiple processes
Date: 2016-04-27 19:10:24
Message-ID: CAAcYxUfVFAPVhSpX5sySvRiCevwtkYY8SVMdmYwR3XobmuW75Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm using Postgres 9.2.15 on CentOS 7.2 with the method described below to
support INSERTing from multiple processes:
http://www.postgresql.org/message-id/CAAcYxUf9o3NpiKaHdeShO_iJjm92314eX6ko0JvJidmksutkJg@mail.gmail.com

Last night, one of the processes experienced a dead lock. The error looked
like this:
ERROR: deadlock detected
DETAIL: Process 23527 waits for ShareLock on transaction 1537228819;
blocked by process 34184
Process 34184 waits for ShareLock on transaction 1537228441;
blocked by process 23527.

Is there anything I can do to help diagnose what the cause of this issue
was?

Thanks,
Dave

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2016-04-27 20:45:26 Re: Deadlock when inserting from multiple processes
Previous Message Guillaume Lelarge 2016-04-25 16:58:40 Re: [ADMIN] RE: 回复:[ADMIN] pgadmin select slow than psql command much