Postgres Pro
Downloads
Home   >   mailing lists

Deadlock when inserting from multiple processes - Mailing list pgsql-admin

From Dave Johansen
Subject Deadlock when inserting from multiple processes
Date
Msg-id CAAcYxUfVFAPVhSpX5sySvRiCevwtkYY8SVMdmYwR3XobmuW75Q@mail.gmail.com
Whole thread Raw
Responses Re: Deadlock when inserting from multiple processes  (Keith <keith@keithf4.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: [ADMIN] RE: 回复：[ADMIN] pgadmin select slow than psql command much
Next
From: Keith
Date:
Subject: Re: Deadlock when inserting from multiple processes