We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


ERROR 5156: Unavailabler: initiator locks for query - Locking failure: Timed out X locking — Vertica Forum

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
 

Comments

  •  Identify the session that has a lock on the  table and take action kill it,let it finish,identify the bottleneck.

     

    See lock

     

    select * from locks:

     

    To monitor oll your sessions:

    - this will generate the kill syntax as well

     

    SELECT
    node_name
    ,user_name
    ,'SELECT CLOSE_SESSION(''' || session_id || ''');' AS CloseSession
    ,statement_start
    ,(GETDATE() - statement_start)::INTERVAL AS current_statement_duration
    ,REGEXP_REPLACE(current_statement,'[\r\n\t]',' ') AS current_statement
    ,session_id
    ,transaction_id
    ,statement_id
    ,client_hostname
    ,client_os
    ,login_timestamp
    ,runtime_priority
    ,ssl_state
    ,authentication_method
    ,transaction_start
    ,GETDATE() AS Today
    FROM v_monitor.sessions
    ORDER BY current_statement_duration DESC
    ;

  • Thanks Adrian. Thanks a lot

  •  This you got it fixed ? if so mark as fixed 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file