Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!

update recipient causing row level lock in postgresql


Level 1

hello sir/madam, 

I'm having issue with update of recipient table.

the issue i'm having is that in order to update, campaign acquires row level lock using select ... for update statement.

however the issue is that there's 2 tables involves with the 'select for update' statement using join.

let me explain with an example. 

something like this will be executed prior to update.

select a....

  from tablea 

   join tableb

    on tablea.o = tableb=o

 where tableb.c = $1

    and tablea.d = $2

     for update;


the problem is that the value of $2 is different but $1 has same value which is causing row level lock in tableb.

I'm considering using custom query for the update job but having difficulty adapting it.


could anyone give me some advice ? 


thank you in advance.






Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies


Community Advisor

@sean_kim, Are you running this query on Adobe Campaign Standard? 

Thanks, Sathees