Skip to main content
Aug 11, 2023 6:10 AM UTC
Question

update recipient causing row level lock in postgresql

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.

 

regards,

sean

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SatheeskannaK
Adobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
Aug 11, 2023 1:59 PM UTC

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

Translate
Thanks, Sathees
sean_kimAuthor
Aug 17, 2023 9:41 AM UTC

It's campaign classic

Translate