update recipient causing row level lock in postgresql | Community
Skip to main content
August 11, 2023
Question

update recipient causing row level lock in postgresql

  • August 11, 2023
  • 1 reply
  • 949 views

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.

1 reply

SatheeskannaK
Community Advisor
Community Advisor
August 11, 2023

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

Thanks, Sathees
sean_kimAuthor
August 17, 2023

It's campaign classic