I ask you the following question to see if you can help me
Every day I come across the following locks, do you have any idea how to fix them?
LOG: process 11976 still waiting for ShareLock on transaction 3041474912 after 1000.041 ms Detail: Process holding the lock: 22780. Wait queue: 11976. Context: while updating tuple (157,8) in relation "um_user_attribute" Statement: UPDATE UM_USER_ATTRIBUTE SET UM_ATTR_VALUE=$1 WHERE UM_USER_ID=(SELECT UM_ID FROM UM_USER WHERE UM_USER_ID=$2 AND UM_TENANT_ID=$3) AND UM_ATTR_NAME=$4 AND UM_PROFILE_ID=$5 AND UM_TENANT_ID=$6
LOG: process 7588 still waiting for ExclusiveLock on tuple (158,78) of relation 25217 of database 22641 after 1000.042 ms Detail: Process holding the lock: 11118. Wait queue: 7588, 15295. Statement: UPDATE UM_USER_ATTRIBUTE SET UM_ATTR_VALUE=$1 WHERE UM_USER_ID=(SELECT UM_ID FROM UM_USER WHERE UM_USER_ID=$2 AND UM_TENANT_ID=$3) AND UM_ATTR_NAME=$4 AND UM_PROFILE_ID=$5 AND UM_TENANT_ID=$6
thanks a lot for your time!!!