Re: [GENERAL] Advisory lock deadlock issue

2017-06-07 Thread David Rosenstrauch
On 06/07/2017 10:32 AM, Merlin Moncure wrote: On Wed, Jun 7, 2017 at 9:16 AM, David Rosenstrauch wrote: * How could it be possible that there are 2 PG processes trying to acquire the same lock? Spark's partitioning should ensure that all updates to the same user record get routed t

[GENERAL] Advisory lock deadlock issue

2017-06-07 Thread David Rosenstrauch
I'm running a Spark job that is writing to a postgres db (v9.6), using the JDBC driver (v42.0.0), and running into a puzzling error: 2017-06-06 16:05:17.718 UTC [36661] dmx@dmx ERROR: deadlock detected 2017-06-06 16:05:17.718 UTC [36661] dmx@dmx DETAIL: Process 36661 waits for ExclusiveLock o