Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
ERROR 5156: Unavailabler: initiator locks for query - Locking failure: Timed out X locking
I get ERROR : 5156 while triggering below mentioned query
aqua=> DELETE FROM public.customer_dimension WHERE where cell_id=0
ERROR 5156: Unavailabler: initiator locks for query - Locking failure: Timed out X locking Table:ncell.CUSTOMER_DIMENSION. X held by [user ncellah (delete from ncell.access_dimension where cell_id=0). Your current transaction isolation level i s READ COMMITED
I following this link as well LOCK
BUT My question here is what is the steps if i wanted to UNLOCK and trigger following query succesffuly
DELETE FROM public.customer_dimension WHERE where cell_id=0