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
Hi
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
PLEASE SUGGEST
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
Identify the session that has a lock on the table and take action kill it,let it finish,identify the bottleneck.
See lock
To monitor oll your sessions:
- this will generate the kill syntax as well
Thanks Adrian. Thanks a lot
This you got it fixed ? if so mark as fixed