Re: deadlock in single-row select-for-update + update scenario? How could it happen? - Mailing list pgsql-general

On 08/22/2014 10:36 AM, hubert depesz lubaczewski wrote:
> On Fri, Aug 22, 2014 at 7:20 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     So why are different processes running the exact same queries coming
>     in on different ports?
>
>
> the importer is parallelized, and sometimes two processes handle batches
> of data that happen to update the same "top level row".
>
> but the deadlocking problem is happening only on one machine, though
> very repeatably.

Which begs the question, what is different about that machine?

>
> depesz


--
Adrian Klaver
adrian.klaver@aklaver.com